I have a sharepoint List and a flow which compares the date today and the date inside the SP List. however there are logical issues on this formula
If the Date is 01/02/2020 the condition returns as false (wrong behavior output)
If the Date is 10/16/2019 the condition returns as false (wrong behavior output)
If the Date is 12/07/2019 the condition returns as true (correct behavior)
if the Date is 06/01/2019 the condition returns as false (correct behavior)
Am I missing some statements on my formula?
Solved! Go to Solution.
Hi @gcmorales2000 ,
When comparing Dates in Power Automate, the sizes are compared in order starting from the first number of Date, so we need to unify the format of Date to "yyyy-MM-dd" so that we can compare the sizes accurately.
In addition, in SharePoint, if the field format is Date and does not contain time, then its default format is "yyyy-MM-dd". So you only need to format utcNow() into "yyyy-MM-dd".
Best Regards,
@gcmorales2000 when you're doing date comparisons, always make sure you use yyyy-MM-dd format.
Rob
Los Gallardos
If I've answered your question or solved your problem, please mark this question as answered. This helps others who have the same question find a solution quickly via the forum search. If you liked my response, please consider giving it a thumbs up. Thanks.
Hi @gcmorales2000 ,
When comparing Dates in Power Automate, the sizes are compared in order starting from the first number of Date, so we need to unify the format of Date to "yyyy-MM-dd" so that we can compare the sizes accurately.
In addition, in SharePoint, if the field format is Date and does not contain time, then its default format is "yyyy-MM-dd". So you only need to format utcNow() into "yyyy-MM-dd".
Best Regards,
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
85 | |
58 | |
49 | |
39 | |
35 |
User | Count |
---|---|
91 | |
76 | |
74 | |
60 | |
42 |