Filter array

(0) Share

Report

Posted on by svivek

Hi All,

I am having following use case:

I have to compare value 2A (value 1000) with 1A (value 1000) and value 2B (value 80) with 1B (value 40)

Finally I have to filter out values which are not matching (incorrect items) in row 2 with respect to row 1.

Hence as per above table I should get final result as : 80 (which is not matching with row 1B). But the filter array should not display 1000 as the value in column 2 is matching with value in column 1.

For this I have created below flow.

But in final result I am getting both values 1000 (which is matching with row 1) and 80 (which is not matching with row 1).

How to get final filtered value as 80 only. Pls help, don't know where am I going wrong.

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (1)

Expiscornovus 33,474 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Hi @svivek,

Just to double check. In your configuration you are using the below?

From:

body('Select2')

Criteria:

body('Select2')

is not equal to

body('Select')

And in your Select actions you are using:

item()?['Value']

Was this reply helpful? Yes No
svivek 65 on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus
Yes I am using exactly the same set of expressions as mentioned by you Pls refer below screenshot I have added all expressions as Notes for easy visibility. But still I am unable t get the desired output.

Was this reply helpful? Yes No
Verified answer

Expiscornovus 33,474 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
Hi @svivek,

Ok, thanks for double checking/validating.

Could you try a slightly different approach. In both Select actions switch to text mode and use the item()?['Value'] without a Key.

In the Filter Array use

body('Select')

does not contain

item()

Was this reply helpful? Yes No
svivek 65 on at

Like (0)

Report
Copy link

Link copied!

Hi @Expiscornovus
Thanks for solving above problem. However in continuation to same flow I an unable to create a table to show the user no match value along with corresponding parameter (pls refer below screenshot for details). Pls let me know if that is possible to do.

Was this reply helpful? Yes No