blog.atwork.at

news and know-how about microsoft, technology, cloud and more.

Use the PowerApps PowerShell modules to automate tasks with the Microsoft Power Platform

PowerShell helps automate processes, especially in the Microsoft 365 world. That´s true for the Microsoft Power Platform as well. See how to access PowerApps and Flow with PowerShell here.

image

So, here´s a very quick introduction for using PowerShell with PowerApps and Flow. Find the full documentation at PowerApps cmdlets for administrators.

Install the PowerShell modules

Install the PowerApps (preview) module from the PowerShell Gallery once with the following PowerShell statements as Administrator on your machine:

Install-Module -Name Microsoft.PowerApps.Administration.PowerShell
Install-Module -Name Microsoft.PowerApps.PowerShell -AllowClobber

Get the latest version from Microsoft.PowerApps.PowerShell and from Microsoft.PowerApps.Administration.PowerShell and see here. Just to mention, Office 365 Global admins or Azure Active Directory Global admins no longer require a P2 license for administrative access to the PowerApps admin PowerShell cmdlets.

Login

Sign-in with your Azure Active Directory account and password:

Add-PowerAppsAccount

Environments

To get the existing environments of an Office 365 tenant, use Get-AdminPowerAppEnvironment

and Get-AdminPowerAppEnvironment -Default to see the default environment for PowerApps as here.

image

Connections

PowerApps require data connections for working with data. You get them with:

Get-AdminPowerAppConnection

You can filter for specific connectors as our colleague Adis Jugo mentioned at Managing Microsoft PowerApps and Flow Like a Pro (see also the links below).

Use ready-to-go scripts

To get an overview of PowerApps and Flows, I also recommend to check out the scripts at PowerShell scripts to discover and manage specific features in the Power Platform.

For example, the script PowerApps with Custom Connectors generates a CSV file including custom connectors, similar to this demo.

image

There are ready-to-use scripts for PowerApps to get Custom Connectors, PowerApps with Premium Connectors, PowerApps with on Prem Connectors using Data Gateway, PowerApps used as SharePoint custom forms, Flows with HTTP Actions, Flows with Custom Connectors...

image

Check them out!

Customize your scripts and learn more

So, some scripts can deliver a good foundation for own scripts and workflows. Find out more about using PowerShell at Automation of tasks with PowerShell. Also, check out the following resources:

Happy scripting!

Loading