
Hey together,
I try to create a flow, that creates a new item in my sharepoint list and put data from four different powerbi query against datasets into four different columns. When I tried the same with just one quer, that means with just one instead of the four parallel branches, it worked perfectly. But since I added the outputs from every "analyse json" to its associated columns, I get these four nested "for each" actions. Result is, that my flow always skips the steps after second "for each". I also don't get, why the first two for each are working an the last two are struggeling...
Is there a possibility to get around these nested "for each" actions or does anybody have other suggestions to solve the problem.
Thanks in advance,
Lukas
Dear I,
I have not looked at your flow, frankly I do not like the new setup ... but I do have a comment which may help you.
I have circumvented 'Apply to each' loops by using the first() or last() expression.
With these you can call out a 'row' in a loop/array without triggering the 'Apply to each' function. In combination with a right 'Array filter' you can basically call out any 'row' you want.
Try it out, there should be plenty of examples for first() or last() in the forums.
Hope this helps, if so, please tag as solution or like.
Happy flowing,
Koen