Return multiple choice column value from SO in Powerapps label with Lookup

Question

I have a powerapps app with a SharePoint Online list set up as a data source. In one of my comboboxes users specify an item name which can be used as a lookup reference to find the correct record in the list. Im trying to look up the relevant record in the list using their selection, and return the value/s of a column in that list which is set up as a choice column allowing multiple slections.

Previously, i have successfully used a standard lookup formula to retrieve values from single choice columns of a specific record; however im really struggling to get this to work when the column to be returned allows multiple choices.

Research points to using the ConCat function to list the values, but i cant get that to work either as i cant find a way to combine it with a lookup to list the values of a specific record. Every example of using ConCat specifies ThisItem, but there isnt a current item from that data set loaded into my app, i want to specify/lookup a specific item.

Any help appreciated, as this is now pissing me off.

Thanks

Answer 1

I'm not sure if I've understood your scenario completely, but here I'm able to concatenate the multi-choice people field's display names based inside a LookUp().

Concat(LookUp('Stack Test', ComboBox3.Selected.Title = Title).MultiPeople, DisplayName, "; ")

"MultiPeople" is the name of my SP list person column, with multi-select enabled.