Answered

Display value from lookup list column when item is selected in PowerApps

(0) Share

Report

Posted on by carterprine

I have a PowerApp that connects to my "Change Requests" list. It displays a table of the current outstanding requests. When the user clicks on each request in the table, more information about the entry is displayed in a section next to the table, using labels. One of the labels displayed in the 'more info' section is from a lookup column using: Text(FullfillmentRequestTbl.Selected.'Site'.Value)

**Here's where it gets a little tricky...

Is it possible to add a label that pulls a value from another column in the related 'Site' lookup list? Therefore, if the user clicks a request in the table, PowerApps should know that since the selected item's Site Id=94, it should display Site 94's column B, which is only stored in the secondary list (the lookup list), and not the primary request list.

I have both lists connected to my app.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

KrishnaV 5,023 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @carterprine ,

You can absolutely do it as below:

In details table select the field or control where you want to show the URL from other list
Unlock that control
Default value of the Lable as below

LookUP(secondSPList,ID=gallery.selected.ID,siteURLcolumnfromlist2)

I hope this resolved your issue if you see any challenge/need further help please let me know I am always happy to do it for my community.

Regards,
Krishna
If this post helps give a 👍 and if it solved your issue consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No
carterprine 85 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks so much for your help. Sorry, I'm not certain that I phrased the question very well.

Where I have list 1, which has a lookup column "Site RU":

Here, when we click on the "Site RU" item in list 1, we see in list 2, we have the ERP Instance 1 column:

App screen:

Was this reply helpful? Yes No
Verified answer

v-siky-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @carterprine ,

The formula syntax should be like this:

LookUp('SP list 2', ID=Table.Selected.'LookUpColumn'.Id).'target column'

In your case, the code:

LookUp('Reporting ...', ID=FullfillmentRequestTbl.Selected.'Site'.Id).'ERP Instance 1'

Please try it on to see if your issue is fixed.

Sik

Was this reply helpful? Yes No
carterprine 85 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you @v-siky-msft ! You are awesome. That worked perfectly.

Was this reply helpful? Yes No