Search array values

(0) Share

Report

Posted on by Community Power Pla...

I looking for help with Power Apps

I have collection

ClearCollect(lstIds ,{ code :"11" ,"22" , "33"});
I need to search for specific value in the collection

Filter(varRecord , varRecord.column not in lstIds.code|); //

May be there exists another way to search for a value of column not in the collection lstIds

Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

eka24 20,923 on at

Like (1)

Report

Try:
ClearCollect(lstIds, { code: "11"}, { code: "22" },{ code: "33" },{ code: "44" })
Or
ClearCollect(lstIds, { code: 11}, { code: 22 },{ code: 33 },{ code: 44 })

Then filter as:
Filter(varRecord,Not(code in lstIds. code))
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you very much !:)
No,it doesn't work

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Can you show how you got varRecord or the Table used
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Sorry that in image .I have problem with keyboard suddenly

image002.png

image003.png

image001.png

Was this reply helpful? Yes No
DevendraSingh 144 on at

Like (0)

Report

Hello,
Your collection should be
ClearCollect(lstIds,{code:"11"},{code:"22"},{code:"33"},{code:"44"});
I don't know the type of the "varRecord" object, so I am assuming that either it is a collection or a variable.
If "varRecord" is a collection, i.e. ClearCollect(varRecord,{code:"77"},{code:"22"},{code:"33"},{code:"44"});, then write the below formula,
Filter(varRecord,Not(code in lstIds.code))
If "varRecord" is a variable, i.e. Set(varRecord,77), then write the below formula,
Filter(lstIds, code<>varRecord)

Please click Accept as Solution, if this solution solved your issue.

Thanks & Regards,
Devendra Singh

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

It doesn't accept not first and not second version 😞

Was this reply helpful? Yes No
eka24 20,923 on at

Like (0)

Report

Am confused because the collection and the variable does not have anything in common from your attached.

The variable you have created being compared using in function to search for in the collection containing numbers cannot work.
------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

Was this reply helpful? Yes No
Verified answer

v-siky-msft on at

Like (0)

Report
Hi @Anonymous ,

You need to use ForAll function to loop through the varSubject4Id to check whether each value is in lstIds.code, if not, then, save the value to a new collection.

Please try this:

Clear(Col1);ForAll(varRecord,If(Not(ColumnName in lstIds.code),Collect(Col1,{Value:ColumnName})))

Then the Col1 collection is the filtered collection that the value of column is not in the collection lstIds.

Hope this helps.

Sik

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thank you very much for your replay !:)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

thank you very very much ! It works !!!!!!!!!!!!!!!!! :):):)

Was this reply helpful? Yes No