How to send an email when a response is submitted and the sharepoint list column has a certain value

[diegoandre10]

Hi all

I am trying to send an email when 2 conditions are met:

First, when a response is submitted and the email goes into the sharepoint list called "Registered Users":

Second, when the sharepoint list "Onboarding KPI - Completion" column called "Count" has a value of 6 for the user that was registered already:

So if email exists in both sharepoint lists and the count is six, then send an email. In the above example, "disaenz" should get an email.

I tried a flow like this but was unsuccessful:

How can I get it right?

Thanks!

[ScottShearer · Accepted solution]

@diegoandre10 

First, I am assuming that there is only one entry in the Onboarding KPI list for a given email address - is that a correct assumption?

In addition, I am assuming that there will always be an entry for a user in the Onboarding KPI list when a Forms is submitted and the entry is added to the Registered Users list.

You need to filter the data coming from the Onboarding KPI list so that only items where the title equals the email address are returned - if the email address is unique in each list then only one row of data should be returned.  

Click on Show advanced features and configure the filter query like what I have below:

Replace XXX with a reference from Dynamic properties to the individuals email address.  If the user is the one who submitted the Form you can usually get that from the response details.  Also note the single quotes around where the email address will be - they are required.

Please let me know if this works for you.

[diegoandre10]

Hi @ScottShearer 

When I try to test the flow when a response is submitted nothing happens:

One thing I notice is that even though I just have 1 form created, in Power Automate I see 3:

I changed the flow as you mentioned but nothing happens:

Any idea what could be wrong?

Thanks!

[diegoandre10]

Hi @ScottShearer !

Do you see any potential mistake in my last flow?

Thanks!

[ScottShearer]

@diegoandre10 

Sorry for the delayed response.

Take a look at the output of a run - were any records returned from Get items?

The comparison is case sensitive - verify that the email address that was submitted via Forms matches the case of what is in the list.  If that is the issue, I'll show you how to correct.