How to convert my live text search solution to delegatable function?

(0) Share

Report

Posted on by probacska

Hello,

I would like to rewrite my live search code to delegatable, but some functions are not delegatable.

With(
 {
 _max: Max(
 Filter(
 Naplo_1;
 AccountingDate >= DatePicker1.SelectedDate;
 AccountingDate <= DatePicker2.SelectedDate
 );
 Sum(
 ForAll(
 Split(
 Trim(TextInput1_1.Text);
 " "
 );
 {
 Value: If(
 Result in Naplo_1[@DocNumber] || Result in Naplo_1[@Supplier] || Result in Naplo_1[@Operation];
 1;
 0
 )
 }
 );
 Value
 )
 )
 };
 SortByColumns(
 Filter(
 Naplo_1;
 AccountingDate >= DatePicker1.SelectedDate;
 AccountingDate <= DatePicker2.SelectedDate;
 IsBlank(TextInput1_1.Text) || Sum(
 ForAll(
 Split(
 Trim(TextInput1_1.Text);
 " "
 );
 Result in Naplo_1[@DocNumber] || Result in Naplo_1[@Supplier] || Result in Naplo_1[@Operation]
 );
 Value
 ) = CountRows(
 Split(
 Trim(TextInput1_1.Text);
 " "
 )
 )
 );
 NaploSortColumnName;
 NaploSortDir
 )
)

This is the official list of usable operations/functions: