Hi All,
I am using the below to filter a Datatable.
With({aFilter: Filter('DN',Startswith('SEARCH REF',PONumIn.Text))},
Filter(aFilter,
If(TogNumDelivery.Value,STATUS="Delivered",true),
If(TogNumPOFilter.Value,'ORDER REF'=POTables.Selected.'ORDER REF',true)
)
)
It is not doing returning any results, any ideas to correct?
Hi @Skybluekid,
I always tend to avoid If() statements as a condition, could you give the following adjustment a try:
With(
{aFilter: Filter('DN',Startswith('SEARCH REF',PONumIn.Text))},
Filter(
aFilter,
!TogNumDelivery.Value || STATUS="Delivered",
!TogNumPOFilter.Value || 'ORDER REF' = POTables.Selected.'ORDER REF'
)
)
If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.
Thanks!