This seems simple but I am thinking that I am missing something here.
I have a row (below is the row with title)
Item Name (unique) Email? Email Address
Item1 Yes firstname.lastname@example.org
Item2 No email@example.com
Item3 Yes firstname.lastname@example.org;email@example.com
I am querying the 'email' column and trying to email the adjacent email address if the result is 'Yes'. How can I go on to do this? (How can I tell the workflow to grab email address if the email column says 'Yes')?
The email would say 'item1 is due' (that is the purpose)
Thanks in advance!