When building flows in Dataverse, simply adding days to a date won’t cut it—you have to account for weekends and holidays. In this post, we walk through a step-by-step method to accurately calculate a new date X business days after a starting point using a Do Until loop, date functions, and a custom Holidays table. Whether you're setting due dates or automating time-sensitive tasks, this guide will help you build logic that respects your business calendar.

Need to filter dropdowns in your Canvas App based on a prior selection? In this post, we walk through creating cascading dropdowns using SharePoint data, with a real-world example of a travel request form. Learn how to filter cities by state, configure lookup fields correctly, and ensure your form saves and displays the right data — all with easy-to-follow Power Fx formulas and practical tips.

Learn how to dynamically retrieve email addresses from Dataverse record owners in Power Automate—even when the owner is a team instead of an individual user. This step-by-step guide covers how to identify the owner type, get user emails, expand team membership, and build a flexible notification system that works for any ownership scenario. Perfect for improving your Power Automate flows and ensuring no critical emails are missed!

Learn how to handle reassigned approval requests in Power Automate using Adaptive Cards. Part 3 of our series walks through detecting reassigned approvals, linking to SharePoint data, and sending a new card to the updated approver.

This blog post explores how to integrate Adaptive Cards with Microsoft's built-in Approval Process using Power Automate, enabling users to respond to approval requests directly from their inbox. Learn how to streamline the approval workflow with actionable cards and automated responses.

Adaptive Cards are transforming how we create interactive, actionable messages in Outlook, and I’m kicking off a multi-part series exploring how they can integrate with the Power Automate approvals process.

Automatically Calculate the First and Last Day of a Week in Power Automate.