Unanswered

Flow to create item in SharePoint List when Form is submitted fails when no date entered for one question

(0) Share

Report

Posted on by MS07

I have a Microsoft Form which will populate a SharePoint list.

On the form is a "date access required until" question, which is a date field. This question does not always require an answer so may be left blank. However when it is left blank the Flow to create the item in the SharePoint list fails with:

OpenApiOperationParameterTypeConversionFailed. The 'inputs.parameters' of workflow operation 'Create_item' of type 'OpenApiConnection' is not valid. Error details: Input parameter 'item/Daterequireduntil' is required to be of type 'String/date'. The runtime value to be converted doesn't have the expected format 'String/date'.

Can I get round this at all?

Secondary question - If there is a date entered, and this appears in the SharePoint List, I would like an email notification on the date that has been entered. Does this require me to NOt have this field as a date/time filed in SharePoint List?

Thank you.

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Lochwood 16 on at

Like (0)

Report
Copy link

Link copied!

I cant seem to get this working.. the error I get in flow.. " The expression is invalid"

Was this reply helpful? Yes No
RezaDorrani 12,143 on at

Like (2)

Report
Copy link

Link copied!

Hi @MS07

You can keep the date field in SharePoint

when adding item in SharePoint using Flow

for the date field add the following expression

if(empty(datefield),null,datefield)

Where datefield - dynamic content date field value from MS Form

This will set it to null/empty in SharePoint if no value
or populate it with data

For sending email id date is filled
Add a condition in flow
Use flow condition your datefield is not equal to null and send email

Regards,
Reza Dorrani

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Was this reply helpful? Yes No
ScottShearer 25,270 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@MS07

I am unable to replicate your issue. Can you please do the following so that I and others might assist:

1) Verify that both the SharePoint column and the Forms field are both configured to be dates?

2) Post a screen shot of your Flow

I tested a Flow and it ran successfully with and without a date entered in Forms.

Also, regarding the email, you'll probably want to create a separate Flow with a recurrence trigger configured to run once a day. Then, use a Get Items action with an OData filter. Using the filter will limit the items returned to those with a date in your date column of today. Then simply loop through the results and send your email. The SharePoint column should be a date column.

Was this reply helpful? Yes No