D365 Instance Export List

Get list of all D365 | PowerApps | Instances |PowerShell

Many of you have been asking for access to PowerApps and Flow control through PowerShell. This week we have released an extended version of the PowerApps PowerShell script functions (cmdlets) that provide admin access to resources on their instance of PowerApps, Flow, and the Business Application Platform in the PowerShell environment.

If you want to get list of all instance from Power platform Admin Centre you can see the list but you can not Export the list.

PowerApps cmdlets will allow you to interact with your Business Application Platform without having to go through the admin portal in a web browser. You can combine these cmdlets with other PowerShell functions to write complex scripts that can optimize your workflow.

Installation

1. Run PowerShell as an administrator
   
2. Execute the following import commands:Install-Module -Name Microsoft.PowerApps.Administration.PowerShell Install-Module -Name Microsoft.PowerApps.PowerShell -AllowClobber
3. If you are prompted to accept the change to InstallationPolicy value of the repository, accept [A] Yes to all modules by typing in ‘A’ and hitting enter for each module.
   
4. Before accessing any of the commands, you have the option to provide your credentials using the following command. These credentials are refreshed for up to ~8 hours before you’re required to sign in again to continue using the cmdlets.# This call opens prompt to collect credentials (AAD account & password) used by the commands Add-PowerAppsAccount#
   Here is how you can pass in credentials (avoiding opening a prompt) $pass = ConvertTo-SecureString “password” -AsPlainText -Force Add-PowerAppsAccount -Username hatro@cintoso.com -Password $pass
5. To Export the list of all Instance
   Get-AdminPowerAppEnvironment | Export=Csv -path ‘C:\temp\D365instance.csv’
   

After Export environment list to csv you can add/remove column and edit the sheet .

Thank you.