Export a List of All Power Platform Environments to CSV Using PowerShell

In this blog post, we’ll walk you through the process of exporting a list of all Power Platform environments using PowerShell.

Managing Power Platform environments can be challenging, especially when dealing with a large number of environments. Exporting a list of all environments to a CSV file can make it easier to review and analyze your organization’s environments.

Install-Module and Login

Before starting, ensure that you have the following:

PowerShell 5.1 or later installed on your computer.

The Power Platform PowerShell modules are installed. You can install them by running the following commands in PowerShell:

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

Authenticate to your Power Platform environment by running the following command:

Add-PowerAppsAccount

Export

Run the following script to get a list of all environments and export them to a CSV file:

$environments = Get-AdminPowerAppEnvironment
$environments | Select-Object EnvironmentName, DisplayName, CreatedBy, CreatedTime, LastModifiedBy, LastModifiedTime | Export-Csv -Path "Environments.csv" -NoTypeInformation

This script retrieves a list of environments using the Get-AdminPowerAppEnvironment cmdlet and selects specific properties, such as the environment name, display name, creator, and modification details. The Export-Csv cmdlet exports the selected data to a CSV file named “Environments.csv” in the current working directory.