Power Platform Community Forum Thread Details

Hi,

I have the below scenario that I am struggling with

SPO list ("Global list") item is created where two columns holds semi-colon separated strings (ParentId and ParentName, repreesenting companies), see example below

ParentId	ParentName
123;456;;789	Org1;Org2;Org3
8989;;;	Org4;Org5;Org6
...	...

Now, I want to create x new items in another SPO list, "Engagement list" ( whenever a new item is created in "Global list" (where x = number of companies covered in each item in the Global list, semi-colon separated). Each item needs both of the values from the Global list, i.e. it should look like:

ParentId	ParentName	Extra1	Extra2
123	Org1	TBD	TBD
456	Org2	TBD	TBD
...	...	...	...

So far, I have managed to split the strings in ParentId and ParentName, but since I only can use one of those arrays when looping a Create item, I am only able to either include ParentId or ParentName - but I need them both.

I figured that a new array looking something like the below would solve my problem, but I have not been successful.