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

Categories:

Building Power Apps

DataSheet Table.PNG

People Table.PNG

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

JayMagness 1,663 on at

Like (1)

Report

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

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 on at

Like (0)

Report
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

Thanks. This resolved my query.

Was this reply helpful? Yes No

Join the conversation