cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MarcinS
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
Pawel
Power Automate
Power Automate

@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

8 REPLIES 8
Pawel
Power Automate
Power Automate

@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

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

Thank you for the hint!

 

Regards,

Marcin

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

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?

Afex
Frequent Visitor

Did you figure this out?

 

Hi, 

 

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

how can i fix it?

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

@Pawel Is there a way to do this now that the Get Rows feature has been removed? 

Helpful resources

Announcements
MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Users online (86,374)