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:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Pstork1 69,123 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
Florida712 78 on at

Like (0)

Report
Copy link

Link copied!

Thank you this worked well.

Was this reply helpful? Yes No
Florida712 78 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No