I am having trouble with this expression.
I have an audit app. I have a workflow that fires whenever someone is OVERDUE on their audit.
I want one email to EACH person.
I use the following expression โIf this is trueโ on a Send Email workflow: [Send_Overdue]=โOverdue Email Neededโ There are a number of people who have overdue audits. This expression works as needed. Only those who are overdue are โtrue.โ
If I try either of these expressions in the โTo [send email to these addresses]โ line, I have an issue.
SELECT(Send_Emails[email],[send_overdue]=[_THISROW].โOverdue Email Neededโ,TRUE)
That expression wants to send an email to EVERYONE who is overdue, not just the person on the row.
So the individual gets an email, but it also goes to EVERYONE.
lookup(โOverdue Email Neededโ, โSend_Emailsโ, โSend_Overdueโ,โemailโ)
This expression seems to do the same thing.
Basically, if there are 5 people overdue, I want 5 emails sent. 1 to each individual. As the two expressions work now, 5 emails are sent to 5 people. The one that SHOULD come to me goes to everyone.
Just so you can see both sets of expressions.
Thatโs because SELECT() creates a LIST of things, and the logic for your formula says
I think the solution you need is to simply enter the column name that holds the email into the space where you have this select.
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |