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

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Power App from Sharepo...
Power Apps
Unanswered

Power App from Sharepoint hosted excel file

(1) ShareShare
ReportReport
Posted on by 240

Hello,

 

Please could someone help in explaining how to/or if it is possible. 

 

To create a power app, that has the data source of an excel file saved within Sharepoint?(not a list).

 

When I have attempted this, i am unable to locate this file when search for a data source within connectors.

 

Many thanks

Chris

Categories:
I have the same question (0)
  • Verified answer
    poweractivate Profile Picture
    11,078 Most Valuable Professional on at
    Re: Power App from Sharepoint hosted excel file

    @Appy1 I recommend neither to use Excel from a SharePoint document library nor OneDrive.

    I believe only the Excel file stored in OneDrive for Business is supported as data source, I don't think it works from SharePoint Document Library.

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

    It may be difficult to use because it may lock the Excel file for editing from other users for many minutes at a time whenever the Excel file is accessed by Power Apps and/or when it is accessed any other way such as directly through Excel Online, which may cause the app to not be able to update it either.  For example check here
    Workaround: The requested ressource is locked. Cannot write , Power App Error Message - The Requested Resource is Locked 

    So I recommend to use a SharePoint List instead, since even for small test scenario the Excel data source may have some practical issues due to the above. 

     

    The SharePoint List data source is very powerful, I recommend you use it as your first data source, and SharePoint Lists may be the only data sources you need in many cases.

     

    See if it helps @Appy1 

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

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 757 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 322 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 209 Super User 2025 Season 2

Last 30 days Overall leaderboard