cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Dudditz
Continued Contributor
Continued Contributor

Displaying Multi Select Option Set in Gallery

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
2 ACCEPTED SOLUTIONS

Accepted Solutions
Dudditz
Continued Contributor
Continued Contributor

Resolved this by using the following.

 

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

View solution in original post

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Dudditz
Continued Contributor
Continued Contributor

Resolved this by using the following.

 

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

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,501)