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 Automate - Building Flows
Answered

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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 722 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 461 Moderator

#3
developerAJ Profile Picture

developerAJ 283

Last 30 days Overall leaderboard