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

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 V
Helper V
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 V
Helper V

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 V
Helper V

Any other option?

fgonzalez515
Helper V
Helper V

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,899)