Calculating Working Days in Power Automate & Power Apps |

In this tutorial, I'll show you how to calculate the number of working days between two dates, while excluding weekends and public holidays.

In Power Automate, I'll walk you through the process step-by-step, utilizing the Select action, range expression, and Filter Array action. This powerful combination will simplify your workflow and save you time.

For the Power Apps enthusiasts, we've got you covered too! I'll demonstrate how to achieve the same result using the Sequence, ForAll, and Filter expressions. My solution is easy to adapt and will make your app development process a breeze.

Whether you're a beginner or an experienced user, this tutorial is designed to help you enhance your skills and streamline your projects. Join me as we explore the ins and outs of calculating working days in Power Automate and Power Apps.

Don't forget to subscribe to DamoBird365 for more insightful tutorials, tips, and tricks on Power Automate and Power Apps. Leave your questions and comments below, and we'll be happy to assist you.

0:00 - Introduction
0:54 - Calculating working days in Power Automate
01:54 SharePoint List of Public Holidays
05:39 Using select to build an array of dates
10:55 Advanced filter array expression
14:39 Calculating working days in Power Apps
17:53 Using forall to build an array of dates
23:04 Conclusion and outro

Connect with me:
Website: www.DamoBird365.com
Twitter: www.twitter.com/DamoBird365
LinkedIn: www.linkedin.com/in/DamoBird365

#PowerAutomate #PowerApps #Tutorial

Please buy me a coffee https://www.buymeacoffee.com/DamoBird365 ☕