web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / ReRunning a flow for a...
Power Automate
Answered

ReRunning a flow for a previous month

(1) ShareShare
ReportReport
Posted on by 13

Ahoi!

 

Hopefully simple query for you as I can't figure it out.

 

I have a flow which is setup to run at the start of every month which runs a stats query against a PowerBI dataset and emails the results to the operations team. Last Month (June) the query didn't run due to a problem with the email account privileges. I fixed the problem with the email account and now the flow is working correctly. However, I can't seem to rerun it for the previous month.

 

So far, I have tried to rerun the failed job however it only seems to give me the July data, not June. I have also tried to edit the Start date field and set it for May, however that didn't seem to work either. 

Screenshot 2024-07-08 083203.png

Screenshot 2024-07-08 083321.png

 

Is there a quick way to put in a custom date and time to rerun the query for the previous month?

 

Thank you!

Categories:
I have the same question (0)
  • Verified answer
    Kaif_Siddique Profile Picture
    2,108 Super User 2024 Season 1 on at

    Hi @AdrianOConnor ,

     

    vStartDate is retuning the July month date.

     

    Update the vStartDate with below expression then save and rerun

    formatDateTime(startOfMonth(addToTime(utcNow(),-1,'month')),'yyyy-MM-dd')

     

    Output:

    Kaif_Siddique_0-1720427862108.png

     

    Hope this will resolve your issue.

     

    Regards

    Kaif

  • AdrianOConnor Profile Picture
    13 on at

    Thank you Kaif, worked perfectly! 🙂

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 519 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 296 Moderator

#3
abm abm Profile Picture

abm abm 232 Most Valuable Professional

Last 30 days Overall leaderboard