I want to Upload Excel File in a canvas App

Like (0) Share

Report

Posted on 25 Jul 2022 06:57:20 by faisalmirji123

Hello Guys,

I have an App where the user has to upload the Excel data into the app and the data inside the Excel file has to map the columns in the Dataverse or SharePoint list.

So, I tried uploading the excel using Form Attachment And map the columns using Power Automate But I am Unable to achieve this Functionality...

Plz Guide me through this!!!

Note: The user cannot upload an Excel file to SharePoint or dataverse The Uploadation of Excel file has to be done through the Powerapps Canvas App Itself

Categories:

General Questions

I have the same question (0)

All responses (5)

Answers (0)

WarrenBelz 151,631 Most Valuable Professional on 25 Jul 2022 at 07:21:34

Like (2)

Report

Re: I want to Upload Excel File in a canvas App

Hi @faisalmirji123 ,

This may be quite what you are thinking, but this blog of mine may give you an option. Otherwise, this is a quite complex Power Automate exercise.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
faisalmirji123 19 on 25 Jul 2022 at 07:24:32

Like (0)

Report

Re: I want to Upload Excel File in a canvas App

Thanks @WarrenBelz for the reply... I'll go through the blog and try to fix the functionality and expect you to guide me for any road blocks

Was this reply helpful? Yes No
faisalmirji123 19 on 25 Jul 2022 at 07:30:28

Like (0)

Report

Re: I want to Upload Excel File in a canvas App

Hey the blog asks the user to copy and paste the data from excel... but here in my case the user has to upload the excel file by clicking a button....
Can you suggest me any youtube videos or blogs regarding the topic!!

Was this reply helpful? Yes No
WarrenBelz 151,631 Most Valuable Professional on 25 Jul 2022 at 09:07:00

Like (2)

Report

Re: I want to Upload Excel File in a canvas App

Hi @faisalmirji123 ,

Probably this one from Shane Youg @Shanescows would be a good place to start.

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
faisalmirji123 19 on 01 Aug 2022 at 06:11:02

Like (0)

Report

Re: I want to Upload Excel File in a canvas App

I am stuck with this functionality can anybody give me some hints...

Was this reply helpful? Yes No