Pulling Sharepoint site URL and List names for all PowerApps uising them as resources

(2) Share

Report

Posted on by HV-10091544-0

I'm trying to build a list of all Flows and Apps that connect to Sharepoint Sites. (i'm looking for the site url and name of lists that apps and flows are connecting to)

I'm successfully pulling this information for flows using the "List Flows as Admin" and "Get Flow as Admin" connectors, but the equivalent data is not available for PowerApps. I can pull information on apps using the SharepointOnline connections, but it doesnt provide the actual site URLs or Sharepoint List names.

Have also tried the Powershell CMDLets

According to Co-Pilot, Claude, ChatGPT and online research this seems to be a gap in Microsoft's tooling... Can this be true? Surely there must be a way rather than having to go through PPAC one environment at a time, one app at a time etc?

Has anyone out there been able to achieve this?

Thanks!

Henk

Categories:

Using connectors

General topics

Using flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Sunil Kumar Pashikanti 2,318 Moderator on at

Like
a
(2)

Report
Copy link

Link copied!

I’ve as a Power Apps Idea focused on admin/governance scenarios.

Today, Power Apps does not expose SharePoint site or list dependencies via Admin APIs due to dynamic data source binding, which makes environment‑wide impact analysis very difficult compared to Power Automate.

The Idea asks for a best‑effort, clearly labeled dependency discovery capability so admins don’t have to rely on unsupported inference tooling.

If others are impacted by this, voting or commenting may help give it visibility.

Expose SharePoint Site and List Dependencies for Power Apps via Admin APIs

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

Yes, this is a real limitation in Microsoft’s current tooling. While Power Automate flows expose detailed connector and SharePoint information via admin APIs, Power Apps canvas apps do not expose SharePoint site URLs or list names through any official API or admin connector.

The only reliable approach today is to export the app (.msapp), unpack it, and parse the internal JSON files (such as DataSources.json) to extract SharePoint site and list details. For enterprise scenarios, this is typically automated using Power Platform CLI and custom scripts.

Was this reply helpful? Yes No
HV-10091544-0 23 on at

Like
a
(1)

Report
Copy link

Link copied!

Thanks for the responses! I've upvoted the article. @11manish, yeah i came to that conclusion, but not the most efficient use of time if you have ~80 environmnts and ~3,000 apps.

Lets see if MS can come up with a solution.

THanks

Was this reply helpful? Yes No