Filter array based on another array

Question

I have this array which contain a list of MediumID integers:-

And then i am getting some items from sharepoint, then i want to filter the sharepoint items with only the the one that have their MediumID inside the list of integers:-

I tried to use intersection length(intersection(outputs('Select-MediaIDs'), createArray(item()?['MediumID']))), but i got invalid query.. any advice?

I also tried to use "is equal to",, to compare Int to array of integers(hoping it will work),, but it did not:-

Create a comma separated string with the ID’s and the use a contains over the SharePoint list. There are better ways but you’d need to use a third party connector. The advanced data operations connector does it using the join operation in one step. — Skin
– Skin, Commented Nov 12 at 11:40
Update your question with the two sets of sample data and if I find the time I will. — Skin
– Skin, Commented Nov 12 at 19:03
@SamNseir contain work with string not with array of strings — John John
– John John, Commented Nov 13 at 16:18

Sam Nseir · Accepted Answer · 2025-11-13 17:02:28Z

0

See the contains function:

Specifically, this function works on these collection types:

A string to find a substring

An array to find a value

A dictionary to find a key

So for example, in your Filter Array action, you could have:

// left
contains( outputs('Select-MediaIDs'), item()?['MediumID'] )

// middle
is equal to

// right
true() // add as expression, not string

answered Nov 13 at 17:02

Sam Nseir

13.1k2 gold badges5 silver badges21 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Filter array based on another array

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related