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. 

19 REPLIES 19

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
Ignite 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Users online (3,296)