web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / List all premium conne...
Power Apps
Suggested Answer

List all premium connectors in use to discover non compliant licensed users, apps and flows

(1) ShareShare
ReportReport
Posted on by 2
Hi,
 
I would like to 
 
1) List all premium connectors in use, and see where they are used (apps and flows). My understanding is that this can be achieved through a Powershell script and CoE-kit, but is there an easier way to do it? To install and set up the CoE-kit would be to aim way above the target here since no one will take care of it.
 
2) List all non compliant apps and flows to ensure Microsoft licensing compliance.
 
Can I see this in the Power Platform admin center?
Do I need to run a Powershell script?
Is there a way to not install the CoE-kit to see this?
 
Best Regards
I have the same question (0)
  • Suggested answer
    Jon Unzueta Profile Picture
    1,827 Super User 2025 Season 2 on at

    Hi @Philllippp

    Let's address your queries step-by-step:

    1. Listing Premium Connectors in Use

    Power Platform Admin Center: The Power Platform Admin Center provides insights into environments, apps, and flows, but it doesn't directly list premium connectors in use across all apps and flows.

    PowerShell Script: Using PowerShell scripts can help you extract detailed information about connectors in use. This approach requires some scripting knowledge but can be more targeted than setting up the CoE-kit.

    CoE-kit: The Center of Excellence (CoE) Starter Kit is a comprehensive solution for managing and monitoring Power Platform environments. However, as you mentioned, it might be overkill for your needs if no one will maintain it.

    2. Listing Non-Compliant Apps and Flows

    Power Platform Admin Center: The admin center provides compliance and governance tools, but it may not directly list non-compliant apps and flows without additional setup or customization.

    PowerShell Script: Running a PowerShell script can help you identify non-compliant apps and flows based on specific criteria you define.

    Recommendations

    Given your requirements to avoid installing the CoE-kit, using PowerShell scripts seems to be the most efficient way to achieve both tasks. Here are some steps you can follow:

    Using PowerShell Scripts

    1. Install PowerShell Modules: Ensure you have the necessary PowerShell modules installed, such as Microsoft.PowerApps.Administration.PowerShell and Microsoft.PowerApps.PowerShell.

    2. Script for Premium Connectors: You can write a script to list all premium connectors in use and identify where they are used (apps and flows).

    3. Script for Compliance: Another script can be used to list non-compliant apps and flows based on your licensing criteria.

    Example PowerShell Script

    Here is a simplified example of how you might approach this:
     

    # Connect to Power Platform

    Add-PowerAppsAccount

    # List all environments

    $environments = Get-AdminPowerAppEnvironment

    # Iterate through environments to list apps and flows

    foreach ($env in $environments) {

        $apps = Get-AdminPowerApp -EnvironmentName $env.EnvironmentName

        $flows = Get-AdminFlow -EnvironmentName $env.EnvironmentName

        foreach ($app in $apps) {

            # Check for premium connectors in apps

            $connectors = Get-AdminPowerAppConnector -AppName $app.Name -EnvironmentName $env.EnvironmentName

            foreach ($connector in $connectors) {

                if ($connector.ConnectorType -eq "Premium") {

                    Write-Output "Premium Connector: $connector.Name used in App: $app.Name"

                }

            }

        }

        foreach ($flow in $flows) {

            # Check for premium connectors in flows

            $connectors = Get-AdminFlowConnector -FlowName $flow.Name -EnvironmentName $env.EnvironmentName

            foreach ($connector in $connectors) {

                if ($connector.ConnectorType -eq "Premium") {

                    Write-Output "Premium Connector: $connector.Name used in Flow: $flow.Name"

                }

           }

        }

    }

    # Check for non-compliant apps and flows

    foreach ($env in $environments) {

        $apps = Get-AdminPowerApp -EnvironmentName $env.EnvironmentName

        $flows = Get-AdminFlow -EnvironmentName $env.EnvironmentName

        foreach ($app in $apps) {

            if ($app.ComplianceStatus -ne "Compliant") {

                Write-Output "Non-compliant App: $app.Name"

            }

        }

        foreach ($flow in $flows) {

            if ($flow.ComplianceStatus -ne "Compliant") {

                Write-Output "Non-compliant Flow: $flow.Name"

            }

        }

    }

    If the response is helpful to you, a like or mark as the correct solution. thank you so much!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard