-
Sorry I was slow to see this - were you able to get this resolved? Are you able to open the form in design mode but not open the published form?
-
Thanks for double checking and updating with your findings! Yeah, we are all waiting for stuff to break in SharePoint Online all the time - I completely understand :-)
-
When you change business level 0, you need to add rules to set all the fields bound to dropdowns for level 1 to blank. You need rules on all the fields for dropdowns for level 1 to set the respective dropdowns for level 2 to blank. You need to double check all your conditional formatting - I see some rules that aren't resolving correctly ...
-
Emailed form views are finicky. I've had a number of controls not render correctly, tables look wacky, and so on. Could be that People Pickers are just in the realm of "controls that don't render nicely in email". :-)
-
This really depends on your formatting conditions. Any chance you can attach a copy of the form under the Options tab in a reply?
-
SharePoint workflow is going to be the way to go, I think (or MS Flow if Office 365?) Start the workflow or Flow when the form is submitted and pause until the expiry date.
-
I would add a status field to the main data source (doesn't have to show on the form) and set it to "Submitted" when the form is initially submitted. Then you can leverage that field for hiding or disabling the submit button, blocking submit via a rule condition, prevent the workflow from running via a condition, and so on.
-
It will in simpler parent child relationships - like when there is a parent table with one or more child tables - but I think the structure here is beyond what it will support.
-
From the controls pane, select a calculated value control. From the formula editor, select the main data source. Be sure it is showing in the advanced view. Navigate to the display name field for your people picker and select it.
-
I'd guess the people picker is just not displaying correctly in the email. If you show the advanced view of the schema in the fields task pane in InfoPath, you should be able to add a calculated value for the Display Name in the people picker - I'd do that and see if it shows correctly in the email. If it does, you could add some form ...