cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Displaying Choice Columns in a Gallery in PowerApps

I need some help trying to display a selected Item from a drop-down list.  The Items were set-up in SharePoint as "Choice" Column.  Is there a work around for getting "Choice" columns displayed in a gallery in PowerApps?  The error message I get is "the property expects Text values, but this rule produces incompatible Record values".  

 

Please let me know if more info/data is needed. 

20 REPLIES 20

My hero 🤗

Thanks @shockwaveAndrew  for This solution!👍

Anonymous
Not applicable

I was facing the same issue, and it worked! THANK YOU SO MUCH

ThisItem.Status.Value
This does not work. I'm not able to see any of Choices and Lookup Dataverse columns as an option to include my PowerApps gallery. Any suggestions?

 

Thanks !! 

It didn't worked the first time i tried, but no problem at 2nd try.

 

For LineBreak, type Char(13), maybe you have already found 4 years later 😄

 

 

Concat(ThisItem.ContratAssurance.Value; Concatenate(Text(Value);Char(13)))​

 

 

 

Thanks!  I had the problem and with your solution I could solve it!!

 

veronica

If the column name ("Status" in this case) is one word:

ThisItem.Status.Value

If the choice column has a multi-word name such as "Status Type"  try:

ThisItem.'Status Type'.Value


Anonymous
Not applicable

This is fantastic, exactly what I needed, thank you.

All you need is this really. It worked for me:

ThisItem.'Room Finishes'.Value
Anonymous
Not applicable

The solution worked almost to perfection. I had to delete the last part with the Char value (perhaps because I´m using swedish language?)

 

Strange part is that i did not need the ' sign for 'förvaltning'. I expected it since "ö" is a specialletter?

 

This worked for me, made my day!!

 

Concat(ThisItem.Förvaltning.Value; Concatenate(Text(Value)))

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
Top Kudoed Authors
Users online (3,970)