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

Categories:

Building flows

I have the same question (0)

All responses (8)

Answers (1)

Verified answer

Pawel on at

Like (5)

Report

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

Was this reply helpful? Yes No
MarcinS 5 on at

Like (0)

Report

I lost number formatting in Excel and that was a problem.
Thank you for the hint!

Regards,
Marcin

Was this reply helpful? Yes No
ez1138 218 on at

Like (0)

Report

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

Was this reply helpful? Yes No
gwhite4 6 on at

Like (1)

Report

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?

Was this reply helpful? Yes No
Afex 4 on at

Like (0)

Report

Did you figure this out?

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Hi,

I have tried the above step however my output in sharepoint list showed some column with blank.
how can i fix it?

Was this reply helpful? Yes No
bilaldev1 28 on at

Like (0)

Report

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

Was this reply helpful? Yes No
danielleruns 57 on at

Like (1)

Report

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

Was this reply helpful? Yes No