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.
Solved! Go to Solution.
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
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
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
User | Count |
---|---|
144 | |
97 | |
89 | |
78 | |
56 |
User | Count |
---|---|
194 | |
185 | |
105 | |
99 | |
91 |