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 community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 350 Super User 2026 Season 2
M Bilal Khan 318
Mohsin Ali 220
