Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

How can I upload the excel sheet and view the data in gallery in PowerApps

Hi Experts,


please help me in solving the problem, that I want to upload the excel sheet on button click. 


and also want to show uploaded file records in gallery, for confirmation.


Thanks in advance.


Anubha Soni

Helper II
Helper II

Where do you want to upload the records from excel?

Is it Dataverse?

Regular Visitor

in powerApps, on Screen

You can add a Add picture control and on the button click, you can call a flow to copy the uploaded excel file to sharepoint or one drive.

You can then use a Excel Online connectors to read from the excel file and bind it to gallery.



Please click Accept as solution 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 giving it Thumbs Up



Community Support
Community Support

Hi @Anubha ,

What do you mean about "upload the excel sheet on button click"? Where do you want to upload the excel file to? Into SharePoint or into OneDrive? Or just want to upload the whole Excel data into a collection? 

How do you get the excel file? Using Attachment control? Or from the gallery record(Gallery.Selected.File)?

Please provide more information about your requirement and how do you get the Excel file so that we can help you better.

Best regards,





On this Screen, User will click on Upload Button and I want to show uploaded excel sheet records for this my questions are :

  1. How User will upload the document on document library from button?
  2. On Button click I want to read the data.
  3. and want to show this records in gallery.

This functionality I want to perform but not getting how and what steps I follow.



Hi @Anubha ,

To upload files into SharePoint library, you need to use Flow. Refer to below article for more detailed information about how to use flow to upload files. 

However, currently, we could not create an connection to a Excel file stored in a SP Library from PowerApps app. So we cannot directly display its records in gallery. We can only get the file itself but cannot get its contents. If you would like this feature to be added in PowerApps, please consider submit an idea to PowerApps Ideas Forum:

Best regards,


Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (4,887)