cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Create SharePoint list items from Excel rows

Hi,

 

I need to create multiple SharePoint list items from multiple Excel rows.

I use Excel Get rows and SharePoint Create item. I can create multiple items but only with Title column.

When I try to enter other columns from Excel to other fields, the only option is SharePoint item ID.

Fields Value and Price are my custom SharePoint columns.

 

 

 

Is it possible to create SP items with multiple fields from Excel?

 

Regards,

Marcin

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Power Automate
Power Automate

Re: Create SharePoint list items from Excel rows

@MarcinS I hope I understand your scenario correctly, you are trying to insert values from multiple columns in Excel (e.g. price, value columns) to corresponding columns in sharepoint list (so price, value column), is that right?

 

I created a sample flow Recurrence -> Get Rows from Excel -> Insert into SharePoint list and I'm able to insert SP items from multiple columns in Excel. Here's my excel table: 

Excel.PNG

 

Here's my Flow: 

 

SPList.PNG

 

And the result in SP list: 

 

SPListResult.PNG

 

Is this the scenario that you were trying? Let me know if that helps.

View solution in original post

7 REPLIES 7
Highlighted
Power Automate
Power Automate

Re: Create SharePoint list items from Excel rows

@MarcinS I hope I understand your scenario correctly, you are trying to insert values from multiple columns in Excel (e.g. price, value columns) to corresponding columns in sharepoint list (so price, value column), is that right?

 

I created a sample flow Recurrence -> Get Rows from Excel -> Insert into SharePoint list and I'm able to insert SP items from multiple columns in Excel. Here's my excel table: 

Excel.PNG

 

Here's my Flow: 

 

SPList.PNG

 

And the result in SP list: 

 

SPListResult.PNG

 

Is this the scenario that you were trying? Let me know if that helps.

View solution in original post

Highlighted
New Member

Re: Create SharePoint list items from Excel rows

I lost number formatting in Excel and that was a problem.

Thank you for the hint!

 

Regards,

Marcin

Highlighted
Helper IV
Helper IV

Re: Create SharePoint list items from Excel rows

When "Value" is chosen for some reason for the Title, Value and Price there is no Excel tagged options.  Is there I missed?

Highlighted
New Member

Re: Create SharePoint list items from Excel rows

I just tried to do this, but every time the recurrence occurs, it adds another item for all entries, not just new or edited ones.  Is there a way to just have it update any changes that are made instead of creating additional copies?

Highlighted
Frequent Visitor

Re: Create SharePoint list items from Excel rows

Did you figure this out?

 

Highlighted
Regular Visitor

Re: Create SharePoint list items from Excel rows

Hi, 

 

I have tried the above step however my output in sharepoint list showed some column with blank.

how can i fix it?

Highlighted
New Member

Re: Create SharePoint list items from Excel rows

Hi @Pawel

i am trying the same but i don't have table inside excel sheet,

is there any to create list item from simple excel sheet with rows and columns.

 

thanks in advance

Helpful resources

Announcements
firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (10,467)