Power Platform Community Forum Thread Details

Hello,

I uploaded an Excel file to SharePoint (under My Documents) and added it as a data source in my Power Apps app. The Excel file contains a formatted Table.

I created a new screen to display and/or export the table data, but the screen is blank.

Could you please explain the correct way to retrieve data from an Excel table stored in SharePoint using Power Apps?

Do I need to convert the data into a SharePoint list, or is it supported to work directly with the Excel file?

Thanks in advance for your help.

Categories:

Connector development

Hi @ES-10022213-0,

I will answer this in two parts - firstly if you have connected the Excel table as a Data Source in your app, then accessing it is no different to any other Data Source. You firstly need a gallery with the Table as the Items and then Text Labels with (using your field names) ThisItem.YourFieldName. You can then create a form to edit/create/view the records. This tutorial may be of assistance.

However Excel is really the "data source of last resort" and has many limitations. If you have access to SharePoint Lists, I suggest you put the data in one of those.

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 ♥
Visit my blog Practical Power Apps LinkedIn