cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
fgonzalez515
Helper IV
Helper IV

FILTER ARRAY EXCEPT

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

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
fgonzalez515
Helper IV
Helper IV
5 REPLIES 5
v-peijunz-msft
Microsoft
Microsoft

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

fgonzalez515
Helper IV
Helper IV

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.

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

 

fgonzalez515_0-1658879121619.png

 

fgonzalez515
Helper IV
Helper IV

Any other option?

fgonzalez515
Helper IV
Helper IV

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Users online (2,188)