Compare Date, wrong data types

[alopez222]

I am trying to compare the date from the field MRP_Date with todays. If MRP_Date is greater then today then it will execute the actions in the yes side of the condition. However, I get an error the expected parameter needing to be a string type and that the one provided is a Null. I used the Get Item action before getting to the condition to look at the values and the MRP Date value is 2023-08-01. How do I fix this issue?

Some of the Flow:

MRP Date Value:

Error:

First Date:

Second Date:

[ChristianAbata]

hi @alopez222  try creating compose values and add the expressions on there. Then on condition use your compose outputs

[abm]

Hi @alopez222 

formatDateTime(outputs('Get_item')?['body/Start_x0020_Date'],'yyyy-MM-dd')

Is this date you comparing against utcNow()? The reason for the error is it is returning null value. Check the run history and see what value you are getting before the comparison.  To over come this error you could add extend the IF condition to check value is not null first then compare the dates.

Thanks

[alopez222 · Accepted solution]

I got the answer from a different question.

https://powerusers.microsoft.com/t5/Building-Flows/How-can-I-replicate-this-if-statement-from-sharep...