Power Platform Community Forum Thread Details

Hello,

So just do better explain what im trying to accomplish here´s what im trying to do:
I have two sharepoint lists with a column with the users emails. The 1st one as all of the users and their emails, then 2nd one just some of them. What i want to do is to compare both of the columns and for the emails that aren´t on the 2nd list to send an email to those users.

The problem is when im trying to get the column as an array it doesnt work and just automatically does an "apply to each" and as such it makes me compare the items 1 by 1.

So following that i tried to solve the problem creating the flow as is shown bellow:

I the condition i´m not even comparing the "UserEmail" field of the 2nd list anymore becuase it would create another apply to each and what would happen is that the flow never stopped. Even right now just trying to compare the all body of the parse trying to find the email there it just doesnt stop running, now error no nothing, so my best guess is that both options would create an infinite loop but for as much as many solutions as i have tried none have worked!