Skip to main content

Notifications

Power Automate - Building Flows
Answered

FILTER ARRAY EXCEPT

(0) ShareShare
ReportReport
Posted on by 288

Hello Community,


I have two tables "DTE" and "BCO". I want to get the "Table Except"
Use the concept of Except using Filter Array. I concatenate the items of each column of each table, but I can't get the expected result. Is the flow I made ok?

 

It is an example or test table

fgonzalez515_0-1658551328920.png

 

My Flow

fgonzalez515_1-1658551398620.png

 

 

  • Verified answer
    fgonzalez515 Profile Picture
    fgonzalez515 288 on at
  • fgonzalez515 Profile Picture
    fgonzalez515 288 on at
    Re: FILTER ARRAY EXCEPT

    Any other option?

  • fgonzalez515 Profile Picture
    fgonzalez515 288 on at
    Re: FILTER ARRAY EXCEPT

    Any other option?
    Due to the number of items, the Flow has been running for more than 4 hours

     

    fgonzalez515_0-1658879121619.png

     

  • fgonzalez515 Profile Picture
    fgonzalez515 288 on at
    Re: FILTER ARRAY EXCEPT

    Hi @v-peijunz-msft,

     

    Thanks for you information.

    Is there any other way to make the flow run faster?
    The number of items to review is more than 10,000.

  • Re: FILTER ARRAY EXCEPT

    Hi @fgonzalez515,

     

    Based on your description, I have made a simple test for your reference.

    1. I have a Excel file called FilterArray, it stores three tables (Table1, Table2, and Table3).

    vpeijunzmsft_0-1658826188005.png

    2. Here is my flow:

    @and(equals(item()?['Rut'], items('Apply_to_each')?['Rut']),equals(item()?['CR Luciano'], items('Apply_to_each')?['Obra']))
    length(body('Filter_array'))

    vpeijunzmsft_1-1658826188009.png

    vpeijunzmsft_2-1658826188013.png

    vpeijunzmsft_3-1658826188018.png

    3. Result screenshot:

    vpeijunzmsft_4-1658826188020.png

     

    Best regards,

    Sylvia

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,343

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,703

Leaderboard