I cant get the following scenario to work. I have a sharepoint list with a date colum "Sluttdato". Evryday I want a flow to run and send email for that list item if the Sluttdato is equal to today date. I have tried the following condition, but it doesnt work. Any tips?
I also try to send my self an email with utcnow('yyyy-MM-dd'), but i cant get it to send the date only the text utcnow('yyyy-MM-dd') is displayed. Any tips to send email with functions like this?
In what format is your data returned if you do a Get Items on the list? SharePoint support multiple date and time formats. You can pick the right format accordingly. Since the data itself is a "string", you may have to use string manipulation functions - like substring() as well.
Date is returned in the following format 2016-06-30, but i found why the comdition didnt work. The list item returns the date before what is in the list?
For example if 2016-06-30 is the date in the list returning this date trough the flow gives me 2016-06-29 and returning 2016-07-01 gives med 2016-06-30. Weird, but maybe there is some timezone difference that makes this behaviour?
Check out the announcement of Power Platform content at Microsoft Ignite!
Join us for an in-depth look at the new Power Automate features and capabilities at the free Microsoft Business Applications Launch Event.
Features releasing from October 2020 through March 2021