Learn how to automatically export data from an existing Power BI dataset to Excel using Power Automate. This step-by-step walkthrough shows how to reuse Power BI queries, create Excel files in SharePoint, and build a reliable daily export without duplicating business logic.

Power Automate flows don’t always need to rely on a user’s SharePoint connection. In this post, I walk through how to register an Azure Entra app, securely manage a client secret, and retrieve an access token in Power Automate to enable app-based SharePoint authentication — with practical tips to avoid common permission pitfalls along the way.

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.

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.