Hello,
I'm having delegation problems with the filter applied with ComboBox1_2:
ClearCollect(
colFilteredDVTasks;
AddColumns(
AddColumns(
AddColumns(
AddColumns(
If(!IsBlank(cbm_Status_AllTasks.SelectedItems);
Filter(
ShLi_Tasks;
StartsWith(
Name;
TextInput1_4.Text
);
If(varCurrentLanguage="de";
'Task Status' in cbm_Status_AllTasks.SelectedItems;
'Task Status'in colStatusTasks);
If(CountRows(ComboBox1_2.SelectedItems)>0;ResponsibleMail in ComboBox1_2.SelectedItems.Mail;true)
);
Filter(
ShLi_Tasks;
StartsWith(
Name;
TextInput1_4.Text
);
If(CountRows(cmb_0_Responsible.SelectedItems)>0;ResponsibleMail in cmb_0_Responsible.SelectedItems.Mail;true)
)
);
"orderTitle";Order.Name);
"orderId";Order.OrderId);
"category";Order.Name);
"lvl";2)
);;
ClearCollect(
colFilteredOrders;
ForAll(Distinct(
colFilteredDVTasks;
orderId
); {Result: ThisRecord.Value})
);;
ForAll(
colFilteredOrders;
With(
{r: ThisRecord.Result};
Collect(
colFilteredDVTasks;
{
orderTitle:LookUp(colFilteredDVTasks;orderId=r).orderId & " - " &
If(!IsBlank(LookUp(ShLi_Orders;OrderId=r).Category.Name);LookUp(ShLi_Orders;OrderId=r).Category.Name;"/") & " - " &
LookUp(colFilteredDVTasks;orderId=r).orderTitle;
orderId: LookUp(colFilteredDVTasks;orderId=r).orderId;
lvl: 1
}
)
)
)
Does anyone have any idea how to fix it?
Thanks in advance
