web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Error Handling
Suggested Answer

Column in gallery changed from text to ID

(1) ShareShare
ReportReport
Posted on by 7

Greetings!

I'm experiencing an issue where one column in my gallery is switching from showing text to showing the record ID (see image below). It changed automatically and is now mixing text values and numeric IDs in the same column. How can I fix this?

This is happening in a Gallery control, and the label for this column is using the following expression:

ThisItem.Ensaio_Contato



 
I have the same question (0)
  • wolenberg_ Profile Picture
    1,013 Moderator on at
    Column in gallery changed from text to ID
    Hi @MD-02122134-0 , neither the image or the source code that you tried to paste on the post, are not avaliable to see , try to upload again the attachments please.
  • MD-02122134-0 Profile Picture
    7 on at
    Column in gallery changed from text to ID
    @wolenberg_, thanks for the observation. I've made an update and attached it.
  • MS.Ragavendar Profile Picture
    4,910 Super User 2025 Season 2 on at
    Column in gallery changed from text to ID
     
    What is the data source you being used in the application and what datatype does this column belongs to - Ensaio_Contato ?
     
    If your data is coming to powerapps in this record format.
     
    {
      Id: 1030,
      Value: "Aleisa Fernanda Maia"
    }
    Instead of ThisItem.Column try ThisItem.Ensaio_Contato.Value
     
    Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.
    ❤️ Please consider giving it a Like, If the approach was useful in other ways.
    🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.
  • Suggested answer
    wolenberg_ Profile Picture
    1,013 Moderator on at
    Column in gallery changed from text to ID
    Hi, 
    This usually happens when the field `Ensaio_Contato` is a complex type, like a lookup or person field and Power Apps starts showing the record ID instead of the display name.  
     
    How to fix it
    Instead of using:
    ThisItem.Ensaio_Contato

    Try referencing the display field explicitly, like:
    ThisItem.Ensaio_Contato.DisplayName

    or
    ThisItem.Ensaio_Contato.'Full Name'

    (depending on what field you want to show — use IntelliSense to see available options after typing the dot).  
    If `Ensaio_Contato` is a lookup to another table, you’ll need to reference the field from that related record that holds the name you want to show.  
     
    In short: the column is showing IDs because it’s a complex record just point to the specific field inside it that holds the name. That’ll bring back the readable text.

     

    If this helped or could help others in the community, feel free to give it a like or a kudo — it helps surface useful answers for everyone!


     

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

Coming soon: forum hierarchy changes

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 803 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 314 Super User 2025 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 253 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics