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.