Announcements
Hi All,
I am using Filter Function in PowerApps gallery item. Suppose Column_3 is a choice column having 4 values as a,b,c,d.Filter(Data_Source, (Column_name1=a) && (Column_name2=c) && (Column_name3 <>b))But Column_name3 <> is giving me delegation warning. So I can not go for that option.can anyone please suggest me how can I use not equal to without delegation warning.Thanks in advance.
<> is always going to return delegation warning.
If it is only the 4 options (a, b, c and d) then do this:
&& (Column_name3 = a) || (Column_name3 = c) || (Column_name3 = d)So your formula would be:Filter(Data_Source, (Column_name1="a") && (Column_name2="c") && ((Column_name3 = "a") || (Column_name3 = "c") || (Column_name3 = "d")))
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
LinkedIn: https://www.linkedin.com/in/charlie-phipps-%F0%9F%91%A8%E2%80%8D%F0%9F%92%BB-91338715b/YouTube: https://www.youtube.com/channel/UChmFBGU1YKIU91sNMQ7buGgTwitter: https://twitter.com/phipps0218
Hi @Harpreet_Tohra
Rather than using (Column_name3 <>b) condition for not equal to "b", you can use (Column_name3 = "a") || (Column_name3 = "c") || (Column_name3 = "d")
Full filter condition would be :
Filter(Data_Source, (Column_name1="a") && (Column_name2="c") && ((Column_name3 = "a") || (Column_name3 = "c") || (Column_name3 = "d")))
Try with this one.. and
please accept this solution if it works for you
@divanshu . I have tried. It worked for me. Thank you.
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.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 536
WarrenBelz 426 Most Valuable Professional
Haque 305
