Business Professionals
Power BI | Power Pivot | Power Query | DAX
Cloud Flows | RPA | AI Builder | Copilot
60+ Formulas | Data Stories | Advanced Reporting & Modeling
VB Programming | Report Automation |
MS-Office Automation
Techno-Business Professionals
Power BI | Power Query | Advanced DAX | SQL - Query &
Programming
Microsoft Fabric | Power BI | Power Query | Advanced DAX |
SQL - Query & Programming
Power BI | Power Apps | Power Automate | Copilot Studio | Power Pages | Dataverse
Microsoft Power Apps | Microsoft Power Automate
Power BI | Adv. DAX | SQL (Query & Programming) |
VBA | Python | Web Scrapping | API Integration
Power BI | Power Apps | Power Automate |
SQL (Query & Programming)
Power BI | Adv. DAX | Power Apps | Power Automate |
SQL (Query & Programming) | VBA | Python | Web Scrapping | API Integration
Power Apps | Power Automate | SQL | VBA | Python |
Web Scraping | RPA | API Integration
Technology Professionals
Power BI | DAX | SQL | ETL with SSIS | SSAS | VBA | Python
Power BI | SQL | Azure Data Lake | Synapse Analytics |
Data Factory | Databricks | Power Apps | Power Automate |
Azure Analysis Services
Microsoft Fabric | Power BI | SQL | Lakehouse |
Data Factory (Pipelines) | Dataflows Gen2 | KQL | Delta Tables | Power Apps | Power Automate
Power BI | Power Apps | Power Automate | SQL | VBA | Python | API Integration
Power BI | Advanced DAX | Databricks | SQL | Lakehouse Architecture
Business Professionals
Power BI | Power Pivot | Power Query | DAX
Cloud Flows | RPA | AI Builder | Copilot
60+ Formulas | Data Stories | Advanced Reporting & Modeling
VB Programming | Report Automation |
MS-Office Automation
Techno-Business Professionals
Power BI | Power Query | Advanced DAX | SQL - Query &
Programming
Microsoft Fabric | Power BI | Power Query | Advanced DAX |
SQL - Query & Programming
Power BI | Power Apps | Power Automate | Copilot Studio | Power Pages | Dataverse
Microsoft Power Apps | Microsoft Power Automate
Power BI | Adv. DAX | SQL (Query & Programming) |
VBA | Web Scrapping | API Integration
Power BI | Power Apps | Power Automate |
SQL (Query & Programming)
Power BI | Adv. DAX | Power Apps | Power Automate |
SQL (Query & Programming) | VBA | Web Scrapping | API Integration
Power Apps | Power Automate | SQL | VBA |
Web Scraping | RPA | API Integration
Technology Professionals
Power BI | DAX | SQL | ETL with SSIS | SSAS | VBA
Power BI | SQL | Azure Data Lake | Synapse Analytics |
Data Factory | Azure Analysis Services
Microsoft Fabric | Power BI | SQL | Lakehouse |
Data Factory (Pipelines) | Dataflows Gen2 | KQL | Delta Tables
Power BI | Power Apps | Power Automate | SQL | VBA | API Integration
Power BI | Advanced DAX | Databricks | SQL | Lakehouse Architecture
LEARN THIS HANDS ON
Power Apps & Power Automate
The email hits on Friday: “I’m leaving in two weeks.” On Monday, a critical Power Automate flow fails because its owner’s account was disabled. Nobody knows who owns which flows, or how to transfer flow ownership cleanly.
This article walks through a realistic scenario and shows how to design, discover, and transfer Power Automate flows so they keep running when people leave the organisation.
You work in a data team supporting sales operations. A cloud flow runs once a month:
It’s been running fine for months. Then it fails with:
The connection 'shared_office365' is not found or is disabled.
You open the flow and see:
You need the flow running again today and you don’t want this problem to repeat for other flows.
We’ll use this scenario to anchor the rest of the article.
Before fixing anything, it helps to be precise about what “ownership” means in Power Automate.
For standard cloud flows (the ones you build at make.powerautomate.com):
Key points:
Typical effects when the owner’s account is disabled or removed:
This distinction matters: a flow breaking because of connections is different from a flow being inaccessible because of ownership.
The cleanest way to handle ownership is to prevent the surprise. You want a repeatable way to:
The most robust way to do this today is via the Power Platform admin tooling.
If you’re an environment admin or Power Platform admin:
This gives you visibility, but it’s still manual.
For a repeatable inventory, use the Power Apps Administration PowerShell module. A common pattern:
Install-Module -Name Microsoft.PowerApps.Administration.PowerShell -Scope CurrentUser
Import-Module Microsoft.PowerApps.Administration.PowerShell
Add-PowerAppsAccount
$environmentName = "Default-<your-tenant-guid>" # or another environment ID
$flows = Get-AdminFlow -EnvironmentName $environmentName
$flows | Select-Object \
DisplayName, \
EnvironmentName, \
@{Name='Owners';Expression={$_.Properties.owners | ForEach-Object { $_.displayName } -join '; ' }} \
| Export-Csv -Path "flows-ownership.csv" -NoTypeInformation
This gives you a CSV with flows and their owners. You can extend it to include creator, last modified date, or other properties.
For our monthly customer export scenario, this is how you’d identify:
When a person leaves and was the only owner, you first need to re-establish ownership.
If you have environment admin rights:
Once you’re an owner, you can open the flow in Power Automate and fix connections.
If you prefer scripting or need to do this at scale, you can use PowerShell. A common pattern:
$environmentName = "Default-<your-tenant-guid>"
$flowName = "<flow-logical-name>" # not the display name; get this via Get-AdminFlow
$newOwnerEmail = "new.owner@contoso.com"
# Get flow
$flow = Get-AdminFlow -EnvironmentName $environmentName | Where-Object { $_.FlowName -eq $flowName }
# Get user principal object
$user = Get-AdminPowerAppUser -EnvironmentName $environmentName -UserPrincipalName $newOwnerEmail
# Add owner
Set-AdminFlowOwnerRole -EnvironmentName $environmentName -FlowName $flowName -PrincipalObjectId $user.ObjectId -RoleName "CanEdit"
Exact parameters and cmdlet names can vary by module version, but the pattern is:
If you’re not fully sure of the cmdlet syntax in your version, do this via the admin portal instead; the portal path is stable and safer.
For our scenario, once you add yourself as owner, you can open the monthly export flow in Power Automate and see all its broken connections.
The next failure mode is using personal connections that die with the person.
In the monthly export flow, you see connectors like:
All using the ex-colleague’s account.
Where your organisation’s policies allow it, the most resilient pattern is:
Examples:
Steps inside the flow designer:
This way, disabling a human owner’s account does not kill the connectors.
Some organisations forbid shared accounts or service principals for certain systems. In that case, you can still reduce risk:
For our monthly export flow, you would:
The best technical fix is often to adjust your design so flows are clearly owned by teams, not individuals.
Instead of relying on a single named person:
While flows still require individual identities for connections, your operational model is now:
Another practical pattern:
This makes it easier for the team to:
In our scenario, the monthly export flow would live in the SalesOps environment, owned by the Sales Ops Automation group, and built with service account connections.
Technical patterns only help if HR and IT processes align. You need a simple checklist that runs whenever someone joins, moves, or leaves.
Have the team lead or environment admin:
Before changing their access:
Before disabling their account:
If you can’t change the account timing, environment admins can still recover ownership later, but connection issues may cause downtime.
In our monthly export scenario, a simple leaver checklist would have:
The flow would never have broken.
Even with good patterns, something will slip. Monitoring helps you react quickly.
For critical flows:
Common symptoms of ownership/connection problems:
When you see these:
Some teams build a meta-flow that:
This isn’t strictly about ownership, but in practice, many ownership issues surface as connection failures, so central error reporting helps you spot them faster.
Pick one environment with business-critical flows and:
Do that once and you’ll prevent most “Who owns this flow?” crises before they ever reach your inbox.
This article reflects the shift from ad hoc, person-owned automation to team-managed Power Automate flows, which matters most in organisations where staff turnover regularly exposes gaps in ownership and connection management.
Professionals who want to apply these patterns to their own data can explore Excelgoodies' Power Automate Course programme - taught live by instructors, with certification awarded once a real project is running at work.
Insights compiled through ongoing industry research and discussions within the Excelgoodies Analytics Community.
Power Automate
New
Next Batches Now Live
Power BI
SQL
Power Apps
Power Automate
Microsoft Fabrics
Azure Data Engineering