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
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
Proud to be a Flownaut!
User | Count |
---|---|
89 | |
40 | |
22 | |
20 | |
16 |
User | Count |
---|---|
134 | |
54 | |
47 | |
36 | |
25 |