Complex Automate flow that should send and wait for an approval to specific approvers , for specific rows in SP Li

[Carmen15]

First of all I must say that I am a beginner when we talk about Power Automate therefore for logical variables I need the exact formulas to follow. 

In fact I need to build an Automate that should send and wait for an approval . Until now it looks something very simple. 

The things are becoming very complex when I will provide you all the details. 

My SP List looks like the below table. 

I need to create an automate flow that is sending one single email to each Approver asking for approval for the lines he/she is in charge to approve but the corresponding lines to  be highlighted into a CSV file attached . 

For Example : John will receive one single approval request with a CSV file attached for the 3 lines(rows) that he needs to approve. Mary will receive one single approval request with a CSV file attached for the 2 lines(rows) that he needs to approve. And Richard for only one single line(row). 

Note that the real list is having around 2000 rows and the approvers are more than one hundred with multiple corresponding lines(rows) to each one. 

Is it possible ? If yes can I have some indications ?

Thank you so much ! 

Function	Entity	ApproverEmailAddress	Region
xx	yy	John	a
aa	bb	Mary	a
cc	dd	John	b
ee	ff	Mary	c
gg	hh	Richard	b
ii	jj	John	c

[v-litu-msft]

Hi @Carmen15,

I am afraid that your requirement couldn't approach, because the Apply to each concurrency only supports 50 mostly, so it is supported send 50 approvers, only when all of the 50 approvers respond, the next 50 approval requests could send.

Limits and configuration - Power Automate | Microsoft Docs

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Carmen15]

Hi 

Thank you for letting me know. 

I think I can split the SP List into different SP Lists that contain only 50 approvers. Also I can create the same automate flow for each list. 

Do you have some indication for how the flow should look like ? 

I have tried to build something but not sure if it is the right logic : 

For the variables : 

[Carmen15]

I also tried the following logic : 

But something is not oki because I am getting errors 😞