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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Error when creating ne...
Power Automate
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.

Categories:
  • Verified answer
    henkenTech Profile Picture
    135 on at

    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

    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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
Mohsin Ali Profile Picture

Mohsin Ali 377

#2
11manish Profile Picture

11manish 302 Super User 2026 Season 2

#3
Henil Profile Picture

Henil 130

Last 30 days Overall leaderboard