Filtering Records in Gallery based on Dropdown

(0) Share

Report

Posted on by LukasToman

Hello, I need help. I am using Power Apps and a form that is connected to a SharePoint list for storing personal data.
I have List1 where the Title field is for First Name and Last Name, then Years of experience, and a Yes/No field for the Published status.

In List2, the Title field is again for First Name and Last Name, and there is a Choice field named Skills for various skills (multi-choice).

I need to display in the gallery only the Titles(FistrNameLastName) where the skills selected in the dropdown match (all or some) the values entered in the Choice field named Skills in List2.

Categories:

Power Apps component framework

Power Platform Build Tools

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

WarrenBelz 151,627 Most Valuable Professional on at

Like (0)

Report
Filtering Records in Gallery based on Dropdown

Hi @LukasToman

Note that the Value in blue may be a different name depending on the Items of your Combo Box. Also the structure is to manage potential Delegation issues
Ungroup( ForAll( ComboBoxName.SelectedItems As _Data, Filter( List2, Skills.Value = Data.Value ) ), Value )

If you are not concerned with Delegation limitations
Filter( List2, Skills.Value in ComboBox.SelectedItems.Value )

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No
WarrenBelz 151,627 Most Valuable Professional on at

Like (0)

Report

Filtering Records in Gallery based on Dropdown

@LukasToman,

A quick follow-up to see if you received the answer you were looking for or if you need further assistance.

Please click Does this answer your question 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 a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn

Was this reply helpful? Yes No