Showing results for 
Search instead for 
Did you mean: 
Not applicable

Flow that runs every monday and tuesday on the first and last week of the month

Hi All,


I am working on a flow that schedules the dates events should run and then runs on the scheduled date. For instance there are events that should run on the First, second and third Tuesday of the month. There are some that should run one the first and last Friday of the month. The flow gets its data from a SharePoint list. There is a SharePoint column that stores the weeks each item should run and another that contains the day it should run.


Please can anyone suggest ideas of how this flow could work? I am new to flow automate so any help would be appreciated

Super User
Super User

So I guess you can run an schedule flow everyday, read all Sharepoint list items and filter:
1.-rows whose target week that matches with flow execution week nr, and
2.-rows whose target dayofweek matches with flow execution dayofweek.
One of the challenges is to calculate the week your schedule flow is executed, and compare it to each row's expected week... great stuff here GET WEEK NUMBER FROM CURRENT DATE - Power Platform Community (
Next challenge, how to obtain current dayOfWeek, is easier, since there is an WDL function for such purpose: 
Power Automate Fundamentals # 12: Usage of DayofWe... - Power Platform Community (

Hope this helps

Each time you click on any of our inspiring answers 'Thumb up' icon... ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!

Escribo sobre Power Automate en:

Proud to be a Flownaut!

Helpful resources

Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (1,664)