Hi Community,
I need your helping hand please for the follwing challenges.
I runs through a list in present table to add new items to a sharepoint list. All wens well so far. Now I get to a point to add the values from multiple lines in the excel to one particular Item (field) on sharepoint.
Exampel what I like to archive:
| Unipe ID | Comment | comment by | | ITEM ID | Sharepoint field Comment (multiple line text) |
| 1234 | This is line 1 | Mr X | | 1234 | This is line 1 - Mr X
and this is line 2 - Ms Y
and point 3 - Mr T |
| 1234 | and this is line 2 | Ms Y | | | |
| 1234 | and point 3 | Mr T | | | |
| 555 | Trallalal | Mr Y | | 555 | Trallalal - Mr Y
Cheers - Ms X |
| 555 | Cheers | Ms X | | | |
So I now about 'join' expression to combine the excel rows. I run through 'apply to each' - but how do I "collect" all relevant values that are related to one Unique ID - add it to the sharepoint Item and then run to the next one doing similar?
Thx a lot for your advise as I try already a lot to archive this.
