Are there any alternatives to writing the below code? I keep on getting a delegation warning.
My goal is to display multiple values selected on the combo box field.
SortByColumns(
Filter(
'Demand App - Log Issues',
Status in ComboBox1.SelectedItems || IsBlank(ComboBox1.Selected.Value) || IsEmpty(ComboBox1.SelectedItems)
),
"LoggedDate",
Descending
)
The in Filter is not Delegable and as you are not using any other filter, there is no Delegation workaround. How many items are in the list?
Currently, there are 6 items.
But is there any other way to remove this warning? It is not a problem as of yet, since I don't have numerous list, but it may in the future.
In the future you may have to prefilter your data, perhaps by a date range to keep the number below 2k items and then apply your formula. There are examples in @WarrenBelz 's blog Practical PowerApps of how to do this.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
User | Count |
---|---|
200 | |
70 | |
51 | |
47 | |
20 |
User | Count |
---|---|
255 | |
120 | |
85 | |
80 | |
68 |