Filter array

[svivek]

Hi @Hardesh15 

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.

[ekarim2020]

Hi @svivek 

Try using the Select actions in Text mode with the expression item()?['Value'] for both of your Select actions. For example:

This will generate an array of values for the filter array action:

 

Updated:

 

 

Ellis
____________________________________
If I have answered your question, please mark the post as Solved.
If you like my response, please give it a Thumbs Up.