Power Platform Community Forum Thread Details

Hello,

I created an automation that I want to change the status on a Sharepoint List if the Due Date past due and if the Date Completed is empty and keep getting this error below....

My flow is set up as shown...

2021-06-09 15_44_03-Window.png

If anyone can help he out it would be greatly appreciated. The more simplistic the solution the better. I'm new to Power Automate.

Thank you.

Categories:

General topics

@SLBMetrology using utcNow() gives output something like this - 2021-06-10T12:26:51.4798284Z

whereas the duedate u are passing seems to be null, hence it gives you error.

First you need to check the dateformat which you get in duedate, so add a compose before your comparison and see the dateformat, then you need to format your utc, then this work.

Format utc or your duedate like this - formatDateTime(utcNow(),'yyyy-MM-dd hh:mm:tt')

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.