Answered

Date Difference (business days) in Power Automate

(0) Share

Report

Posted on by PALQD

my source is excel list, im trying to create a flow where an email will automatically sent when the due date is in 30 days. However, i only want to count the business days. How will I do this in power automate

Categories:

Building Power Apps

All responses (12)

Answers (1)

Sort by

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @PALQD

If you want to calculate the working days in flow , you can refer to this video:
Calculating Working Days in Power Automate & Power Apps | #PowerAutomate #PowerApps #Tutorial - YouTube

Best Regards,

Yueyun Zhang
UshaJyothiKasibhotla 229 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @PALQD

Please refer this thread

https://powerusers.microsoft.com/t5/Power-Automate-Cookbook/Get-Next-Date-s/td-p/2581331

Hope this helps

Usha
PALQD 56 on at

Like
a
(0)

Report
Copy link

Link copied!

i only need the formula. i already have a flow of getting the date difference, but i can't figure out how to only compute for the weekdays.
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @PALQD

Do you get the start date and end date in your flow side?

Best Regards,

Yueyun Zhang
PALQD 56 on at

Like
a
(0)

Report
Copy link

Link copied!

yes,
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @PALQD

I create a test flow and the result is as follows:

I use the start date and the end Date in my trigger:

The Select action:

range(0, add(int(split( dateDifference(triggerBody()['date'],triggerBody()['date_1']) ,'.')?[0]),1) )

addDays(triggerBody()['date'],item())

addDays(triggerBody()['date'],item(),'dddd')

【Note】: The "triggerBody()['date']" is the Start Date and the "triggerBody()['date_1']" is the End Date , you need to replace this expression in your side.

The Filter and Compose action:

@and(not(equals(item()?['Day'], 'Saturday')) ,not(equals(item()?['Day'], 'Sunday')) )

length(body('Filter_array'))

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang
PALQD 56 on at

Like
a
(0)

Report
Copy link

Link copied!

im confused but here is my flow. What should I do
Verified answer

v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @PALQD

According to your screenshot, this is my understanding:

So you need to add a condition and Select action after your Compose 4 action:

range(0, add(outputs('Compose_4'),1) )
addDays(outputs('Compose_3'),item())
addDays(outputs('Compose_3'),item(),'dddd')

Then after the Select 2 action you need to add a filter and Compose action in my above reply:

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang
PALQD 56 on at

Like
a
(0)

Report
Copy link

Link copied!

After the compose step, Can u teach me what to do next. I want to send email when the counted date difference (business days) reaches 30.
v-yueyun-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi , @PALQD

The final Compose is to calculate the number of workdays to be included, so you can add a condition directly below. If it is greater than or equal to 30, the email will be sent.

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang