cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Resident Rockstar
Resident Rockstar

Join two Arrays in Flow

I am trying to an equivalent of a LEFT OUTER JOIN between two tables in a flow.  As my data shows, I have two tables.  The ListFromPA_Array is a short list of "ProductID"s that I need to get the "Description" from the power query table, which is many thousand lines long.  

 

I need a resulting table that contains all of the "ProductID"s, with "Description" with it.

 

I'm sure this can be done.  Help?

 

Thank you.

 

image.png

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Solution Sage
Solution Sage

Hi @martinav ,

 I have made a test on my side, please take a try with the following workaround:

First I suggest you append the ID value into array.

Then use the contains function in the Filter array action to filter the items you want.

The expression in 'Append to array variable' is: 

items('Apply_to_each')?['ID']

Capture1.PNGCapture2.PNG

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Highlighted
Resident Rockstar
Resident Rockstar

It appears that the expression intersect() fundamentally would work but...

 

I want an intersection of the first column ('ProductID'), and contains both columns of the power query.

 

How to write the expression???

 

My guess, which of course does not work...  It would be far too easy if it did.

 

intersection(body('Transform_data_using_Power_Query')?['value'],variables('ListFromPA_Array'))

 

Highlighted
Solution Sage
Solution Sage

Hi @martinav ,

 I have made a test on my side, please take a try with the following workaround:

First I suggest you append the ID value into array.

Then use the contains function in the Filter array action to filter the items you want.

The expression in 'Append to array variable' is: 

items('Apply_to_each')?['ID']

Capture1.PNGCapture2.PNG

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted
New Member

You can also use Union

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Kudoed Authors
Users online (8,151)