Unanswered

function to check valid date

(0) Share

Report

Posted on by gunjan

Need to work with dates my flow works perfectly if i have date value , but if date is empty my if(express,true-part,false-part) fails and go with the error "Unable to process template language expressions in action 'Compose' inputs at line '1' and column '2321': 'In function 'formatDateTime', the value provided for date time string '' was not valid. The datetime string must match ISO 8601 format.'."

it works fine if i add Condition. issue date.jpg

Categories:

Using flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-xida-msft on at

Like (1)

Report

Hi @gunjan,

Have your solved your problem?

I agree with your thought almost, the formatDateTime() function requires its first parameter to be a datetime string which match ISO 8601 format, if you provided a empty value for the first parameter, the formatDateTime() function would fail.

More details about the formatDateTime() function, please check the following article:

formatDateTime() function

You could consider take a try to add a Condition to check if the date value is empty, if yes, do nothing, if no, convert the date value using the formatDateTime() function:

If your problem is solved, please click "Accept as Solution" so that this thread will be marked for other users to easily identify if your problem is solved.

Best regards,

Kris

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

If the datetime value format is not true, function formatDateTime() will be failed. How to resolve ?

Was this reply helpful? Yes No
SaiRaj3 6 on at

Like (2)

Report

You can do Exception error handling in Power Automate flow by using Scope Control and Configuring run after properly,

In Try Block of the Scope Control add that compose statement and in catch block configure it to run only when try is failed with a compose result('try') which has the Error JSON and add a Finally Block where you can check the length of that JSON identify if the Try has failed or not.

Best Regards,
Sai Raj

Was this reply helpful? Yes No