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?
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.