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!
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.