Power Platform Community Forum Thread Details

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:

Connectors

Connecting to Data

General Questions

@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