Answered

Is not in array

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I now know you can check if something is in an array or collection by using If(item in otherItem, true) but is there a way to do the opposite like If(item notIn otherItem, true)?
Or even better how would i check if collection items are not it Gallery Items or item array

Categories:

Building Power Apps

I have the same question (0)

All responses (9)

Answers (1)

eka24 20,923 on at

Like (1)

Report
Copy link

Link copied!

You use Not for the Opposite
Example:
Filter(Table1,Not(ColumName in Table2.ColumnName))
------------

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
JayMagness 1,663 on at

Like (1)

Report
Copy link

Link copied!

Hi,

You are on the correct path need to say something like if it is not equal to that.

Remember this is all formulas like Excel Formulas.

If you want we can get on a teams session just email me at Jay@research-nest.com

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

Like (0)

Report
Copy link

Link copied!
Almost
I have two variables ItemsArrayA, ["itemOne","itemTwo","ItemThree","ItemFour"] and ItemArrayB, ["itemOne","itemTwo"] and i want to return that ItemThreee and ItemFour are missing to ItemArrayC, ["ItemThreee ","ItemFour "].
Maybe like something kinda like this idk.

Set(ItemArrayC,If(ItemArrayB.value notin ItemArrayA,ItemArrayB.value))

or instead of Set use Collect

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

Like (0)

Report
Copy link

Link copied!
or how about something more like this???

Concat(ItemArrayB,If(Value NotIn ItemArrayA, Collect(ItemArrayC,Value)))

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

Like (0)

Report
Copy link

Link copied!
This doesn't work either
Concat(ItemArrayA - ItemArrayB,Value)

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

Like (0)

Report
Copy link

Link copied!
I tried
Collect(ItemArrayC, Filter(ItemArrayA,Not(ItemArrayB in ItemArrayA)))
I doesn't work

Was this reply helpful? Yes No
Verified answer

eka24 20,923 on at

Like (2)

Report
Copy link

Link copied!

Have tested the following
Assuming the variables are:
Set(temsArrayA,["itemOne","itemTwo","ItemThree","ItemFour"]);
Set(temsArrayB,["itemOne","itemTwo"])

Filter as:
Filter(temsArrayA,Not(Value in temsArrayB.Value))

------------

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... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Almost got it with this
Collect(ItemArrayC,If(Concat(ItemArrayB,Value) in ItemArrayB,Concat(ItemArrayB,Value&" ")))

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

Like (0)

Report
Copy link

Link copied!

yep, that did it, thanks.

Was this reply helpful? Yes No