Answered

String/date-time error in a flow if field is blank from a Microsoft Form to Dataverse

(0) Share

Report

Posted on by KRees

I have an automated flow from Customer Voice Form to Dataverse that works if a date is selected in the Form field 'Renewal Date', but if it is left blank the flow errors with the following:

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

I would be grateful if I could be guided on how to resolve this

With many thanks

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Manish Solanki 15,167 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @Xch21

Pls try using if() function to check for empty or blank value in form field:

if(empty(<dynamic value of renewal date>),null,<dynamic value of renewal date>)

If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.

Was this reply helpful? Yes No
KRees on at

Like (0)

Report
Copy link

Link copied!

Perfect! Thanks so much

Was this reply helpful? Yes No