Answered

Basic Array Filtering Help

(0) Share

Report

Posted on by Dan_Aspire42

Hello all, I know this has probably been asked many times and I have looked and tested as hard as I can but for some reason this is causing me to rip my hair out.

I am running 2 queries against 2 PowerBI datasets. Both queries output only a list of Client IDs.

I need to check which Client IDs from the first list exist in the second list and build an array of just those ones for the rest of the flow.

Any help is appreciated. Thank you.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

v-yueyun-msft on at

Like (1)

Report
Hi , @Dan_Aspire42

According to your description, you use the "Run a query against dataset" and this action return one column List.

I test it in my side , for example this is the return for the "Run a query against dataset" :

We can use the "Select action" to extract this array to a list:

item()?['fieldName']

Then in the last , if you want to get the intersection of the Client IDs , you can use this code:

intersection(body('Select_2'),body('Select'))

If you contains the duplicate value, you can use the union() function to get the unique ids.

union( intersection(body('Select_2'),body('Select')) ,intersection(body('Select_2'),body('Select')))

If this reply can help you , you can click mark this reply as solution (Accept solution) which can help more people, thanks in advance!

Best Regards,

Yueyun Zhang

Was this reply helpful? Yes No
Dan_Aspire42 31 on at

Like (0)

Report

@v-yueyun-msft

Amazing works perfectly, thank you so much.

Was this reply helpful? Yes No