Automate Working Day Calculation in Power Automate & Power Apps Excluding Holidays

Calculate working days between any two dates—excluding weekends and public holidays—using Power Automate and Power Apps! This step-by-step tutorial shows you how to automate working day calculations with low-code tools, perfect for HR, project management, or leave request workflows in the Power Platform.

Discover how to build smart, reusable logic that adapts to your business calendar. Whether you’re a Power Apps enthusiast or just starting with workflow automation, you’ll learn practical techniques to streamline manual date calculations and avoid common pitfalls (like counting holidays twice or missing edge cases).

What You’ll Learn:
✔️ Build a Power Automate cloud flow that counts working days, skipping weekends and SharePoint-listed holidays
✔️ Automate leave calculations in Power Apps using Sequence, ForAll, and Filter—great for citizen development and digital transformation
✔️ Leverage SharePoint and Dataverse for dynamic holiday management in your apps and flows
✔️ Apply reusable low-code patterns for BPA, DPA, or HR automation scenarios

Timestamps:
00:00 – Instantly Calculate Working Days (Excluding Holidays) in Power Platform
00:54 – Step-by-Step: Power Automate Working Day Calculation
01:54 – Connect and Use a SharePoint List for Public Holidays
05:39 – Build a Dynamic Array of Dates with Select and Range
10:55 – Advanced Filtering: Exclude Weekends and Holidays
14:39 – Replicate the Logic in Power Apps for App Builders
17:53 – Use ForAll and Sequence to Generate Date Arrays in Power Apps
23:04 – Recap: Automate Accurate Working Day Counts

#PowerAutomate #PowerApps #workflowautomation #LowCode #DigitalTransformation

Ready to make your business processes smarter? Try these automation tips today and let me know in the comments how you’ll use working day calculations in your own Power Platform solutions! For more Power Automate and Power Apps tutorials, don’t forget to subscribe.

SEO Keywords: Power Platform, Power Apps, Power Automate, workflow automation, low-code, digital transformation, citizen development, cloud flows, Dataverse, SharePoint, BPA, DPA

🫠 About me:
👋 Hi, I'm Damien Bird — Power Platform Cloud Solution Architect at Microsoft ☁️
🧠 Former Forum Super User (2021/22) & Business Applications MVP (2022)
🎤 Speaker at conferences across Europe, the US, and local UK user groups
💡 Passionate about sharing knowledge, solving problems, and empowering the community with the Power Platform!

📚 Explore more:
🔗 Blog: https://DamoBird365.com
🎥 Video & Quiz CPD: https://DamoBird365.com/YouTube

💖 Support the Channel: https://youtube.com/@DamoBird365/membership
☕ Buy Me a Coffee: https://BuyMeACoffee.com/DamoBird365
💼 LinkedIn: https://LinkedIn.com/In/DamoBird365
🐦 Twitter: https://x.com/DamoBird365
🌐 Bluesky: https://bsky.app/profile/DamoBird365.bsky.social
📜 Feedback or Request: https://forms.office.com/e/WAV1iF2Wis

Видео Automate Working Day Calculation in Power Automate & Power Apps Excluding Holidays канала DamoBird365