Automation

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 Write to Dataverse Notes Table using Web API
Automation / Dataverse / PowerApps Model Driven

Write to Dataverse Notes Table using Web API

I had a challenge recently where I needed to migrate hundreds of notes from an old database to the Dataverse. Dataverse has an Out of the Box Notes table (logical name “annotations”) that allows for recording notes and attachments against a related table. This post will showcase the preparation steps and PowerShell script used to do just that. Preparation Steps Enable Notes and Attachments For this example, let’s assume we are trying to write rows from a csv into the notes table regarding Purchase Orders. First, ensure the table has the option “Enable Attachments (including notes and files)”…

Comments Off on Write to Dataverse Notes Table using Web API
July 9, 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 PowerApps Essential PnP PowerShell for SharePoint Provisioning
Automation / PowerShell

PowerApps Essential PnP PowerShell for SharePoint Provisioning

When importing PowerApps SharePoint-based solutions into upper level environments (such as from development to test environment), it’s typically necessary to provision a dedicated site and the lists that each environment will use. Unlike Dataverse solutions where importing a solution automatically creates the tables in the target environment, SharePoint sites and list resources are not. This gap led me to ask: what's the most efficient, programmatic way to create these SharePoint resources? Well, since you’ve read the title, you probably know where this is going: PowerShell PnP to the rescue! I'm going to assume you already have the SharePoint…

Comments Off on PowerApps Essential PnP PowerShell for SharePoint Provisioning
May 30, 2025