web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Automate
Answered

Filter array

(0) ShareShare
ReportReport
Posted on by 65

Hi All,

 

I am having following use case:

svivek_0-1658127757530.png

 

 

 

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.

svivek_1-1658127757875.png

 

 

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.

 

svivek_2-1658127757687.png

 

 

Categories:
I have the same question (0)
  • Expiscornovus Profile Picture
    33,768 Most Valuable Professional on at

    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')

     

    bodyoutputselect2.pngbodyoutputselect.png

     

    And in your Select actions you are using:

    item()?['Value']

     

  • svivek Profile Picture
    65 on at

    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.

    svivek_0-1658138275945.png

     

  • Verified answer
    Expiscornovus Profile Picture
    33,768 Most Valuable Professional on at

    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()

     

    doesnotcontain.png

  • svivek Profile Picture
    65 on at

    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.

    svivek_0-1658150129147.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 262 Super User 2026 Season 1

#2
Haque Profile Picture

Haque 227

#3
Expiscornovus Profile Picture

Expiscornovus 225 Most Valuable Professional

Last 30 days Overall leaderboard