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

(0) Share

Report

Posted on by Anubha Soni

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

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Where do you want to upload the records from excel?
Is it Dataverse?

Was this reply helpful? Yes No
Anubha Soni 8 on at

Like (0)

Report

in powerApps, on Screen

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

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

Was this reply helpful? Yes No
v-albai-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No
Anubha Soni 8 on at

Like (0)

Report
Hi,

On this Screen, User will click on Upload Button and I want to show uploaded excel sheet records for this my questions are :
How User will upload the document on document library from button?
On Button click I want to read the data.
and want to show this records in gallery.
This functionality I want to perform but not getting how and what steps I follow.

Was this reply helpful? Yes No
v-albai-msft on at

Like (0)

Report

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

Was this reply helpful? Yes No