
Announcements
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...
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.
@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.