Requirement: how to add days to exclude weekends in power Automate.
In Power Automate, select manually triggered Flow, then click on the next step.
power automate add days exclude weekends
Next select initialize variable action, then provide the variable name, and type as a string.
How power automate add days exclude weekends
Add another initialize variable action, then provide the variable name, type as a string, and in value assign a date.
Microsoft Flow add days excluding weekends
Now check the day is weekend or not by using the days of week function, it returns 0 if the date is Sunday, add 1 day to the date and returns 1 if the day is Monday, add 2 days to the date. So, click on the Next step and select Switch action then provide the below expression:
dayOfWeek(variables('StartDate'))Next, when the case equals 0, click on add an action and select Set variable action. Then select variable and provide the below expression:
addDays(variables('StartDate'),1)When the case equals 1, click on Add an action and select Set variable action. Then select variable and provide the below expression:
addDays(variables('StartDate'),2)In the default case, click on add an action, select Set variable action. Then select the variable name, add the start date.
MS Flow add days exclude weekends
Now click on Save and run the flow manually. As 2023-04-17 is Monday so case 2 will run and will add 2 days to the date.
How does MS Flow to add days excluding weekends