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
)
)
)
Solved! Go to Solution.
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.
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.
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.
Thank you this worked well.
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.
User | Count |
---|---|
258 | |
111 | |
95 | |
48 | |
41 |