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
HenryARPhillips
Continued Contributor
Continued Contributor

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

View solution in original post

TheOpeningBat
Helper III
Helper III

Thanks @mequan. Will try the flow route.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,997)