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
