Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

Creating Null values in a SharePoint list from A MS Forms submission

(0) ShareShare
ReportReport
Posted on by 1,081
Hi,

I have a MS Form that contains some branching.

Is the user selects No then some questions that relate to Dates are not answered.  The column the data is writing to in SP is a Date and time field. And require column contains information toggle is set to No.

I'm using these action in my Flow

I've used the Expression 'Null' in the Value field for the initialize variable. Flow Failed.
 
 
and getting this error
 


but no value has been entered in the Form



 
 
 
  • Suggested answer
    David_MA Profile Picture
    David_MA 9,039 on at
    Creating Null values in a SharePoint list from A MS Forms submission
    In the create item action, use a coalesce expression instead. For example: coalesce(outputs('Get_item')?['body/Project'],''). It will return the first non-null value. By setting the second option to '' it should create the item with a blank date.
  • mmbr1606 Profile Picture
    mmbr1606 10,450 on at
    Creating Null values in a SharePoint list from A MS Forms submission
    can u try to use [ ] in your set varible step instead of null? [ ] sets it to null/empty
     
     
    if my reply helped please mark as verified answer,
     
     
    cheers

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

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,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard