If(
locFilterBlankReceiptDate,
UpdateContext({locFilterBlankReceiptDate: false}),
UpdateContext({locFilterBlankReceiptDate: true})
);
If(
locFilterStatusInProgress,
UpdateContext({locFilterStatusInProgress: false}),
UpdateContext({locFilterStatusInProgress: true})
);
SortByColumns (
Filter (
'SharePoinListName',
Or(
!locFilterBlankReceiptDate,
'Receipt Date' = Blank()
),
Or(
!locFilterStatusInProgress,
Status = "In Progress"
)
),
"Modified",
SortOrder.Descending
)
UpdateContext(
{
locFilterBlankReceiptDate: false,
locFilterStatusInProgress: false,
. . . . . .
}
)
With(
{
_Data:
SortByColumns(
Filter(
'SharePoinListName
Or(
!locFilterBlankReceiptDate,
'Receipt Date' = Blank()
),
Or(
!locFilterStatusInProgress,
Status = "In Progress"
)
),
"Modified",
SortOrder.Descending
)
},
Search(
_Data,
TextInput1.Text,
YourFieldToSearch
)
)
UpdateContext({locFilterBlankReceiptDate: !locFilterBlankReceiptDate})
UpdateContext({varClear: true})
SortByColumns(
Filter(
'SharePoinListName
!varClear,
Or(
!locFilterBlankReceiptDate,
'Receipt Date' = Blank()
),
Or(
!locFilterStatusInProgress,
Status = "In Progress"
)
),
"Modified",
SortOrder.Descending
)
UpdateContext({varClear: false})