Answered

combine excel rows and upload in sharepoint

(0) Share

Report

Posted on by Gokulraaj_55

Hi,

I need to combine the rows from the excel data which have same values and add it in a single line in sharepoint list. refer the images

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-yetonggu-msft on at

Like (0)

Report
Hi @Gokulraaj_55 ,

When several rows in an excel table have the same number, merge the text values in them into one row in SharePoint?

If so, I did a test for your reference.

In my scenario:

The prerequisite is that you have to insert a table into excel.

My Table:

My SharePoint List:

My Flow:

item()?['Title'] union(body('Select_2'),body('Select_2')) items('Apply_to_each') item()?['Text']

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
Gokulraaj_55 6 on at

Like (0)

Report

Hi,
this output is what i needed, but if i take a row it will contain number column and text column, i need to concadinate every thing into a single sharepoint list item.

for example,
the above table is the data and also i have the same columns in the sharepoint list. I need to combine all the rows which have have same network in a single sharepoint list item.
This how i need the output to be in the sharepoint list. Kindly help to complete this.

Thank you.

Was this reply helpful? Yes No
v-yetonggu-msft on at

Like (0)

Report
Hi @Gokulraaj_55 ,

My Excel Table:

I suggest you change the 'Text' column name in the SharePoint list to lowercase 'text', otherwise a frame line will appear outside the value, which will affect the appearance.

My SharePoint List:

My Flow:

item()?['Network'] union(body('Select_Network'),body('Select_Network')) items('Apply_to_each')

item()?['Text'] item()?['Order'] item()?['SOP']

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No