
Announcements
Hi @Philllippp
Let's address your queries step-by-step:
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.
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.
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:
Install PowerShell Modules: Ensure you have the necessary PowerShell modules installed, such as Microsoft.PowerApps.Administration.PowerShell and Microsoft.PowerApps.PowerShell.
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).
Script for Compliance: Another script can be used to list non-compliant apps and flows based on your licensing criteria.
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!