Hello,
I'm sure there's an easy way to solve this, but I'm struggling.
When the cmb_0_FilterStatus is empty, the galley doesn't show any data, but I need all rows to be shown. Does anybody know the key of this?
ClearCollect(
colFilteredOrderListPool;
With({locFilterPool:
AddColumns(
AddColumns(
Filter(
ShLi_Orders;
'ShLi_Orders (Views)'.'Active ShLi_Orders';
(txt_0_FilterTitle.Text in Subject || txt_0_FilterTitle.Text in OrderId) &&
If(CountRows(cmb_0_Responsible.SelectedItems)>0;ResponsibleMail in cmb_0_Responsible.SelectedItems.userPrincipalName;true)&&
If(CountRows(cmb_0_FilterCustomer.SelectedItems)>0;Customer in cmb_0_FilterCustomer.Selected.Mail;true);
If(varCurrentLanguage="de" && CountRows(cmb_0_FilterStatus.SelectedItems)>0;
'Status (shli_status)' in cmb_0_FilterStatus.SelectedItems.Value;
'Status (shli_status)' in colStatusOrderPool)
;
Deleted = locShowDeleted;
'Created On' >= dt_0_FromDate.SelectedDate
)
;"Kategorie";Category.Name)
;"Verantwortlich";ResponsibleName)
};
If(
locSortColumnPool="0";
SortByColumns(locFilterPool;"shli_orderid";If(locSortOrderPool=SortOrder.Ascending;SortOrder.Ascending;SortOrder.Descending);"shli_orderid";SortOrder.Descending);
locSortColumnPool="1";
SortByColumns(locFilterPool;"shli_customer";If(locSortOrderPool=SortOrder.Ascending;SortOrder.Ascending;SortOrder.Descending);"shli_orderid";SortOrder.Descending);
locSortColumnPool="2";
SortByColumns(locFilterPool;"createdon";If(locSortOrderPool=SortOrder.Ascending;SortOrder.Ascending;SortOrder.Descending);"shli_orderid";SortOrder.Descending);
locSortColumnPool="3";
SortByColumns(locFilterPool;"shli_duedate";If(locSortOrderPool=SortOrder.Ascending;SortOrder.Ascending;SortOrder.Descending);"shli_orderid";SortOrder.Descending);
locSortColumnPool="4";
SortByColumns(locFilterPool;"Verantwortlich";If(locSortOrderPool=SortOrder.Ascending;SortOrder.Ascending;SortOrder.Descending);"shli_orderid";SortOrder.Descending)
;locSortColumnPool="5"
;SortByColumns(locFilterPool;"Kategorie";If(locSortOrderPool=SortOrder.A
Thanks
