web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Can't see data from ex...
Power Apps
Suggested Answer

Can't see data from excel online in power app

(0) ShareShare
ReportReport
Posted on by CU05020841-0
Hi guys, 

I’m using Power Apps with Excel Online (Business) connector.

I signed in with the A tenant (father tenant), when adding data source, I cannot see some Excel files stored in SharePoint sites in tenant A, i only see the excel files in B tenant ( child tenant of A tenant), both tenant are using the same account.

The excel files i want to use are stored in SharePoint sites in tenant A, that are connected to Microsoft 365 Groups (private group).

 

❓ Question:

1. How can i make excel files in tenant A visible in adding data in power apps ?

2. If using a workaround by copying files to SharePoint site in tenant B, what is the recommended way to keep data in sync with the original file in tenant A ?

I have the same question (0)
  • PowerDeveloperTP Profile Picture
    PowerDeveloperTP 357 on at
    Hello,
     
    Could you please let em know where you are trying to create powerapp? Is it in tenant A?
     
    Power Apps data connections are tenant-specific and connection-specific, just like in Power Automate
     
    Thank you.
  • Suggested answer
    11manish Profile Picture
    11manish 395 on at
    This is a tenant context issue in Microsoft Power Apps.
    • Even with the same account, the Excel Online (Business) connector only shows files from the tenant you’re currently connected to.
    Q1: How to access Excel in Tenant A?
    Best fix:
    • Recreate the connection and sign into Tenant A explicitly
    Alternative:
    • Use SharePoint connector and connect directly to the site
    Q2: Sync data if using Tenant B?
    Recommended:
    • Use Microsoft Power Automate
    • Create a flow to copy/sync file from Tenant A → Tenant B

    Power Apps connections are tenant-bound, so you must connect to the correct tenant or use a sync workaround

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the February Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 509 Most Valuable Professional

#2
Haque Profile Picture

Haque 302

#3
11manish Profile Picture

11manish 265

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans