Hi!
That's a very tricky challenge!
So, in order to get all URLs from the SP item that triggered your flow, you need to use split() function.
First I would add an 'Initialize variable' action block, type array, let's call it 'myOutputArray', value empty
Next, I would add an 'Initialize variable' action block, type integer, let's call it 'currentIndex', value 0
Next, I would add an Apply to Each and assign as its input the following expression:
split(triggerBody()?['Column1'],';')
Inside the 'Apply to each' I would:
-add an Append to Array variable, name myOutputArray, value:
{
"Column1": "@{item()}",
"Column2": "@{split(triggerBody()?['Column2'],';')[variables('currentIndex')]}"
}
-add an Increment variable action block, name 'currentIndex', value 1
Now outside the 'Apply to each', I would add dummy Compose action block just for troubleshooting purposes, assign as its value myOutputArray'. THis way when executing the flow you can inspect its content easily.
Next I would add a second Apply to each, assign as its input 'myOutputArray'. Inside this second 'Apply to each' I would add the action block that creates a new row in GoogleSheet
Haven't tested yet, sorry
