web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Filtering a dropdown u...

Power Apps

Answered

Filtering a dropdown using multiple records

(0) Share

Report

Report

Posted on by gustavogrosman

25

Hello again!

Now i'm having trouble trying to use a filtered table, as a local variable, with 1 or more records to filter a dropdown.

The "Item" config. in the dropdown component, so far:

Filter(
 'Pontos de Lubrificação';
 ID in lclTabFilt[@IDRotina]
)

The local table contains a key ('ID Rotina') that is the reference to the filter.

I've tried to use different methods, none have worked, this is the closest i've reached, but it only returns a single option in the component.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (3)

Answers Img

Answers (2)

Sort by

charlessexton 11 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
I obviously can't test it, but you might want to do something like this:
Filter( AddColumns( 'Pontos de Lubrificação', "KeepThis", Not(IsBlank(LookUp('Pontos de Lubrificação', 'Pontos de Lubrificação'.[@ID] = lclTabFilt[@IDRotina]))) ), KeepThis )

It's essentially adding a new column called "KeepThis", which is a boolean result of a lookup for the record inside of your table. If the record exists in your table then it pulls it through.

Was this reply helpful? Yes No
Verified answer

v-qiaqi@microsoft.com Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @gustavogrosman,

If you want to filter records based on id in your local table, maybe you could try this:

Filter( 'Pontos de Lubrificação'; ID in lclTabFilt.IDRotina )

Was this reply helpful? Yes No
Verified answer

gustavogrosman 25 on at

Like
a
(0)

Report
Copy link

Link copied!
@v-qiaqi-msft @charlessexton
Thanks to everyone who took the time to try and help.
It turns out that yours truly was using the wrong column in the filter 😑
Solution as follows

Filter( 'Pontos de Lubrificação'; ID in lclTabFilt.IDPonto )

Was this reply helpful? Yes No

Join the conversation