Filter Dataverse Table with multiple Or

(0) Share

Report

Posted on by MB29

Hello together,

i have a Tablecontrol in a Canvas App and as the Datasource i am using a Dataverse table.

In the Table i have 3 Textcolumns. Now i want to Filter the table that only records are shown if one or all of the columns are not empty.

I tried

Filter(
'Worker Times',
Or(
!IsBlank(Comments),
!IsBlank(Comments2),
!IsBlank(Comments3)
)
)

but that´s not working. If i use only one Parameter in the Filter, like !IsBlank(Comments), of corse it works.
But i need that it works if one or all of the fields are NOT empty, the record should be included in the result.

thx in adv.

Manfred

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Rajkumar_M 3,741 Super User 2025 Season 2 on at

Like (0)

Report
Hi @MB29

Try this,

Filter('Worker Times', !IsBlank(Comments) || !IsBlank(Comments2) || !IsBlank(Comments3))

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
MB29 67 on at

Like (0)

Report

Hey Rajkumar,

thx for your response, but sadly it does not work either :(.
If i use it i get no results which is very very strange.

and when i use only one !IsBlank i get a result

Was this reply helpful? Yes No