15. The Do Until loop will complete until the variable counter matches the variable workdays.
16. In the final step we update the DueDate in the Work Progress Tracker list for the current item using the SharePoint – update item action.
Expressions:
a. ID
i. Value: @{triggerOutputs()?['body/ID']}
b. Title
i. Value: @{triggerOutputs()?['body/Title']}
c. Start date
i. Value: @{triggerOutputs()?['body/StartDate']}
d. Task Completion WorkDays
i. Value: @{triggerOutputs()?['body/TaskDays']}
e. Due date
i. Value: @{variables('DueDate')}
Hi, can this workflow be used "When an item is created or modified"? I want to calculate the due date once the status is updated to "Submitted" not when the item is created. On step 6, what is "TaskDays" referring to as I don't see that column on any of the sharepoint lists? I'm also getting an error message in the Flow checker for the variable DueDate: "Actions in this flow may result in an infinite trigger loop. Please ensure you add appropriate conditional checks to prevent this flow from triggering itself."
You are most likely missing step 6(d) where we initiate DueDate variable.
And yes, you can use this flow for "When an item is created or modified".
Hope this helps!