Displaying Multi Select Option Set in Gallery

[Dudditz]

I have a field in a CDS entity using the Multi Select Option Set.  This works as expected in a form which allows you to select multiple Years, example 2017, 2018, 2019.  The data in forms is dispayed showing the year.

I have a gallery that is connected to this entity and this same option set is returning the following error "The Property expects text values, but this rule produces incompatible table values"

It looks like the data is actually stored as a numerical value as seen below and I assume this is what is returning to the gallery.  I am looking for some direction as to the proper way to display the actual name value of this Multi Select Option set within a gallery.

Year

530160001,530160003

[Dudditz · Accepted solution]

Resolved this by using the following.

Concat(ThisItem.Year, Text(Value),",")

[v-xida-msft · Accepted solution]

Hi @Dudditz ,

Have you solved your problem?

Please also take a try with the following formula:

Concat(ThisItem.Year, Text(Value)&", ")

Or

Concat(ThisItem.Year, Text(Value)&" & ")

If you have solved your problem, please go ahead to click "Accept as Solution" to identify this thread has been solved.

Best regards,