web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Display name instead o...

Power Apps

Answered

Display name instead of ids for all the rows in a gallery using Lookup function

(0) Share

Report

Report

Posted on by rsanya

93

Hi,

I have two tables and have connected both the tables to my application.

Table 1: Datasheet

Table 2: People

As you see in the image attached, I want to display the names from People table based on the ids from Datasheet table using Lookup.

The relation for the same is People Id in Datasheet is the foreign key and People Id in People table is the primary key.

Thanks in advance

DataSheet Table.PNG

People Table.PNG

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

JayMagness 1,663 on at

Like (1)

Report
Copy link

Link copied!

Hi,

I am a little confused but feel free to contact me jay@research-nest.com and we can setup a teams meeting and I can try to help you.

Jay

Was this reply helpful? Yes No
eka24 20,923 on at

Like (1)

Report
Copy link

Link copied!

Try:
LookUp(People,ID=Textbox1.Text,NameColumn)

Where Textbox1 hold the I'd on your form
------------

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
Verified answer

v-siky-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @rsanya ,

Please try this formula in your Datasheet gallery

LookUp(People, PeopleId= ThisItem.PeopleId).Name

Hope this helps.

Sik

Was this reply helpful? Yes No
rsanya 93 on at

Like (0)

Report
Copy link

Link copied!

Thanks. This resolved my query.

Was this reply helpful? Yes No

Join the conversation