I have a Gallery that will display Appointments to select from. The issue is, within the Appointment Entity, we also have a number of automated appointments that should not be visible to users to select.
I have tried using Filter(Appointments, Not(IsMatch(subject, "PAW")))
But i get the error that the expression can't be evaluated remotely.
I do not know how else to write the statement so any help would be great.