Skip to main content

Notifications

Announcements

Announcing our 2025 Season 1 Super Users!
Welcome to the Power Platform Communities
Join us for the Powerful Devs Hack Together
Announcing Forum Attachment Improvements!
News and Announcements icon
Power Platform Community / Forums / Power Automate - Building Flows / Error When Trying to C...
Power Automate - Building Flows
Suggested answer

Error When Trying to Create SP List Item from Blank MS Forms Responses

(1) ShareShare
ReportReport
Posted on by Nathan Isaacson
Hi everyone,
 
I have a relatively simple flow, in essence it takes responses from an MS Forms submission and uses it to create a SP item.  There are certain restricted questions in the MS Forms, for example: date only, number only, character limit, etc.  It is a very long form with lots of branching so many questions will sometimes not have responses.  I am encountering an error with the 'Create item' action in Power Automate when I try to place these unpopulated, restricted responses into the action.  The error doesn't occur if the unpopulated field is not restricted (i.e. free text with no restrictions).  And say, for instance, that field is populated in one of the submissions, the error does not appear.  Any suggestions on how I might be able to avoid this?  I've attached a screenshot of the error for reference.  Thank you!
Categories:
Business Process Flows
2025-01-16_01-27-...
  • trice602 Profile Picture
    trice602 11,643 on at
    Error When Trying to Create SP List Item from Blank MS Forms Responses
    BTW: disregard the create worksheet content in my example, just showing you how to use if and empty together to handle blank values when writing to your list.
  • Suggested answer
    trice602 Profile Picture
    trice602 11,643 on at
    Error When Trying to Create SP List Item from Blank MS Forms Responses
    Hi,
     
    I typically use an if and empty expression together so in the case of a field with no value from the Form you can see if it is empty, if true, insert null as the value (or 0 I use sometimes for numeric fields), null works great for date columns.
     
    If not empty, then you write the value from the form shown below.  In my example, if the 'name' question is empty, I am writing null (in case it is a required field in the List).
     
     

    ------------------------------------------------

     

     

    ⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

     

     

    Always glad to help! 💯💯💯💯💯

     

    Tom

     

    Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

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

News and Announcements

Announcing our 2025 Season 1 Super Users!
Welcome to the Power Platform Communities
Join us for the Powerful Devs Hack Together
Announcing Forum Attachment Improvements!

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans