Skip to main content

Notifications

Power Automate - General Discussion
Answered

Issues with scheduled flow execution and monthly trigger setup

(1) ShareShare
ReportReport
Posted on by 4

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:
  • Suggested answer
    AnthonyAmador Profile Picture
    AnthonyAmador 2,524 on at
    Issues with scheduled flow execution and monthly trigger setup
    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.

    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!
     

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.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard