Skip to main content
Community site session details

Community site session details

Session Id : 8bdQ85m6CXMnVUw9uUCH9N
Power Apps - Building Power Apps
Answered

Displaying Choice Columns in a Gallery in PowerApps

Like (6) ShareShare
ReportReport
Posted on 8 Nov 2018 00:13:09 by

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. 

  • Suggested answer
    SaiRT14 Profile Picture
    1,988 Super User 2025 Season 2 on 19 Oct 2024 at 14:19:31
    Displaying Choice Columns in a Gallery in PowerApps
    If(
        IsBlank(ThisItem.'Room Finishes'),
        "No finishes selected",
        Concat(ThisItem.'Room Finishes', Value, Char(10))
    )
  • OK29 Profile Picture
    384 on 19 Oct 2024 at 10:19:57
    Displaying Choice Columns in a Gallery in PowerApps
    Below function worked for me for choice field with allow multiple values.
     
    Concat(ThisItem.Category, Value, ", ")
  • RHeit Profile Picture
    3 on 10 May 2024 at 14:59:43
    Re: Displaying Choice Columns in a Gallery in PowerApps

    Is there a way to build the logic that would NOT put a comma at the end if there is only one value, and NOT put a comma in at the end when there are multiple values. Other than that, solution works great thanks shockwaveAndrew!

  • gstlouis Profile Picture
    on 16 Jan 2024 at 14:22:10
    Re: Displaying Choice Columns in a Gallery in PowerApps

    Thanks for the fix 
    This is definitely weird how they set this up

  • pmallet31 Profile Picture
    17 on 30 Dec 2022 at 15:24:47
    Re: Displaying Choice Columns in a Gallery in PowerApps

    Merci Guillaume pour la version francisée 😎

  • Community Power Platform Member Profile Picture
    on 31 Mar 2022 at 08:25:45
    Re: Displaying Choice Columns in a Gallery in PowerApps

    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)))

  • Community Power Platform Member Profile Picture
    on 12 Mar 2022 at 18:48:02
    Re: Displaying Choice Columns in a Gallery in PowerApps

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

    ThisItem.'Room Finishes'.Value
  • Community Power Platform Member Profile Picture
    on 07 Feb 2022 at 15:37:43
    Re: Displaying Choice Columns in a Gallery in PowerApps

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

  • heres2u Profile Picture
    29 on 02 Dec 2021 at 21:22:17
    Re: Displaying Choice Columns in a Gallery in PowerApps

    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


  • Veronica Profile Picture
    103 on 03 Nov 2021 at 23:38:37
    Re: Displaying Choice Columns in a Gallery in PowerApps

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

     

    veronica

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 791 Most Valuable Professional

#2
MS.Ragavendar Profile Picture

MS.Ragavendar 410 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 275 Super User 2025 Season 2

Loading complete