Unanswered

Importing excel into Sharepoint from Powerapps

(0) Share

Report

Posted on by tbenge05

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?

Thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

mdevaney 29,991 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!

@tbenge05
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
https://www.youtube.com/watch?v=jTLJr4U_Gho

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."

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
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:

ForAll( 'YourExcelTable', Patch( 'YourSPList', Defaults('YourSPList'), { 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,

Was this reply helpful? Yes No
tbenge05 6 on at

Like
a
(0)

Report
Copy link

Link copied!

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.

Thanks

Was this reply helpful? Yes No
v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

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,

Was this reply helpful? Yes No