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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Gerard Simpson 2,987 Moderator on at

Like (0)

Report
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

Was this reply helpful? Yes No
VinChua on at

Like (0)

Report

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

Was this reply helpful? Yes No
Gerard Simpson 2,987 Moderator on at

Like (0)

Report

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

Was this reply helpful? Yes No
VinChua on at

Like (1)

Report

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!

Was this reply helpful? Yes No