Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Importing excel into Sharepoint from Powerapps

My apologies, I have posted this question in the past - it was marked as solved but the solution provided wasn't what I was looking for. This Powerapp project is a side task that I move back in forth on every so often. It's been about a month since I was able to work on it last. I'll provide some more information to help clarify my intent.


My App is intended to track parts during manufacturing. A list is kept in Sharepoint which my App primarily draws data from. The issue is adding data into the sharepoint list. While it's not that dificult to do, I'd like to streamline the process.

Currently the process is this: 1) Bill of Material and part data is generated in CAD software and exported into excel. The export file has the same colum setup as the srepoint list. 2) the data is then copied and pasted directly into the master sharepoint list.

The ideal situation would be to interface only though the App to ammend the sharepoint list with the list of parts that need to be added.

Is this a possiblity?


Super User
Super User


From what I can tell it sounds like you want to import records from an Excel file to a Sharepoint list.  To this you will have to build a Flow and connect it to PowerApps.  I recommend you try to build the Flow 1st (and forget about PowerApps until you've tested this portion).  This video shows the basic technique.  If you have any questions the Flow community will be able help you out.


Link to Video


Then once you have built the Flow the PowerApps community could help you with building the attachment field.


Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."


Community Support
Community Support

Hi @tbenge05 ,

Could you please share a bit more about your scenario?

Do you want to sync data from your Excel table into your SP List?


If you want to sync data from your Excel table into your SP List, I think the ForAll function and Patch function could achieve your needs.


I have made a test on my side, please take a try with the following workaround:

Firstly, please make sure that you have formatted the data in your Excel file has been formatted as a Table already.

Set the OnSelect property of the "Submit" button in your app to following:

                          Column1:  'YourExcelTable'[@Column1],
                          Column2:  'YourExcelTable'[@Column2],
                          Column3:  'YourExcelTable'[@Column3],

More details about ForAll and Patch function, please chech the following article:

ForAll function, Patch function


Please consider take a try with above solution, then check if the issue is solved.


Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Excel data is generated on a case by case basis by multiple individuals. The Excel data utilizes a template so it matches 1 for 1 the setup of the Sharepoint table. I'll give your code a go, I think I want to replace 'YourExcelTable' with some sort of document search function so the user can navigate to the table they've generated - that's doable, right?
I'm exploring the flow route too, but the video link uses a static file to update sharepoint, as in the name doesn't change and is always in the same directory. I'm seeking further assistance with this in the Flow community.



Hi @tbenge05 ,

Yeah, you are right. Have you taken a try with the Patch function that I mentioned above?


Based on the needs that you mentioned, I think the solution I provided above could achieve your needs. Please consider take a try with it, then check if the solution is helpful in your scenario.


Best regards,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

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.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,432)