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
Solution Sage
Solution Sage

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
October Events

Mark Your Calendars

So many events that are happening this month - don't miss out!

Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Top Solution Authors
Top Kudoed Authors
Users online (2,228)