cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DallasBland
New Member

Create Item fails - user field left blank

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

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.

vbofengmsft_0-1639707759601.png

Best Regards,

Bof

 

 

View solution in original post

1 REPLY 1
v-bofeng-msft
Community Support
Community Support

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.

vbofengmsft_0-1639707759601.png

Best Regards,

Bof

 

 

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (1,266)