Flow Just Stopped Working (due to dates)

[ClintRB]

Hi,

I have a flow that has been working without problem for 2 weeks and today it failed and I cannot workout why.

Fails at Filter Array

@equals(addDays('1899-12-30', int(item()['ADDENDUMDATE']), 'dd-MM-yyyy'), utcNow('dd-MM-yyyy'))

This is the error details

The execution of template action 'Filter_array' failed: The evaluation of 'query' action 'where' expression '@equals(addDays('1899-12-30', int(item()['ADDENDUMDATE']), 'dd-MM-yyyy'), utcNow('dd-MM-yyyy'))' failed: 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.

Hopefully this is just a temporary issue with Power Automate however if someone know a better way it would be great to know.

Thank you

Clint

[CFernandes]

@ClintRB 

Hey Mate,

Microsoft has recently changed how Date and time are managed. It does not return a serial value.

See the twitter status-  https://twitter.com/mofumofu_dance/status/1349947965981356032 

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[ClintRB]

@CFernandes  thankyou for the quick reply.  Do you know of or can you suggest a solution? 

Thanks

Clint

[CFernandes]

Hey @ClintRB ,

I think direct comparison should work now.

formatDateTime(<your row value,'yyyy-MM-dd')

is equal to 

formatDateTime(utcNow(),'yyyy-MM-dd')

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

[ClintRB]

Hi @CFernandes thanks again but still no joy.  If hjave tried all of the recommended formats but keep getting

"DUE DATE": "@formatDateTime('DUE DATE','yyyy-MM-dd')"
}' failed: 'In function 'formatDateTime', the value provided for date time string 'DUE DATE' was not valid. The datetime string must match ISO 8601 format.'.

If I dont use an expression then this is the result I keep getting.

Cheer

Clint

[ClintRB · Accepted solution]

@CFernandes I found the solution.

formatDateTime(item()?['DUE DATE'],'dd-MM-yyyy')

Thanks for replying to my question.