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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Gallery, Listing ID
Power Apps
Answered

Gallery, Listing ID

(0) ShareShare
ReportReport
Posted on by 218

Hi, from my galleries I have the data showing up as ID.  How do I modify it to show the value from the SQL table?

 

ThisItem.'POC - Billing'

Categories:
I have the same question (0)
  • eka24 Profile Picture
    20,923 on at

    What you have done is ok:

    ThisItem.ID

    ThisItem.'POC - Billing'

     

    Usually it should be

    ThisItem.ColumnName

     

    If that doesn't work, show the SQL column so it could be changed to suit that.

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • ez1138 Profile Picture
    218 on at

    Thanks. I have multiple tables that pull from the Company Table. So I have Company_ID for my Contacts table, Company_ID for my main table, where I perform evaluations, etc.  So for that table, it's only going to show a "1".  From my Company table, I would like to pull the Company_Name column.

  • Verified answer
    eka24 Profile Picture
    20,923 on at

    Not so clear but understanding is that you want to pull from a different Table. If so then try:

    Where the CompanyName is in the contactTable

     

    LookUp(contactTable,ID=Thisitem.ID, CompanyName)

     

    Or

    Where the CompanyName is in the CompanyTable

     

    LookUp(CompanyTable,ID=Thisitem.ID, CompanyName)

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • ez1138 Profile Picture
    218 on at
    Awesome, with a little tweaking it worked. Thanks!! LookUp('[dbo].[company]', ID = ThisItem.Company_ID, Company_Name)

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard