New
Filter(
SendDataFiltered,
(
IsBlank(ComboSending.Selected.Value) && IsBlank(ComboReceiving.Selected.Value)
) ||
(
!IsBlank(ComboSending.Selected.Value) && IsBlank(ComboReceiving.Selected.Value) &&
'What is the sending account?' = ComboSending.Selected.Value
) ||
(
IsBlank(ComboSending.Selected.Value) && !IsBlank(ComboReceiving.Selected.Value) &&
'What is the receiving account?' = ComboReceiving.Selected.Value
) ||
(
!IsBlank(ComboSending.Selected.Value) && !IsBlank(ComboReceiving.Selected.Value) &&
'What is the sending account?' = ComboSending.Selected.Value &&
'What is the receiving account?' = ComboReceiving.Selected.Value
)
)
--------
Filter(
SendDataFiltered,
// CASE 1: Both are empty – show all records (default gallery)
(IsBlank(ComboSending.Selected.Value) && IsBlank(ComboReceiving.Selected.Value)) ||
// CASE 2: Only ComboSending selected
(!IsBlank(ComboSending.Selected.Value) && IsBlank(ComboReceiving.Selected.Value) &&
'What is the sending account?' = ComboSending.Selected.Value) ||
// CASE 3: Only ComboReceiving selected
(IsBlank(ComboSending.Selected.Value) && !IsBlank(ComboReceiving.Selected.Value) &&
'What is the receiving account?' = ComboReceiving.Selected.Value) ||
// CASE 4: Both selected – show common records
(!IsBlank(ComboSending.Selected.Value) && !IsBlank(ComboReceiving.Selected.Value) &&
'What is the sending account?' = ComboSending.Selected.Value &&
'What is the receiving account?' = ComboReceiving.Selected.Value)
)
Comments
Post a Comment