web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Calculate weekdays in ...

Power Automate

Unanswered

Calculate weekdays in approval process

(0) Share

Report

Report

Posted on by Yesha

Hi,

I have an approval workflow where by i am using ticks to calculate days between request and completion date. Can you please help in how to only calculate weekdays?

thank you in advance!

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Chriddle 8,638 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!
There certainly is a propper algo for this, but you can also let PA do the work 🙂
Here is my brute force solution:
Select
From (This is a range from 0 to number of days, including end date):
range( 0, int( split( dateDifference( outputs('Dates')['start'], addDays( outputs('Dates')['end'], 1 ) ), '.' )[0] ) )
Map (Check if weekday is 0 or 6. If so return , else 1):
if( contains( createArray(0,6), dayOfWeek( addDays( outputs('Dates')['start'], item() ) ) ), 0, 1 )

Compose
Input (Add all the numbers in the array created with the Select):
xpath( xml( json( concat( '{"root":{"Number":', body('Select'), '}}' ) ) ), 'sum(/root/Number)' )

Output: 5

Was this reply helpful? Yes No

Join the conversation