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

(0) Share

Report

Posted on by CarolinaSanchez

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!

All responses (1)

Answers (1)

Verified answer

annajhaveri 8,531 on at

Like (1)

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

@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'))