Answered

Filter not equal to giving delegation issue

(0) Share

Report

Posted on by Harpreet_Tohra

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (2)

Verified answer

MVP-Phipps 3,508 Super User 2024 Season 1 on at

Like (1)

Report

<> 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/UChmFBGU1YKIU91sNMQ7buGg
Twitter: https://twitter.com/phipps0218

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

divanshu 25 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Harpreet_Tohra 71 on at

Like (0)

Report

@divanshu . I have tried. It worked for me. Thank you.

Was this reply helpful? Yes No