Answered

Filter gallary based on if the dropdown value exists in the column

(0) Share

Report

Posted on by markuslykonhold

Im building a powerapp with a gallary that displays a list with different columns from SharePoint.

I would like to filter the gallary based on column "Country" using a dropdown. The idea here is that inside the list, each row can have values such as "Sweden" or "Norway" or "Norway and Sweden" or "Finland" for example, and the dropdown has a list of items such as ["Sweden", "Norway"].

What I would like to do is that, when i select "Sweden" in the dropdown, the gallary will only show the rows where the word Sweden exists, which means that all rows that have the values "Sweden" and "Norway and Sweden" will show up, but the rows that have the values "Norway" and "Finland" will not show up. The column where the country data is stored inside of the SharePoint list is a text column.

i tried using in , such as 'Country' in countrydrop.Selected.Value , but this only filters to rows that contain only "Sweden", it does not display rows that have "Norway and Sweden" for example.

How can this be done?

Thank you in advance!

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@markuslykonhold

You have your in logic backwards!

It should be:

countrydrop.Selected.Value in 'Country'

I hope this is helpful for you.

Was this reply helpful? Yes No
markuslykonhold 22 on at

Like (0)

Report
Copy link

Link copied!

It worked, thank you so much!

Do you know if its possible to add a search field to the dropdown box? Since I will have 30+ countries in it, It would be easier if the user can search for the country they want to filter for, instead of scroll the list?

Was this reply helpful? Yes No
RandyHayes 76,299 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@markuslykonhold

You would need to use a Combobox instead of a dropdown. The combobox brings two features to the table that a dropdown doesn't - Searching and Multiple Selections.

So...if you want search, switch to combobox.

Was this reply helpful? Yes No
markuslykonhold 22 on at

Like (0)

Report
Copy link

Link copied!

Hi Randy, I tried combo box and the search and filtering works, but the default value of the box is somehow nothing? I have the items ["All" ,"Austria", "Denmark", "Sweden", "Finland"] in the combobox, but somehow the first item is always empty? I have the same items in the dropdown and there the default item is always "All", is it possible to have this in combobox as well?

Thank you!

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@markuslykonhold

Since you have switched to a Combobox...the Default property on it does nothing!!

With a combobox, you need to use the DefaultSelectedItems property (DSI).

That property always needs to be a record that matches the schema of your Items property.

Since your Items property table has a schema of Value (i.e. it's a table with a single column called Value), then you need to specify that in the DSI property.

That property should be: {Value : "All"}

Was this reply helpful? Yes No
markuslykonhold 22 on at

Like (1)

Report
Copy link

Link copied!

Thank you very much for all the help, its sorted out now! 🙂

Was this reply helpful? Yes No