web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Error when creating ne...
Power Automate
Unanswered

Error when creating new SharePoint list item using response from Microsoft Forms

(0) ShareShare
ReportReport
Posted on by 7

I have a form set up that includes two fields where the user can input an email address. One of the fields is required, the other isn’t. The flow is set up where once a user submits their response, the response is used to create a new item in a SharePoint list. The flow works when both fields are filled out. However, when the field that isn’t required is left blank, that’s where it runs into an issue. It gives me an error that the specific user  could not be found. I’m guessing this means that the blank “” user could not be found in our organization when trying to create a new list item. Is there a way around this? If a user leaves the unrequired field in the form blank, I want it to be left empty in the list column.

 

I know one way to go around the error is to set the column for that unrequited field as a single line of text instead of people or group in the SharePoint list. However, I don’t want to do that because I want the person’s profile to show in the SharePoint list.

Categories:
I have the same question (0)
  • Verified answer
    henkenTech Profile Picture
    135 on at
    Re: Error when creating new SharePoint list item using response from Microsoft Forms

    Hey there,

     

    you could try it with this expression for the SP field (untested): 

     

    if(greater(length(EMAILFIELD), 0), EMAILFIELD, null)

     

    replace EMAILFIELD with the dynamic reference to the feld with the MS Forms response.

     

    Alternatively, leave the field blank in your create action and create a conditions that if length(EMAILFIELD) is greater than 0 -> Update item and set the value of the field to the email field from Forms.

     

    Hope this help,

     

    Max 

  • conums Profile Picture
    7 on at
    Re: Error when creating new SharePoint list item using response from Microsoft Forms

    Thanks for the help! The expression worked and now the flow runs.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 462 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 456 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard