cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
SFrances
New Member

Dynamic Schedule in Sharepoint

Hello,

 

I have a bit of a complicated ask. I have a giant list with columns of specific tasks (framing, capping, etc.) where I need to generate a schedule based off a singular date column in another list. Essentially, when that date column is filled out, I would like Power Automate to take the date and add to it based on the task itself. So if I enter February 2nd, 2022 in my date column, I would like Power Automate to go through all my task columns and increment the date based on the task. Framing would be date +2 days (so February 4), Capping would be date +4 days (February 6), etc. What would be the easiest way of doing this? I know I can create a variable for each task but I've got over 100 columns/tasks that I'd need to do this for, so it would be incredibly inefficient. I also need to ignore weekdays, so Saturdays and Sundays need to be skipped in the incrementing.

 

I've got another reference list with each task column name as well as the number of days to increment for each task but I haven't been able figure out a way to loop through this. Also considering maybe using a calculated column in Sharepoint if that would be the easiest way, but that requires me to hardcode in the calculations. Ideally I'd like to pull from the reference list to allow me to be able to adjust the increments on the fly for each task.

 

Thanks in advance.

0 REPLIES 0

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,919)