Power Automate

Read more about the article Import Data into a Many-to-Many Relationship Table in Dataverse
Automation / Dataverse / Power Automate / PowerShell

Import Data into a Many-to-Many Relationship Table in Dataverse

Importing data into a table in Dataverse auto-created by a many-to-many relationship proves to be much less straight-forward than it ought to be. For example, PowerApps Dataflows don't support importing to them. In this post, I’ll showcase two methods to import data using both Power Automate and the Dataverse Web API. Scenario: The Auto Inventory Manager I have this Dataverse data model for my Auto Inventory Management solution: Many Models can belong to a single make. That's a classic Many-To-One relationship. However, many models come in many different body styles. (Ex: a Honda Civic comes in a hatchback…

Comments Off on Import Data into a Many-to-Many Relationship Table in Dataverse
October 18, 2025
Read more about the article Intro to Deep Linking in PowerApps
Dataverse / Power Automate / PowerApps Canvas / PowerApps Model Driven

Intro to Deep Linking in PowerApps

Instead of opening an app's main screen, there are scenarios where you'd want to directly take a user to a specific screen. This post will explore how to deep link to a specific record in both Canvas and Model Driven Apps. Example Use Case Consider an example where app contains Purchase Orders. When someone creates a new purchase order (PO), Power Automate sends an email to the manager with a deep link to the corresponding PO. The deep link directly to the main form for that PO. A Deep link in an email navigating to the Main Form…

Comments Off on Intro to Deep Linking in PowerApps
July 6, 2025
Read more about the article Fetch a List of PowerApps across Environments
Automation / Power Automate

Fetch a List of PowerApps across Environments

One of the challenges I’ve faced when using the Power Apps Admin Center is getting a quick view of all the apps within all environments for documentation purposes. Sure, you can go into each environment's Admin Center and view the apps, but this is not efficient. Even worse, from there, there's no way export the a list of the apps! To solve this, I explored several options before landing on the approach I describe below. First, I tried PowerShell with the Get-AdminPowerApp cmdlet—but that only returns Canvas App data. No Model-Driven Apps in sight. Then I turned to…

Comments Off on Fetch a List of PowerApps across Environments
July 1, 2025
Read more about the article Automated Azure AD Credential Expiration Alerts
Automation / Power Automate

Automated Azure AD Credential Expiration Alerts

All secrets and certificates created within Azure App Registrations have expiration dates, making it crucial for administrators to stay informed to take timely action. Microsoft does not provide an automated notification for this. However, by leveraging Microsoft Graph API and Power Automate, you can set up automated alerts to notify when secrets and certificates are nearing expiration—or have already expired. Below is an example e-mail of expiring and expired secrets and certificates generated by Power Automate: The end-result in e-mail showing expiring secrets, expired secrets, as well as an a csv export of all secrets. Requirements You'll need…

Comments Off on Automated Azure AD Credential Expiration Alerts
June 26, 2025
Read more about the article Cancel an Approval of Behalf of Another User in Power Automate
Dataverse / Power Automate

Cancel an Approval of Behalf of Another User in Power Automate

Using the Approvals Connector within Power Automate is a great way to streamline approvals, as it provides a lot of functionality out of the box. One limitation it has however is the ability to cancel an approval on behalf of another user. For that, we need to use Power Automate and make an update directly in the Approvers table record. Example - Purchase Order Approval Request Using a Model Driven App, I have an IT Inventory tracking system where I need to submit Purchase Orders for manager approval. When the flow button is pressed in the app, the…

Comments Off on Cancel an Approval of Behalf of Another User in Power Automate
June 20, 2025
Read more about the article Fast and Efficient Pagination in Power Automate
Power Automate

Fast and Efficient Pagination in Power Automate

Pagination is frequently used by APIs to divide large sets of data into manageable "pages." In this post, I’ll show you how to efficiently paginate and collect all the results into an array in Power Automate—without using Apply to Each. I’ll also include a quick performance comparison so you can see the impact for yourself. The difference in speed will surprise you! Use Case: The Office 365 Users Connector I want to use an example where you can try this against your own tenant: the Office 365 Users connector. One of it's actions is the Send an HTTP…

Comments Off on Fast and Efficient Pagination in Power Automate
April 12, 2025