Skip Ribbon Commands
Skip to main content

Quick Launch

Todd Klindt's home page > Todd Klindt's Office 365 Admin Blog > Posts > Using PowerShell to Find Power Apps that use the SharePoint Connector
May 21
Using PowerShell to Find Power Apps that use the SharePoint Connector

I recently had a fun task come across my desk. A customer of mine has a large tenant, with a lot of Power Apps and a lot of Power App makers. They’re doing a tenant migration, and the Power Apps themselves will likely move over pretty easily. A lot of them are connecting to the tenant’s SharePoint site, and after the tenant move those SharePoint URLs are going kaput. The customer wanted to be able to find out which Power Apps were going to be broken so they could reach out to the owners to get them fixed. That’s where I, and my PowerShell prowess came in.

I had whipped up some quick and dirty PowerShell for this customer before so they asked if I could work my magic with this. I have dabbled a bit with the Power Apps and Flow Power Automate PowerShell in the past, and while I found it… lacking, I figured this was something it could handle. Here is the PowerShell I eventually went with:

Get-AdminPowerApp | ForEach-Object { if (Get-AdminPowerAppConnectionReferences -EnvironmentName $(Get-PowerAppEnvironment).EnvironmentName -AppName $_.AppName | Where-Object -Property ConnectorName -EQ -Value "shared_sharepointonline") {$_ | Select-Object DisplayName, @{Label="Owner";e={$_.Owner.displayName}},@{Label="Email";e={$_.Owner.userPrincipalName}}, AppName }}

Here’s what it looks like when it runs:


I have the following two Power Apps modules installed with these versions:

2.0.61 Microsoft.PowerApps.Administration.PowerShell

(Full list of Office 365 PowerShell modules)

You’ll get prompted to log in. The account will have to have the necessary permissions to enumerate all of the Power Apps in the tenant.

I know what you’re thinking, “Todd, that’s amazing! Solid work! I hate to seem greedy, but, um, where is the URL of the SharePoint site the Power App is connecting to?” That’s a funny story, but the punchline is, there isn’t a way. At least not from the PowerShell modules we have today. Apparently the Center of Excellence Starter Kit has a way to get that information, but it’s a really big hammer for a nail this small.

This will work for any of the Connectors. You can use the following PowerShell to see all Connectors that are in use:

Get-AdminPowerAppConnection | Select-Object ConnectorName

That will give you the value you need to search for with the Where-Object. If you’re looking for more ways to abuse Power Apps and Power Automate with PowerShell (so many Powers there) you can watch Shane’s so-so PowerShell for PowerApps and Flow video. It’s okay. I guess. In a pinch.






Seriously sturdy, magnificent, fact-filled information and facts listed here. A person's discussions Never need disappoint, and the unquestionably is valid listed here in addition. You actually continually make a fun learn. Do you convey to I'm just happy?: )#) Keep up to date the nice reports.
 on 10/26/2023 8:17 AM


It a fabulous blog post As i looked at caused by have the application. Advise everything that Need be to find expectation on potential future you certainly will persist designed for writing a great wonderful blog post. private gym winter park fl
 on 10/29/2023 7:29 AM


Really! Everything that a opener it blog post was for my situation. A great deal enjoyed, bookmarked, As i can’t look ahead to alot more! 911 proxy
 on 10/31/2023 6:24 AM


Used to do delight in examining articles or blog posts placed here. There're outstanding possesses many practical facts. Seminyak Restaurant Place
 on 11/1/2023 7:02 AM


Typical trips listed below are the ultimate way to many thanks to your energy, which usually is why Now i'm browsing your website each day, trying to find fresh, intriguing details. Several, thanks! Shopify fulfilment service
 on 11/9/2023 8:06 AM


the actually great website. the realy informative plus a this kind of excellent career. i enjoy this kind of.
 on 11/20/2023 7:36 AM

Re: Using PowerShell to Find Power Apps that use the SharePoint Connector

Terrific put up, attended on top not to mention saved your web sites. I just can’t hang around to study further because of most people.gledek88
 on 11/27/2023 6:45 AM

Add Comment

Items on this list require content approval. Your submission will not appear in public views until approved by someone with proper rights. More information on content approval.


Body *

Today's date *

Select a date from the calendar.
Please enter today's date so I know you are a real person


Want a message when I reply to your comment? Put your Twitter handle here.