Vibe coding Power Apps

(1) Share

Report

Posted on by CU06051400-0

Hi ,Good Time,

I am working on vibe coding.

I have a query related to bringing all the SharePoint sites in the App.

I am trying to create the app which shows all the SharePoint sites in the tenant.

It uses MCP server ,sometimes it uses SharePoint connector, sometimes uses MCP copilot action .

But it is not fetching the sites and shows time out.

Can you please help me in what prerequisites we need to use and also please help me in let me know the proper prompt for the Application which needs to be created..

Thank you very much!

IMG_20260506_1934...

Your file is currently under scan for potential threats. Please wait while we review it for any viruses or malicious content.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Vish WR 2,548 on at

Like (1)

Report
Copy link

Link copied!

@CU06051400-0

What you facing is is mainly a limitation of how SharePoint and Graph handle large tenant data, not your prompt.

There’s no reliable way to fetch all SharePoint sites live in an app using MCP or SharePoint connector — it usually times out because the tenant data is too large and the calls are paginated and throttled.

What you can do instead

Use Microsoft Graph (GET /sites?search=* or getAllSites) with proper permissions like Sites.Read.All, but don’t call it directly from the app.

Best practice is to run a scheduled flow or job that pulls all sites and stores them in a list or Dataverse. Then your app simply reads from that stored data, which avoids timeouts completely.

In short

Don’t fetch sites live. Sync them in the background and show the cached data in your app — that’s the only stable way at tenant scale.

Vishnu WR

LinkedIn - My Tech Space

Please ✅ Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider answering Yes to Was this reply helpful? or give it a Like ♥

Was this reply helpful? Yes No
Suggested answer

11manish 2,252 on at

Like (0)

Report
Copy link

Link copied!
Do NOT rely on:

SharePoint connector

Native MCP action

for tenant-wide site discovery.
Use:

Microsoft Graph API + Azure backend

and let MCP/Copilot orchestrate the experience rather than performing full enumeration directly.

Was this reply helpful? Yes No
CU06051400-0 6 on at

Like (0)

Report
Copy link

Link copied!

Thank you for the suggestion provided.

Was this reply helpful? Yes No