-
So - the dropdown needs a filter added that the account id from the people picker is equal to the account id for the user in List A - you can add a filter when you select the data for your dropdown. You probably have to put the data source in "advanced" mode to see the account id in the people picker. Feel free to attach a copy of your ...
-
It will be blank until the form is submitted, at which point it will be populated. So when you re-open the form, does the data show?
-
I am going to guess that your data connection is set to run on load. You can check that by modifying the data connection and on the last screen make sure the checkbox to run the query when the form is opened is not selected.
-
You won't be able to control this in the list itself (i.e. if the user opens the list, and puts it in quick edit mode or something). But in the form, you can check if the Supply Chain Approver accountid field is not equal to the username function. For the conditional formatting on the status field, in the first dropdown, find the group for the ...
-
Make sure Windows and Office updates are installed on the machine you publish from - one of the updates fixed that truncated message box. You can also check the event log where you are publishing. Open event viewer, then go to Applications and Services Logs > Microsoft Office Alerts.
-
No. The ID column is an auto-incremented integer from SQL and that is just the way those work.... at any point when an item is deleted, the ID will never be re-used.
-
Ah, glad you got it sorted!
-
Is this a browser form? Was it working in the browser before and just now broke? Are you using SharePoint online or on-prem? I just tried adding a new validation rule to a field in a form (attached - save the attached file locally, right click and select design and you can see the validation rule on the date time field) and it appears to be ...
-
I see - so the problem you will have here is that out of the box InfoPath is not going to support passing in form values to your SQL Where clause. You have to return all the data, unless you write code or use a third party tool like a web service or qRules in your form. Is there any chance this data could also be in a SharePoint list, via BDC or ...
-
I don't think this is possible without code. If you are using on-prem SharePoint, you should be able to find some code samples online that will work for you. If you are using Office 365 for SharePoint, browser forms with code are no longer available, so it may not be possible.