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

Like (0) Share

Report

Posted on 13 Sep 2021 06:50:06 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 Most Valuable Professional on 14 Sep 2021 at 09:31:23

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