Power Platform Community Forum Thread Details

I’m reaching out because I’m experiencing some issues with the automatic execution of my scheduled flows. While these flows work perfectly when I run them manually, they don’t trigger automatically at the scheduled time. I’ve reviewed the settings multiple times but can’t pinpoint the issue.

Additionally, I need assistance in creating a flow that triggers automatically on the last day of each month. I’ve tried various configurations and expressions, but none have been successful so far. All my configurations are set up in the cloud, and I’m using OneDrive for Business services. I would greatly appreciate your help in resolving these issues.

Thanks in advance for your assistance!

Categories:

General topics

Hi,

The recurrence should work at the time you selected. The problem is that you have not assigned the hours. You have to select the time in ‘At these hours’ and ‘At these minutes’. The ‘Start Time’ is the time when the flow recurrence will start. You can leave that empty or use an old date and time. In the preview, you can see when it will run.

To run a flow on the last day of every month, you have to create the flow to recur every day and check if that day is the last day of the month. They discussed how to do it in this other post

"

I think you would need to run your flow every day and then check to see if the current day is equal to the last day of the current month. This blog post will show you how to get the last day of the current month: How to Get Last day of current month in Power Automate - Debajit's Power Apps & Dynamics 365 Blog (debajmecrm.com)

Then you would have a condition where formatDateTime(utcNow(),'yyyy-MM-dd') equals the last day of the month. Note that in the blog post, they format the date as 'MM-dd-yyyy'. Be sure to format the last day of the month as 'yyyy-MM-dd' instead, which is the ISO 8601 date format that Power Automate likes best.

"

https://community.powerplatform.com/forums/thread/details/?threadid=b50c40d0-8e72-4ff1-8161-4d9596778942

Hope this helps.

Anthony.

If my reply answers your question, please like and mark it as verified. This helps me stay motivated to assist others and makes it easier for users with similar questions to find the answer. Thanks!
Feel free to connect with me on LinkedIn!