Hello everyone. Quick question.
I try to create bot automation for email. My objective is if user choose any Issue Category, the system will email all recipients whos assigned to handle the issue. *Refer image below*
I try to use Lookup but Appsheet only return 1st row for each Issue Category. And also I try using different expression but still failed.
So, how do I return multiple column, using 1 expression?
Solved! Go to Solution.
I assume you are triggering the Bot from another table that has "Category" column. Try something like..
CONCATENATE(SELECT(Send Email[Recepients],[Issue Category]=[_THISROW].[Category]))
I assume you are triggering the Bot from another table that has "Category" column. Try something like..
CONCATENATE(SELECT(Send Email[Recepients],[Issue Category]=[_THISROW].[Category]))
Yes,,I do have another table that trigger the Bot. And your code works !! Thanks a lot sir. Appreciate your help.
Good to hear!
User | Count |
---|---|
27 | |
26 | |
22 | |
21 | |
21 |