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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Comparing 2 list - sel...
Power Automate
Answered

Comparing 2 list - select as long as have same value

(1) ShareShare
ReportReport
Posted on by 353

hi all.

I am comparing 2 same columns called "To/From" from 2 different lists. 

1. Get all items from sp list 1 

2. get all items from sp list 2

3. if there are at least 1 same value, then new variable will be applied according to conditionif there are at least 1 same value, then new variable will be applied according to condition

 

the problem is, the flow search for all, therefore the variables become a lot, not once. let's say 1st item. this is the example of the output. 

AB is a redundancy in prior transactions. AB is a redundancy in prior transactions.AB is not a prior transaction - frequency, redundancy, value. 

 

Supposedly, the answer is  "AB is a redundancy in prior transactions" since there are 2 redundants here. 

 

can anyone help?

 
Categories:
I have the same question (0)
  • Verified answer
    efialttes Profile Picture
    14,756 on at

    Hi

    FRom the screenshot you shared, not sure I understood your flow design.

    In order to compare items from 2 lists, I think you need two Apply to Each (one inside another) or a Filter Array inside an Apply to Each.

    Did you designed your flow following any of these scenarios?

     

    Also, not sure I understand your goal: currently once you find a match betweek both lists, you store the matching item in an string variable. But if the current comparation do not match, you also store the item with a different associated text.

     

    I assume your goal is:

    -if you find a match between current item from List#1 and all items from List#2, store the result just once

    -if you do not fnid a match between current item from List#1 and all items from List#2, store the result just once.

     

    Is my assumption correct? If so, I would try the following approach

    Flow_MatchTables.png

     

    Hope this helps

     

     

     

  • _kikilalaaa Profile Picture
    353 on at

    yes @efialttes, this is what I'm looking for! thank you for your help! have a nice day~

  • efialttes Profile Picture
    14,756 on at

    Wow!

    It works!

    Glad to see challenge is solved @_kikilalaaa . And thank you for taking the time to mark the topic as solved, since this way other community members facing a similar issue can find a solution faster.

    You guys make this comunity great!

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard