Rotating Weekly Schedule using SharePoint

(0) Share

Report

Posted on by Thor_PPC

365

Hello,

I am trying to build a rotating weekly schedule that utilizes Flow to either post the current week schedule or maybe show a list view of the current week schedule. I'm not really sure how to set this up though after setting up the timed recurrence part of the Flow, and the list setup is a bit of an issue. I have Week 1A, Week 1B, Week 2, Week 3, and Week 4. So the rotation would look like this:

1. Week 1A

2. Week 2

3. Week 3

4. Week 4

5. Week 1B

6. Week 2

7. Week 3

8. Week 4

Repeats from the top.

Currently, I have a list that displays the names in rows for each column week.

Does anyone know how I could accomplish this, either by posting the current week as an update to a different list or by changing the view on the current list?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

alrezac on at

Like (0)

Report

Hi,

Looking through this issue, this will be a difficult task to implement. The hardest thing will be the fact that each flow run will need to be independent from each other which means there will need to be some kind of proof or algorithm in order to correctly select the week. My suggestion would be to reach out to a partner who can help you design this and help with building this flow.

Regards,

Alex

-------

Community Support Team _ Alex Rezac
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
zaphod88 502 on at

Like (0)

Report

What is it behind the "black boxes" in the screenshot? Are those people picker fields?
I'd propose to reorganize the list: Take the item titles as columns, the weeks as items. Create a week start and week end date column. In Flow, you could create the schedule and rotation and you could easily determine the current week in a condition. But it maybe depends on changes on the schedule and who (else) has to maintain them. If there are many changes, you could create a "master list" which contains the 5 different week types as items and copy them to a secondary list (the schedule containing week start and end) via Flow weekly so that changes can be made in master list and are adopted to the schedule for future weeks.

What do you do with the schedule in the end? Is it looked up just in Sharepoint by employees, sent by mail...?

Was this reply helpful? Yes No
Thor_PPC 365 on at

Like (0)

Report

Black boxes just cover the names of the people who work the service that week. The scheduled just needs to be viewed in sharepoint

Was this reply helpful? Yes No