Filter only dosnt not equal value in Dropdown with collection

(1) Share

Report

Posted on by Jawaharprem

255

Hi All,

i need to filter data in Assign <> "Assigned"

i used this code but showing error -

"ClearCollect(colGridData,Tracker,Filter(Tracker, Assign <> "Assigned")"
 

Categories:

Building Power Apps

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Nandit 1,568 Moderator on at

Like (2)

Report
Hi Jawaharprem,

Looks like you forgot to close the ClearCollect bracket at the end.

Try using this:

ClearCollect(colGridData,Tracker,Filter(Tracker, Assign <> "Assigned"))

If this doesn't work, can you tell me what type of column Assign is?

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
Jawaharprem 255 on at

Like (2)

Report

Hi Nandit,

its not working and the Assign is choice column..

Thanks

Jawahar Prem

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (2)

Report

That is a Delegation warning, not an error - the Not operator (you are using <>) is not Delegable

Was this reply helpful? Yes No
Suggested answer

Nandit 1,568 Moderator on at

Like (2)

Report
Hi Jawaharprem,

You can use the following to defeat delegation:

ClearCollect(colGridData,Tracker, Filter( AddColumns( Tracker As Data, Validation, If( "Assigned" in Concat( Data.Assign, Value, "," ), "0", "1" ) ), "1" in Validation ))

Hope this helps.

Kind regards,

Nandit

If this answers your query, please mark this response as the answer.
If its helpful, please leave a like. Thanks!

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (2)

Report
Unfortunately AddColumns is "local" function and the amount of records it can address it limited to your Data Row Limit, so all it does is "mask" the issue. If you want a Delegable filter, then you need to list out all the possible values other than Assigned
ClearCollect( colGridData,Tracker, Filter( Tracker, Assign = "Not Assigned" || Assign = Blank() ) )

Was this reply helpful? Yes No
Jawaharprem 255 on at

Like (2)

Report

Hi WarenBelz,

Thanks for your time provided code is getting some error as mentioned below

ClearCollect(

colGridData,Tracker,

Filter(

Validation,

Assign = "Not Assigned" || Assign = "blank"

)

)

the function "Filter" has some invalid arguments
name isn't valid, 'Validation, isn;t recozized
name isn't valid, 'Assign' isn;t recozized

Was this reply helpful? Yes No
Jawaharprem 255 on at

Like (1)

Report

Hi Nandit,

thanks for your time, provided code is getting on concat as mentioned..

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (2)

Report

Please see updated code

Was this reply helpful? Yes No
Jawaharprem 255 on at

Like (2)

Report

Hi All,

this code without any delegation warnings..

ClearCollect(colGridData, Filter(CMD_NA_Tracker,Or(Assign.Value="Not Assigned", Assign.value="blank")))

Was this reply helpful? Yes No
WarrenBelz 153,026 Most Valuable Professional on at

Like (2)

Report
Is "blank"one of the options ? If you are looking for a blank field, you need Blank(). Other than that
ClearCollect( colGridData, Filter( CMD_NA_Tracker, Or( Assign.Value = "Not Assigned", Assign.Value = "blank" ) ) )

is the same as I posted (|| means Or) except you now have a different list name. It is certainly Delegable, but bear in mind that the number of records you can collect after the filter is still limited to your Data Row Limit.

Was this reply helpful? Yes No