web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Flow failing (create S...

Power Automate

Answered

Flow failing (create SharePoint list) due to missing date in MS Forms

(0) Share

Report

Report

Posted on by CarolinaSanchez

10

Hello,

I have a flow that takes data submitted via a form, sends and email for approval, and adds the data to a Sharepoint list upon approval.

The problem is that the flow is failing when no data is entered in the date field of the MS Form (via the date picker calendar). This date field is not mandatory, and does not always need to have an input.

When a date is entered in MS Form, the flow works fine. Is only when no date is entered that the flow fails.

I have made sure that it in the date column settings on MS List, the "Require that this column contains information" is marked as "No".

Your help is appreciated!

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@CarolinaSanchez you check the value of date field from form, if its blank then provide null value for date field in Create Item. You can use expression like below, just replace outputs('Compose') with your date field of form

if(empty(outputs('Compose')),null,outputs('Compose'))

Was this reply helpful? Yes No

Join the conversation