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]

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!