Upload excel file in powerapps & save to sharepoint list

(0) Share

Report

Posted on by TheOpeningBat

130

Hi,

I need to give an option to users to be able to upload an excel file in powerapps after which the records are shown back to the user in a gallery & there will be a save button which will save the data to sharepoint list.

Is this possible in powerapps or any other way to achieve the same.

Any help would be highly appreciated.

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi,

Interesting, so there are obviously methods to get a File into a SharePoint Doc Library.

But have I read it correctly that you would have an excel file with rows of data, upload via Power App, comeback and show the rows in the Power App based on rows in said Excel file.

Then have the ability to upload as a SharePoint list item per Excel row?

Thanks

Henry

Was this reply helpful? Yes No
TheOpeningBat 130 on at

Like (0)

Report
Copy link

Link copied!

yes that is what I am looking to do

Was this reply helpful? Yes No
Verified answer

mequan Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

Hi @TheOpeningBat ,

In power apps, we can't create connector with excel directly, we need use Onedrive connector to create an Excel connector.

So I may suggest you use flow. Let flow get newest file after user upload file, and then mark it in sharepoint. From powerapps side, we only will show SP list data.

Thanks

Was this reply helpful? Yes No
TheOpeningBat 130 on at

Like (0)

Report
Copy link

Link copied!

Thanks @mequan. Will try the flow route.

Was this reply helpful? Yes No