cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TheOpeningBat
Helper III
Helper III

Upload excel file in powerapps & save to sharepoint list

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.

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
mequan
Community Support
Community Support

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

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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

yes that is what I am looking to do

mequan
Community Support
Community Support

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

TheOpeningBat
Helper III
Helper III

Thanks @mequan. Will try the flow route.

Helpful resources

Announcements
Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

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.

<
Users online (3,500)