cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
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

1 REPLY 1
efialttes
Super User
Super User

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



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

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


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (1,625)