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!
Solved! Go to Solution.
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.
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.
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!
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.
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.
User | Count |
---|---|
32 | |
16 | |
15 | |
14 | |
7 |
User | Count |
---|---|
39 | |
19 | |
14 | |
9 | |
9 |