Announcements
I have a problem with a filter
I need to filter only the items that isn't equal to "N/A" I tried with this sentence
Filter(DetalleVisita, Transporte<>"N/A" , Transporte2<>"N/A", 'Estado/Ciudad'<>"N/A")
but i have a warning delagation
@Anonymous
You cannot delegate the not operator! If your datasource is over 2000 records, then delegation will be something you need and you'll either need to consider a prefilter of your data or an alternate method.
I hope this is helpful for you.
My datasource only have 400 records
how can I do a prefilter?
Thanks
If you only have 400 records, then you can ignore the delegation warning.
As long as your record limit in the app is greater than the number of records you have in that list, you will be fine.
Even If i ignore the warnig the gallery doesn't show items that filter search
Any idea what i do?
Thanks for your reply
That is a different issue than delegation.
What are you expecting to see in your Gallery?
According to your formula:
ALL three columns (Transporte, Transporte2, and 'Estado/Ciudad') will all need to NOT be N/A in order to show up in your list.
Is that what you are looking for? Nothing should be "N/A"?
For example
I have columns "Transporte" "Transporte2" "estado/ciudad" if all of them have "N/A" that item i don't need to see but if one of 3 columns is different to "N/A" i need to see
Then your formula should be:
Filter(DetalleVisita, Transporte<>"N/A" || Transporte2<>"N/A" || 'Estado/Ciudad'<>"N/A")
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Valantis 392
WarrenBelz 364 Most Valuable Professional
Kalathiya 271 Super User 2026 Season 1
