Unanswered

Help With Flow That Sends Email To List of Users Who Have NOT Completed Form

(0) Share

Report

Posted on by Community Power Pla...

Hi,

I have this flow that is scheduled to email a list of users everyday at 8.30am who have not completed and submitted a form. The flow executes successfully but it sends email to everyone instead of emailing only users who have not completed the form.

The response from the Form is stored in a sharepoint list which includes an email field. I also have another sharepoint list that stores the list of users email. Is the condition check correct? or do I need to add another condition? Appreciate any help please.

All responses (4)

Answers (0)

Community Power Pla... on at

Like (0)

Report

Re: Help With Flow That Sends Email To List of Users Who Have NOT Completed Form

@edgonzales just a friendly reminder when you back online if you could please have a look at my last message, that would be much appreciated. Thanks.
Community Power Pla... on at

Like (0)

Report

Re: Help With Flow That Sends Email To List of Users Who Have NOT Completed Form

@edgonzales I made changes as suggested and flow executed successfully but the intended result is not quite right i.e. no email was sent because the condition was not satisfied. The recurrence trigger is scheduled daily at 8.30am. How do I add condition to check based on Date column in the Response Form Sharepoint List?

Expected result should be: if no response submitted for today's date after comparing the 2 email lists, then send email. So condition will only be checking based on todays date if response submitted.

Hope that makes sense.
Community Power Pla... on at

Like (0)

Report

Re: Help With Flow That Sends Email To List of Users Who Have NOT Completed Form

@edgonzales thank you for the detailed feedback and resource. Will have a go and keep you posted.
Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report
Re: Help With Flow That Sends Email To List of Users Who Have NOT Completed Form

@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.