I've got a list with ~4500 Elements.
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:
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?