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

[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.

[KrishnaV]

Hi @carterprine ,

You can absolutely do it as below:

1. In details table select the field or control where you want to show the URL from other list
2. Unlock that control
3. 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.

[carterprine]

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:

[v-siky-msft · Accepted solution]

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

[carterprine]

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