Hi @Sebe1,
It seems like you can get the list that Accounts for open Opportunities.
You could list all Email accounts, loop through all Email accounts, then use the contains() function to determine the list that Accounts for open Opportunities whether it contains current Email accounts.
For example,
the list that Accounts for open Opportunities, array variable named "List":
[
"Email1@domain.com",
"Email2@domain.com",
"Email3@domain.com"
]
A email needs to determine whether exists in the above list:
Email123@domain.com
contains(variable('List'),'Email123@domain.com')
Then it will return: false
So, you could structure such Flow to loop through Emails needs to judge, if it not exists, append it into an array variable to store these Emails Accounts without open Opportunities.
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.
