cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
NeohLooi
Helper II
Helper II

Calculate days exclude holiday and weekends

Is that possible I want to calculate the working days exclude holiday and weekend with the connection with calendar in outlook?
I know there is a way that using a list store the holiday and use power automate to achieve that, but I wonder is that any way can do this with outlook calendar?

1 REPLY 1
mahoneypat
Super User
Super User

I looked through the available web calls in the Outlook API and don't see a straight forward way to do it.  I was hoping to see one that let you get a list of days with properties (day of week, holiday, etc.) but it doesn't appear to be an option.  You may be able to trick it by looking for available times on every day, but it would be clunky and probably not foolproof.

 

Using the list approach is probably best. Here is an example.

How to calculate workdays with PowerApps | Papa Riedels Blog (wordpress.com)

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,960)