I read a lot of topics regarding comparing dates in Power Automate. My flow runs without an error but the result is not accurate, basically it returns every record. I suspect it has something to do with the date formatting, but the output date has the same formatting as the expression, so I am a bit confused. The only difference is in the visual representation of the column in SPO. Recreating the column from scratch is not an options because I have a lot of records.
Solved! Go to Solution.
Thanks. Can you briefly explain or provide a link what is the difference between using single and double quotes when comparing a date? I thought that I had to provide a string for comparison?
By putting it in single quotes you were creating a string with the content that is inside of the quotes
You were trying to use an expression but by putting anything inside single quotes in Power Automate it is a string. The function is not sent as a string, but the argument (what's inside the parentheses) is a string.
Hope that helps.
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!