Create SharePoint list items from Excel rows

(0) Share

Report

Posted on by MarcinS

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

All responses (8)

Answers (1)

danielleruns 57 on at

Like (1)

Report

Re: Create SharePoint list items from Excel rows

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

Like (0)

Report

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
Community Power Pla... on at

Like (0)

Report

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?
Afex 4 on at

Like (0)

Report

Re: Create SharePoint list items from Excel rows

Did you figure this out?
gwhite4 6 on at

Like (1)

Report

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?
ez1138 218 on at

Like (0)

Report

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?
MarcinS 5 on at

Like (0)

Report

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
Verified answer

Pawel on at

Like (5)

Report

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:

Here's my Flow:

And the result in SP list:

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