Answered

FILTER function: what operators to use with text fields

(0) Share

Report

Posted on by WillBeeSea

Data is in Dataverse:

In a Gallery, I am trying to write a simple FILTER() expression that specifies certain data. I am able to specify:
"Probability" (a number field), and
Private (a Yes/No field)
...but I am having trouble filtering for a filter for Classroom, which is a TEXT field:
Classroom = "ON",
The "=" symbol gets a red squiggle, showing it is not accepted/recognized.
I have tried "eq" instead of the equals symbol but with the same result.
I (rather randomly) tried "is" and several similar variations, with no luck.
QUESTION: what is the syntax for specifying particular text in a text field for a FILTER expression?
See the third line below. The expression works fine without this Classroom bit added.

(I tried to attach an image to show the red squiggle, but this page would not accept it.)

Filter('Class Events', SearchInputBox.Text in 'Event Description',
'Instructor Remote (Class Events)'.No,
Probability > 0 , Classroom = "ON",
'Private (Class Events)'.Yes,
'Start Date' > DateAdd(Today(),-30,TimeUnit.Days),
'Start Date' < DateAdd(Today(),90,TimeUnit.Days))

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

SaiRT14 1,990 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

the issue seems to be with the Classroom field, which is a Text field. - Classroom = "ON"

here is the complete filter block

Filter(
'Class Events',
SearchInputBox.Text in 'Event Description',
'Instructor Remote (Class Events)'.No,
Probability > 0,
Classroom = "ON",
'Private (Class Events)'.Yes,
'Start Date' > DateAdd(Today(), -30, TimeUnit.Days),
'Start Date' < DateAdd(Today(), 90, TimeUnit.Days)
)

Was this reply helpful? Yes No
WillBeeSea 55 on at

Like (0)

Report
Copy link

Link copied!

Hi SaiRT14,
The Classroom field is just a text field, with a variety of classroom names in it. How to I specify a particular classroom?

Was this reply helpful? Yes No
Verified answer

WillBeeSea 55 on at

Like (0)

Report
Copy link

Link copied!

OH! For anyone else who might have this question, here is the answer:

It turns out that the Classroom field in Class Events was a Lookup field, so "ON" was not in that table. I needed to follow the Lookup/relationship to the source table by doing the following:

Classroom.Name="ON",

Classroom is the source table and Name is the actual column with the names of classrooms.

Was this reply helpful? Yes No