Answered

Filter a values within one array which contains values from another array

(0) Share

Report

Posted on by MPlo

Hello, I have 2 arrays and I need to filter the values within one array (let's call it Array1) which contains values from another array (let's call this one Array2). The first one (column) I take from sharepoint : List Rows + Select and the second one I have stored in variable.

Example:

Array1: helping, source, never, power, automate, keyboard

Array2: help, brb, auto, sou

So the output will look like: helping, source, automate.

I tried to to use Filter array but I do something wrong. Could you please advise?

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @MPlo ,

My SharePoint List:

My Flow:

item() items('Apply_to_each')

If you still have problem, please post a screenshot of your complete flow configuration.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
MPlo 10 on at

Like (0)

Report
Copy link

Link copied!

Great, thanks a lot, I did struggle with right parameters in filter arrays step. So the output now is the array within an Apply to each.
How do I get the values out of this loop and get the array (or string) of matching values?

Was this reply helpful? Yes No
Verified answer

v-yetonggu-msft Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
Hi @MPlo ,

Please reference this test.

Add another variable named test, and apply to each 'Filter_array' body.

Then using 'item()' expression to Append to array variable.

item()

Jump out of the two loops and add the compose control, put the test variable in, run the flow, check the output of compose, and you can get the value of the test variable.

Best Regards,

Sunshine Gu

Was this reply helpful? Yes No
MPlo 10 on at

Like (0)

Report
Copy link

Link copied!

many thanks for your solution !

Was this reply helpful? Yes No