cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
appuser5
Level: Powered On

How to get all look up information from another list for a item

I have two list - one list called "Master" with column Title, ThirdParty with look up and having

another list called "Third Party" with column name Name, Phone, address

 

How can i achieve getting this look up information from column Name, Phone, address using power apps. I am an newbie in Power app.

 

Could some one help with steps or point some blogs.

2 REPLIES 2
Community Support Team
Community Support Team

Re: How to get all look up information from another list for a item

Hi @appuser5 ,

Do you want to filter lookup field based on related list?

Could you tell me here does the lookup field value comes from? I need to know the fieldname.

I assume that the lookup field is related to Name field of Third Party list.

I've made a similar test for your reference:

insert a drop down

set the drop down's Items: Third Party

set the drop down's Value to the field that you want to filter based on: Name/Phone/address

insert a gellery, set the gallery's Items: 

Filter(list4,ThirdParty.Value=Dropdown1.Selected.Name).ThirdParty

Then the gallery will display the lookup fields' value based on the selection of  Name/Phone/address.

126.PNG

 

 

 

 

Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
appuser5
Level: Powered On

Re: How to get all look up information from another list for a item

Let me share my requirement

1. Parent list called "Products", which will get lookup details from related list- image attached 1.png

2.Related list called "Thirdparty", which has the look up columns, ContractTitle, Phone no etc- img2.png

3.  I have the canvas power apps, where the lookup needs to be displayed from related list - canvas.png

 

I tried this formula, it showing error, Filter(Thirdparty,Thirdparty.'ContractTitle'.Value=third.Selected.'ContractTitle').ContractTitle'

Could you please help us to do this.  

Helpful resources

Announcements
thirdimage

New Badges

Check it out!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,445)