I've got a list with ~4500 Elements.
With Select I took the output of the Get Elements.
Now I parsed the Select-output with the Parse JSON
Now I want to loop through the output and put Name, Email and Ressort for each entry together into a string variable formatted as HTML.
The HTML should then be put in an email (for testing) and send to me.
Now here's my problem:
When adding a condition, that only entries with Array_Pilotteilnehmer is equal false and put the Compose String in the Yes part, it generates a Apply to Each loop within the first loop.
Now it would loop 4500 * 4500 times my list which should be really slow. I want to avoid looping the SharePoint element itself because it's much slower than working with variables/JSON.
How can I solve this/make it better?