Unanswered

Gallery with multiple filters and combobox delegation issue

(0) Share

Report

Posted on by VinChua

Hi,

I have a gallery with multiple filters from dropdowns, search bar and a combobox, I am having issues with delegations since I have more than 2000 records. Can you suggest any other workarounds that is delegable. You may see my code below:

Filter('Laptop Pickup Scheduler', StartsWith(Allocation, txtSearch.Text) Or StartsWith(Title, txtSearch.Text) Or StartsWith('Ticket Number', txtSearch.Text),
btnTransactions.Text = "All" || 'Transaction Type' = btnTransactions.Text, Status = "For Rebuild" || Status = "For Remed" || Status = "For Release" || Status = "Unclaimed" || Status = "Cancelled", IsBlank(cbStatusFilter.SelectedItems), IsEmpty(cbStatusFilter.SelectedItems), Status in cbStatusFilter.SelectedItems,
drpBUFilter.Selected.Value = "Select BU" || BU = drpBUFilter.Selected.Value,
drpLocationFilter.Selected.Value = "All" || Location = drpLocationFilter.Selected.Value,
IsBlank(dpDateFilter.SelectedDate) || 'Pick Up Date'>= dpDateFilter.SelectedDate && 'Pick Up Date' <= dpDateFilter_2.SelectedDate )

Categories:

General Questions

All responses (4)

Answers (0)

VinChua on at

Like (1)

Report

Re: Gallery with multiple filters and combobox delegation issue

Hi @AmDev ,

I manage to fix the issues with some tweaks with your code, it is now working with the filters I needed. thank you!
Gerard Simpson 2,987 Super User 2025 Season 1 on at

Like (0)

Report

Re: Gallery with multiple filters and combobox delegation issue

Can you share the items property and data for the cbStatusFilter like as follows?

Can you also share your updated code and confirm the column type for 'Status'?

Cheers
VinChua on at

Like (0)

Report

Re: Gallery with multiple filters and combobox delegation issue

Hi Amdev thanks for replying, yes this is for sharepoint and yes I have multiple options for my combobox which can be selected simultaneously.

I have already tried your suggestion but nothing is showing in my gallery even if I haven't selected any at my filters yet
Gerard Simpson 2,987 Super User 2025 Season 1 on at

Like (0)

Report
Re: Gallery with multiple filters and combobox delegation issue

Hi @VinChua

Is this for SharePoint?

It looks like the issue you have is the use of the 'in' operator, which is not delegable in SharePoint

Status in cbStatusFilter.SelectedItems

Am I right in assuming you are allowing multi select in the cbStatusFilter? - if so, what you can do is replace that element (the above extract) of your code with something like this,

Status.Value = Last(FirstN(cbStatusFilter.SelectedItems , 1)).Value ||

Status.Value = Last(FirstN(cbStatusFilter.SelectedItems , 2)).Value ||

Status.Value = Last(FirstN(cbStatusFilter.SelectedItems , 3)).Value ||

Status.Value = Last(FirstN(cbStatusFilter.SelectedItems , 4)).Value ||

Status.Value = Last(FirstN(cbStatusFilter.SelectedItems , 5)).Value

The above is based on an assumed total 5 nr of potential Status options - if you have more or less potential status options, you can adjust the number of items accordingly

Hope this helps