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 / Cannot connect to shar...
Power Apps
Unanswered

Cannot connect to sharepoint excel file

(0) ShareShare
ReportReport
Posted on by HansHeintz 711

Added connector excel online.

Added a xlsx file to the documents folder of a sharepoint site

Using the connector browse to the site then to the folder: no files show up.

Add the link to the file from sharepoint maually in stead:

"Invalid hostname for this tenancy"

App already has access to this folder in may other usecases.

I can open the file from the folder in excel no problem.

What's wrong?

I need to use this file as an import prouct catalog from a company and replace it with the most actual version form time to time so tinkering with the file after uploading is no option.

Categories:
Building Power Apps
  • BCBuizer Profile Picture
    BCBuizer 22,899 Super User 2026 Season 2 on at

    Hi @HansHeintz ,

     

    What connector are you using? If it's SharePoint, try refreshing the datasource:

     

    BCBuizer_0-1685950987905.png

     

  • v-qiaqi@microsoft.com Profile Picture
    v-qiaqi@microsoft.com Microsoft Employee on at

    Hi @HansHeintz,

    Do you mean that the file stored on SharePoint site disappears when you select files in the aimed folder?

     

    I have a test and the situation is confirmed on my side, I could select file from the folder of the site.

     

    First of all,  I don't think Power Apps supports Excel file to work from SharePoint Document Library.

    Then, SharePoint files may not be available. The Graph API doesn't pass the user's IP address to SharePoint. Therefore, if a location-based policy is enabled, SharePoint cannot determine whether the user is within the trusted boundary.

     

    In other word, I would not suggest connect to ExcelOnline so that you could use an excel file on SharePoint site as the data source, which is unstable.

    Relatively speaking, only the Excel file stored in OneDrive for Business is supported as data source.

    The Excel data source is very limited, even if you can get it to work from the OneDrive file.

     

    In short, exporting this excel file to a SharePoint list is the best 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 354 Super User 2026 Season 2

#2
M Bilal Khan Profile Picture

M Bilal Khan 330

#3
Mohsin Ali Profile Picture

Mohsin Ali 232

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