Notifications
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
WarrenBelz 739 Most Valuable Professional
Michael E. Gernaey 343 Super User 2025 Season 2
Power Platform 1919 268
