Unanswered

Filtering a gallery with multiple multi-select combo boxes without a delegation issue

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hello community,

There are a few similar questions on the forum, but unfortunately, none of them helped me with my problem. My app shows data related to a large number of users in a SharePoint list (MySPList). In this SP list, there are a few columns that has multiselect enabled, such as Nationality, Language, City.

In the app, I'm using a Gallery (CandidateGallery) to show these users names, sex, job titles, nationality, language, city and some other details. I also have a search box to search users by their names. Filters on the side of the screen should enable filtering the gallery. Right now, the gallery's item property is recorded as below:

SortByColumns(Search(Filter(MySpList, cityradio.selected.Value = City || cityradio.selected.Value = Blank(), SearchBox.Text, "NameoftheUser"), "NameoftheUser", Ascending)

Every time I try to use one of the suggestions from the forum, I ran into either a delegation issue or the gallery stopped showing any data. I even used Reza's trick by grouping the items on the gallery and changing their visibility property. But because I have multiple multi-select combo boxes (for nationality, language and city) I always ended up with a random problem. Also, most of the questions I found on the forum relate to columns with a different data type. All of my multi select columns are tables. Do you have any suggestions that can help me?

Thank you,

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

WarrenBelz 155,501 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @thatakke ,

The below will not get a warning, but the top filter needs to return item numbers under your Delegation limit

With( { wList: SortByColumns( Filter( MySpList, cityradio.selected.Value = City || cityradio.selected.Value = Blank() ), "NameoftheUser" ) }, Search( wList, SearchBox.Text, "NameoftheUser" ) )

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.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @WarrenBelz
Thanks for your reply. I'm relatively new to MS PowerApps and I'm glad to be able to understand your input. However, I think I couldn't explain my problem well enough. Let me try again.

My nationality, city and language columns are all multi-select choice columns on SharePoint. When I try to add these fields to your suggested input, I'm getting both a delegation warning and a "you can't compare table to table" error. See below I added the Nationality drop-down to match it with the nationality column in SP. Do you have any other suggestions?

Thank you

With( { wList: SortByColumns( Filter( MySpList, cityradio.selected.Value = City || cityradio.selected.Value = Blank() || NationalityBox_2.SelectedItems = Nationality || NationalityBox_2.SelectedItems = Blank() ), "NameoftheUser" ) }, Search( wList, SearchBox.Text, "NameoftheUser" ) )

Was this reply helpful? Yes No
WarrenBelz 155,501 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@thatakke ,

Just so I am clear, are both the Combo Boxes and the SharePoint fields multi-select ? If so you have a many-to-many filter (actually multiple) - please confirm this before we go any further as I do not have a straight-forward solution for that

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @WarrenBelz ,
Yes, you are correct. I have a number of SP choice columns that allow multi-select and the combo boxes on the app allow multi-select. To be honest, I didn't think any other option was possible.

Thank you,

Was this reply helpful? Yes No
WarrenBelz 155,501 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

@thatakke ,

Very complex multi-staged process if at all possible. I do not have time presently to build a model, but will book mark this if I get a chance,

Was this reply helpful? Yes No