@Anonymous
Good approach on this, here are a couple of things:
- Rather than appending the emails to an array variable, you can just have your recurrence triggers, followed by your Get Items (responses?), followed by a Select action, where you are only pulling in the email address.
- That will alleviate the need for the variable and the first apply to each loop...both of which slow things down a tiny bit.
- After your Get Items 2 (emails), add a select where you are also only pulling in the email addresses only. This gives you two single column arrays to worry about.
From there, follow Pieter Veenstra's blog on comparing those two lists. - https://sharepains.com/2022/01/27/compare-two-arrays-power-automate/
For your apply to each loop, you would probably want to use the output from the select of your Email SP list.
Then in the left side of the condition, put the output of the select of your responses select action, then Contains, and then "current item" as shown in his screen shot. Your send email action would be in the "no" path just as you have it in your original design.
So what we are doing is working our way through the list of email addresses to see if they've submitted a response. If not, they get an email.
That should be enough to get you going. Keep us posted.
Good luck!
-Ed
If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.
