Filter return value other than key

[James_Hodges]

Hi,

I have a question to select the names of all crew members on site. This is a list that has a bass type of ref.

I have this filtered so the foreman can only select crew members under them.

The issue is, this is returning the key value of the crew members and I need their names to populate on a report that is automated.

How can I get each of the name values separated by a " ; " for my report?

[TeeSee1]

In your report, use a Dereference expression to get the values of the Name column. i.e. [key col].[name col]

[JuneCorpuz]

The formula in your report should be [Name of all crew members][Column Name For the Name Of the Crew in the Crew Members Table]

[James_Hodges]

The report won't fire when I put in <<[Names of all crew members:].[First Name]>> on the report. 

[Marc_Dillon]

https://help.appsheet.com/en/articles/4575708-list-dereference

[AleksiAlkio · Accepted solution]

You need to use different approach than dereference as you are using Enumlist column type. You can use something like..

SUBSTITUTE(CONCATENATE(SELECT(Crew Members[Name],IN([KeyColumn],[_THISROW].[Names of all crew members]))),",",";")

[James_Hodges]

Thank you!!!! I made a virtual column with this info and it worked!

[AleksiAlkio]

You're welcome! Though you don't need to use virtual column. You can use the same formula directly on your report.