Need to quickly find out who owns every Power App or Power Automate flow in your Microsoft 365 tenant? This script by HarjTech helps you pull ownership data in minutes — perfect for audits, governance, and cleanup.
Whether you're conducting a governance audit, cleaning up unused apps, or preparing to offboard a user — you need a fast way to answer this question:
"Who owns all the Power Apps and Power Automate flows in my tenant?"
Microsoft doesn't give you a clean out-of-the-box report in the admin center. So we’ll use PowerShell, the Power Platform CLI, and PnP PowerShell to generate it.
This solution will:
Perfect for IT admins, consultants, or internal platform owners — especially when you need to fix a problem quickly or prepare for a compliance review.
Run this in an elevated PowerShell window:
Install-Module -Name PnP.PowerShell -Force -AllowClobberDownload and install the Microsoft Power Platform CLI from:
After installation, make sure pac is recognized in your terminal by running:
pac helpIf you see command output, it’s installed.
Before running the script, login using:
pac auth create --kind ADMIN --url https://admin.powerplatform.microsoft.comThis will open a browser and prompt for credentials. Use an account with Power Platform Admin or Global Admin permissions.
# -------------------------------------------------------------
# Script by HarjTech | www.harjtech.com
# Purpose: List all Power Apps and Power Automate Flows in tenant
# Outputs: CSV with App/Flow name, Environment, Creator, Owners
# -------------------------------------------------------------
# Initialize output arrays
$appsReport = @()
$flowsReport = @()
# Get all environments in the tenant
$environments = pac admin list | ConvertFrom-Json
foreach ($env in $environments.environments) {
$envName = $env.name
Write-Host "Processing environment:" $envName -ForegroundColor Cyan
# Get Power Apps
$apps = pac admin powerapps list --environment $envName | ConvertFrom-Json
foreach ($app in $apps) {
$appsReport += [PSCustomObject]@{
Environment = $envName
AppName = $app.displayName
AppId = $app.appId
CreatedBy = $app.createdBy.displayName
Owners = ($app.owners | ForEach-Object { $_.displayName }) -join "; "
}
}
# Get Power Automate Flows
$flows = pac admin flow list --environment $envName | ConvertFrom-Json
foreach ($flow in $flows) {
$flowsReport += [PSCustomObject]@{
Environment = $envName
FlowName = $flow.displayName
FlowId = $flow.name
CreatedBy = $flow.creator.displayName
Owners = ($flow.ownerUsers | ForEach-Object { $_.displayName }) -join "; "
}
}
}
# Export to CSV
$appsReport | Export-Csv -Path "$env:USERPROFILE\Desktop\PowerApps_Owners_Report.csv" -NoTypeInformation -Encoding UTF8
$flowsReport | Export-Csv -Path "$env:USERPROFILE\Desktop\PowerAutomate_Owners_Report.csv" -NoTypeInformation -Encoding UTF8
Write-Host "Reports exported to desktop." -ForegroundColor GreenYou’ll get two CSV files saved to your desktop:
PowerApps_Owners_Report.csvPowerAutomate_Owners_Report.csvEach file includes:
You can filter by environment, sort by owner, or merge with license data for further analysis.
This script is a starting point. HarjTech supports organizations with:
We help you take control of your Power Platform ecosystem — with clear visibility and automation-first strategy.
If you need quick answers about Power App or Flow ownership in your tenant, this solution gives you full visibility in minutes. Whether you're fixing a problem or preparing for governance, this tool puts the data in your hands — fast.
HarjTech builds tools like this — and implements the full governance strategies behind them.
Let us know if you’d like:
Automatically connect HubSpot CRM data with SharePoint to centralize client content, folders, and workflows.
Assess your entire digital footprint—website, CRM, ERP, payroll, accounting and DMS—to plan and automate your business processes.
End-to-end support and consulting to keep your Microsoft environment secure, optimized and aligned with business needs.


Learn how Power Platform helps companies replace outdated systems, build custom apps faster, and automate work — all without heavy development costs. This guide shows how to modernize, test ideas quickly, and scale what works.

Learn how Power Platform helps companies replace outdated systems, build custom apps faster, and automate work — all without heavy development costs. This guide shows how to modernize, test ideas quickly, and scale what works.





Planning a SharePoint Online migration? Learn the essential steps, best practices, permission strategies, and tools like ShareGate and PowerShell to ensure a smooth transition.

Planning a SharePoint Online migration? Learn the essential steps, best practices, permission strategies, and tools like ShareGate and PowerShell to ensure a smooth transition.


Discover how SharePoint helps small businesses organize, secure, and scale their document management workflows. Learn about its features and how HarjTech can help you migrate with confidence.

Discover how SharePoint helps small businesses organize, secure, and scale their document management workflows. Learn about its features and how HarjTech can help you migrate with confidence.


Azure Logic Apps let businesses replace legacy systems with secure, reusable cloud workflows. This blog explains how they cut costs, improve speed, and deliver enterprise-grade results without complex code.

Azure Logic Apps let businesses replace legacy systems with secure, reusable cloud workflows. This blog explains how they cut costs, improve speed, and deliver enterprise-grade results without complex code.


Azure DevOps offers powerful project management, agile boards, reporting, and scalable collaboration. Learn how it works, how to structure projects properly, licensing costs, and why it's ideal for Microsoft 365 users.

Azure DevOps offers powerful project management, agile boards, reporting, and scalable collaboration. Learn how it works, how to structure projects properly, licensing costs, and why it's ideal for Microsoft 365 users.
Let's discuss how our productized solutions can drive your success
Productized IT Consulting & Digital Solutions. Serving clients across Canada with outcome-driven Microsoft solutions that deliver guaranteed results.
© 2024 HarjTech. All rights reserved.