web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Displaying two or more...

Power Apps

Answered

Displaying two or more values in a lookup based on a dropwdown value

(0) Share

Report

Report

Posted on by Project2021

40

Hi All,

I have a question.

Let me first sketch the situation:

I have a collection named: Brand_Action, where users can pair an action to a brand.

Brand	Action
Apple	Do this...
Apple	Do that...

Now I have a dropdown with a few brands and I want to display all actions corresponding with that brand.

So if I select "Apple" as my brand I want to see a text displaying "Do this... & Do that..."

I got it to work only displaying the first value (So "Do this..."). I used this code:

LookUp(Brand_Action; Brand = Dropdown_Brand.Selected.Result;Action)

Can anyone help me?

Thanks in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (1)

Sort by

Verified answer

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@Project2021 LookUp returns the First matching record. Use Filter to get all the matching records.
Filter(Brand_Action; Brand = Dropdown_Brand.Selected.Result;Action)

Please remember to give a 👍 and accept the solution as it will help others in the future.

Was this reply helpful? Yes No
Project2021 40 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks it worked!

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@Project2021 Glad to help!

Was this reply helpful? Yes No

Join the conversation