Filtering a Data

(0) Share

Report

Posted on by Skybluekid

254

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?

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

LaurensM 12,516 Moderator on at

Like (0)

Report
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!

Was this reply helpful? Yes No
Skybluekid 254 on at

Like (0)

Report

HI @LaurensM

Thank you for the reply, I have managed to solve the issue.

Was this reply helpful? Yes No