I have created a flow and I am using a formula formatDateTime(utcNow(),'yyyy-MM-dd') to get current date.
The problem is my flow is a recurrence and when it runs at the specified time its not calculating the current date but when I am running it manually by clicking the start button its giving me correct and current date.
As you can see in the below images the same flow ran on the same date but different time and its giving different date using the formula i mentioned above.
Solved! Go to Solution.
Thanks for the answer but i didnt select any timezone in the recurrence trigger but now I have selected the timezone and will test it.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Read the latest about new experiences and capabilities in the Power Automate product blog.
If you are a small business ISV/Reseller, share your thoughts with our research team.