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

All responses (2)

Answers (1)

KRees on at

Like (0)

Report

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

Perfect! Thanks so much
Verified answer

ManishSolanki 15,085 Super User 2025 Season 1 on at

Like (1)

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

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.