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))