You’re offline. This is a read only version of the page.
Announcements
34
Hello dears, how solve below issue, please help me.
"Delegation warning"
The majority of your formula is not delegable.
If you are dealing with now, or will deal with later, more than 2000 records, then your formula will not work as is. If you will never have this situation, then you can ignore the warning message.
If not, then you can narrow your formula by delegable criteria and then post filter by non-delegable.
ex.
Share
Report
All responses (
Answers (
With({_adjustedEnd: DateAdd(DateAdd(DatePicker2_1.SelectedDate, 1, Days), -1, Milliseconds)},
With({preFilter:
Filter('Project daily report',
'Created By'.Email = glbMail &&
Day >= DatePicker2.SelectedDate &&
Day <= _adjustedEnd
)
},
SortByColumns(
Filter(preFilter,
StartsWith(Text(ID), TextSearchBox1_1.Text)
),
"Day",
If(SortDescending1, Descending, Ascending)
)
)
)
The above is a delegable operation and is equivalent to your original formula.
I hope this is helpful for you.
