Hi team.
I have a question I am hoping someone can help with.
Scenario:
I have created a flow that takes the input from a MS Form, creates an item in a SharePoint list, then send out a bunch of approvals depending on selected options.
It is triggered when a form is submitted > gets form details > gets user details > then creates the item.
In the form the submitter needs to enter their manager, but if they have special requirements they need to enter a delegate, but not necessarily.
The Create Item action is failing if the submitter doesn't enter a delegate as the user is not recognised, because the delegate field is left blank.
That field needs to be filled in for the flow to create the item in the SP list and continue to the next step of the flow.
Question:
Is there anyway I can tweak the expression in power automate to say leave blank, or fill with 'blank' or something, if the field in the form is left empty? To enable to item to be created and the flow to continue.
Thanks all
Dallas
Solved! Go to Solution.
Hi @DallasBland :
I suggest you create a variable. When the field in the form is empty, the variable value is empty. When the field in the form is not empty, search for user information and get the user name and save it in this variable.
Finally, use the value in the variable when submitting the item.
Best Regards,
Bof
Hi @DallasBland :
I suggest you create a variable. When the field in the form is empty, the variable value is empty. When the field in the form is not empty, search for user information and get the user name and save it in this variable.
Finally, use the value in the variable when submitting the item.
Best Regards,
Bof
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
32 | |
28 | |
27 | |
21 | |
10 |