Unanswered

Pulling Data from Another List

(0) Share

Report

Posted on by ez1138

218

Hi, within the PowerApp I'm pulling other list data successfully based on a drop-down of "Company". No issues. Works great.

First(Filter('Company', Company_x0020_Name = Dropdown_Company_Selected.SelectedText.Company_x0020_Name)).Industry.Value

From the screen, the company card displays the company name fine. I named the field "DataCardValue_Company_CompanyName". From the "Company" list, I would like to pull down the details similar to the one on top. The big difference, to me and its functionality, is it is not a drop-down, it's just the card value.

Any insight would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

WarrenBelz 156,119 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @ez1138 ,
You can also use Lookup here
Lookup( 'Company', Company_x0020_Name = DataCardValue_Company_CompanyName.Text, Industry.Value ) OR Lookup( 'Company', Company_x0020_Name = DataCardValue_Company_CompanyName.Text, ).Industry.Value

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
ez1138 218 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi, thanks for the reply. I tried both with no success. I will mess around with them a little and see if I can get one of them to work.

Was this reply helpful? Yes No
ez1138 218 on at

Like
a
(0)

Report
Copy link

Link copied!

Might there be an issue if the Company is a lookup from the list I'm referencing? Basically asking for the workaround where you create the lookup as a single line of text, create a calculated field referencing that one, nuking the single line and creating the lookup?

Was this reply helpful? Yes No
WarrenBelz 156,119 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
OK @ez1138 ,
I tried this syntax on a test list with a lookup column and got the desired result
Lookup( 'Company', Company_x0020_Name.Value = DataCardValue_Company_CompanyName.Text, Industry.Value )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No