Unanswered

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

(0) Share

Report

Posted on by Community Power Pla...

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

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

efialttes 14,756 on at

Like (0)

Report

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

Was this reply helpful? Yes No
Atulvijay 10 on at

Like (0)

Report

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.

Was this reply helpful? Yes No