Power Platform Community Forum Thread Details

Hello,

I have two excel files, backlog orders and customer emails. The backlog orders excel is over 6000 rows and the customer emails excel is around 200 rows. The backlog orders excel contains all orders from every costumer we have along with order information that I would like to email the customer. Backlog orders has a "BILL TO" column that corresponds with the customer emails excel's "CUSTOMER" column.

What I want to do is append all the backlog order rows of each customer to an array/table and send an email with this information. I've tried using nested Apply To Each functions but the flow just takes way too long and uses up all the calls. Below I have posted my two attempts at a flow:

So as you can see, way too many Apply to Each loops. While this can work for smaller tables, my excel sheets are just way too large and I need a way to get around all of these Apply to Each Loops. I also have a condition that splits the flow since Apply to Each is limited at 5120 loops.

I've also tried a variation of the Pieter method, but I can't see to see how to make it work in my case. Any help would be appreciated!