Return value of multiple rows

[syahir]

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?

[AleksiAlkio · Accepted 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]))

[syahir]

Yes,,I do have another table that trigger the Bot. And your code works !! Thanks a lot sir. Appreciate your help.

[AleksiAlkio]

Good to hear!