How to get Next Working Weekday using Power Automate

Power Automate offer extensive automation capabilities, but working with DateTime functionalities can be challenging. In this blog, we’ll explore on how to get the next working weekday.

First, let’s create a new Instance Cloud Flow. Next, add a Date input within the trigger, allowing the user to select a data whenever the workflow is triggered. Name this input variable as ‘date‘. For example, the selected Date is 2024-05-25

Assuming Monday to Friday are weekdays and try to return the next date is in between these days.

Next, add a Compose action to the workflow and add the below expression,

if(
equals(dayOfWeek(addDays(triggerBody()?['date'],1)),6),
addDays(triggerBody()?['date'],3),
if(equals(dayOfWeek(addDays(triggerBody()?['date'],1)),0),
addDays(triggerBody()?['date'],2),
addDays(triggerBody()?['date'],1))
)