Gallery, Listing ID

(0) Share

Report

Posted on by ez1138

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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
ez1138 218 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
ez1138 218 on at

Like (0)

Report
Copy link

Link copied!

Awesome, with a little tweaking it worked. Thanks!! LookUp('[dbo].[company]', ID = ThisItem.Company_ID, Company_Name)

Was this reply helpful? Yes No