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!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
88 | |
57 | |
40 | |
37 | |
29 |
User | Count |
---|---|
73 | |
66 | |
50 | |
47 | |
43 |