cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anubha
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

6 REPLIES 6
subinpius4u
Helper II
Helper II

Where do you want to upload the records from excel?

Is it Dataverse?

Anubha
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.

subinpius4u_0-1626070257831.png

 

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

 

 

v-albai-msft
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,

Allen

Hi,

 

Anubha_0-1626076321567.png

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.

https://www.spguides.com/powerapps-upload-file-to-sharepoint-document-library/ 

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:

https://powerusers.microsoft.com/t5/PowerApps-Ideas/idb-p/PowerAppsIdeas

Best regards,

Allen

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Users online (3,175)