Delegation Warning - Dataverse Gallery Filtering

[Florida712]

Hello,

I have a Gallery that shows data from Dataverse. My table has >50,000 rows added per year hence I am in Dataverse.
I want to avoid delegation warnings.
I have two comboboxes to use as input for filtering the gallery results. The gallery should be empty unless at one of the filter boxes has a value. I can live with only one of the two filter values being applied.

I use this code but get a delegation warning and do not know why (IsBlank, StartsWith, Filter - all should be delegable)

This is the code to address one combobox based filter only.
Thanks a lot

Filter(
'FPO EMS Truck Entry Data',
If(
IsBlank(cmbFilterCarrier_SRS.Selected.carrier),
true,
StartsWith(
Carrier,
cmbFilterCarrier_SRS.Selected.carrier
)
)
) 

[Pstork1]

I believe you are getting the delegation warning because you are using the IF() inside the filter.  Try adding the IF() portion to a With() outside the filter and then use the value from the With in the filter.  Something like this

With({filterValue: If(
IsBlank(cmbFilterCarrier_SRS.Selected.carrier),
true, false) }
Filter(
'FPO EMS Truck Entry Data',
filterValue,
StartsWith(
Carrier,
cmbFilterCarrier_SRS.Selected.carrier
)
)

But I'm not sure what you are using the If() for.

[RandyHayes · Accepted solution]

@Florida712 

Please consider changing your Formula to the following:

Filter('FPO EMS Truck Entry Data',
    !IsBlank(cmbFilterCarrier_SRS.Selected.carrier) && StartsWith(Carrier, cmbFilterCarrier_SRS.Selected.carrier)
) 

I am assuming that Carrier is a text column!

I hope this is helpful for you.

[Florida712]

Thank you this worked well.

[Florida712]

I have the FI-statement to allow me to have the gallery empty if no selection was made. Since I have such a large dataset I do not want all data to be brought in prior to filter or search by the user.
I will work with your approach on a combined filter. Thank you.