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

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

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

(0) ShareShare
ReportReport
Posted on by

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

I have the same question (0)
  • efialttes Profile Picture
    14,756 on at
    Re: Flow that runs every monday and tuesday on the first and last week of the month

    Hi!
    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 (microsoft.com)
    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 (microsoft.com)

    Hope this helps

  • Atulvijay Profile Picture
    10 on at
    Re: Flow that runs every monday and tuesday on the first and last week of the month

    I have the same requirement. I need to send a reminder email on every Monday and Friday on the first and last week of the month. Also i need to calculate the business hours available in the month (9*No of working days of the month). I am maintaining a SharePoint list of public holiday dates. Can some one please help me with the flow.

     

    Atulvijay_0-1694758014841.png

     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 788 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 452 Moderator

#3
developerAJ Profile Picture

developerAJ 302

Last 30 days Overall leaderboard