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 Platform Community / Forums / Power Automate / Filter Array with Cont...
Power Automate
Answered

Filter Array with Contents of Other Array - 2 SPO Lists

(0) ShareShare
ReportReport
Posted on by 2,987 Moderator

Hi Everyone

 

Hoping for assistance with this.

 

I have SPO List 1 and SPO List 2 - I have a checklist based App, which uses the items in SPO List 1 to build up the items in SPO List 2. Once all the items are in List 2, the process is complete for that user.

 

What I want to do, is report on interim progress for a given user to report on items outstanding.

 

I have built a flow and tried to get the items outstanding by filtering List 1 based on Titles (common to both lists) that are not yet in list 2. The following snippet shows my effort:

 

List 1 = Get items-TemplateList

List 2 = Get Items

Filter array input 'value' = List 1 Array 

 

AmDev_1-1637842136389.png

 

 

This doesn't seem to be filtering at all and just outputs the entire array - I'm probably missing something really obvious, but would welcome any help.

 

Many thanks

 

Categories:
I have the same question (0)
  • Verified answer
    mahoneypat Profile Picture
    1,720 on at

    Please see the approach in this post for one way to do this.  Basically you use a select to make an array of the Title values (no column header) and Filter your other array for where that Titles array does (or does not) include the current item.  The note on each step has the expression needed.

    Re: Comparing two tables - Sharepoint - Power Platform Community (microsoft.com)

     

    Pat

     

  • Gerard Simpson Profile Picture
    2,987 Moderator on at

    Hi @mahoneypat 

     

    Many thanks, that worked a treat. Legend!

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
Haque Profile Picture

Haque 58

#2
David_MA Profile Picture

David_MA 53 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 36 Most Valuable Professional

Last 30 days Overall leaderboard