I have a flow that I can run manually, but I am trying to set it up to automatically run 1 a day and to pull from a column and if there is an entry with the current date, create a task.
My flow hangs up on getting the data.
Specifically no data is found. I am relatively new to Power Automate but cannot work out how to get this setup, any suggestions would be appreciated.
In the Excel action, set the DateTime Format to ISO 8601 format from the drop-down menu.
Use the formatDateTime expression on the UTCNow date and format it as 'yyyy-MM-dd', which is the ISO8601 date format.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.