cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
komesuke
Frequent Visitor

I would like to use Power Apps to import data from an Excel file into a SharePoint list.

Hi.

 

I would like to use Power Apps to import data from an Excel file into a SharePoint list.
The image is to upload the file in the application.
Is it possible to do this?

 

Thank you for reading.
Love & Peace

1 ACCEPTED SOLUTION

Accepted Solutions
v-albai-msft
Community Support
Community Support

Hi @komesuke,

Based on your description, you could refer this:

1)format your data of Excel to a table so that you can connect this Excel table.

Also create the needed columns in your sharepoint list to store the value from Excel. 

2)connect with your Excel file and sharepoint list.

3)save your data of Excel to a collection.

Collect(collection1,tablename)  

4)format your collection data(If all your fields name in Excel and SP list are totally same, you can skip this format step):

Collect(collection2,RenameColumns(
ShowColumns(collection1,"field1","field2","field3"),
"field1","field11","field2","field22","field3","field33"))

(Notes:

1. if you only want to update 3 fields into your sharepoint list, you could use ShowColumns function to reduce the number of fields of your Excel table.
2. if the fields name in your excel and sharepoint list are different, you could use RenameColumns function to change the fields' name(to make them the same as those in sharepoint list)

)

 

5)update your sharepoint list with this collection:

Collect(listname,collection2)  

Best regards,

Allen

View solution in original post

3 REPLIES 3
Powerplatform01
Post Patron
Post Patron

@komesuke 

No worries , you can watch this video to resolve your issue.

Also request you to please subscribe this channel.Its help me a lot and also motivates me to help you further

https://youtu.be/9pV5yjLQhBY

Powerplatform01
Post Patron
Post Patron

@komesuke 

It's my humble request to subscribe the channel.

https://youtu.be/9pV5yjLQhBY

v-albai-msft
Community Support
Community Support

Hi @komesuke,

Based on your description, you could refer this:

1)format your data of Excel to a table so that you can connect this Excel table.

Also create the needed columns in your sharepoint list to store the value from Excel. 

2)connect with your Excel file and sharepoint list.

3)save your data of Excel to a collection.

Collect(collection1,tablename)  

4)format your collection data(If all your fields name in Excel and SP list are totally same, you can skip this format step):

Collect(collection2,RenameColumns(
ShowColumns(collection1,"field1","field2","field3"),
"field1","field11","field2","field22","field3","field33"))

(Notes:

1. if you only want to update 3 fields into your sharepoint list, you could use ShowColumns function to reduce the number of fields of your Excel table.
2. if the fields name in your excel and sharepoint list are different, you could use RenameColumns function to change the fields' name(to make them the same as those in sharepoint list)

)

 

5)update your sharepoint list with this collection:

Collect(listname,collection2)  

Best regards,

Allen

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (895)