Answered

How to only return values where string isn't available in a column

(0) Share

Report

Posted on by Community Power Pla...

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.

Thanks in advance

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (2)

Verified answer

Oleks 83 on at

Like (1)

Report
As far as I understand it correctly, it's not an error, this suggestion that formula contains something that cannot be delegated.
If you have SQL Server data source, try to use:
Filter(Appointments, Not("PAW" in subject))
If you have other data source, there is no way to solve this with delegation supporting.

Look at this article about delegation:
https://powerapps.microsoft.com/en-us/tutorials/delegation-list/

Was this reply helpful? Yes No
Verified answer

v-micsh-msft on at

Like (0)

Report

Hi @Anonymous,

Just as told by @Oleks, this is related to delegation.

Check more details about delegation in the following article:

Understand delegation

Tired with the solution provided, it would work under Dynamics 365 appointments entity, no remidnings for the delegation.

Regards,

Michael

Was this reply helpful? Yes No