Answered

Delegation Warning - Dataverse Gallery Filtering

(0) Share

Report

Posted on by 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
)
)
)

Categories:

Using Apps Using Formulas

All responses (4)

Answers (1)

Florida712 78 on at

Like (0)

Report

Re: Delegation Warning - Dataverse Gallery Filtering

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.
Florida712 78 on at

Like (0)

Report

Re: Delegation Warning - Dataverse Gallery Filtering

Thank you this worked well.
Verified answer

RandyHayes 76,287 Super User 2024 Season 1 on at

Like (1)

Report
Re: Delegation Warning - Dataverse Gallery Filtering

@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.
Pstork1 66,004 Most Valuable Professional on at

Like (0)

Report
Re: Delegation Warning - Dataverse Gallery Filtering

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.