Unanswered

Filter Array not filtering two select arrays

(0) Share

Report

Posted on by jsangerman

I'm trying to compare values from a Power BI query with those from a SharePoint list, finding those in the SP list that aren't in the query. I have a select query on the output of each, then using Filter Array to compare the output of the two select actions.

Here are the two input arrays:

However, the result still includes all items in the Select - SP Finance Projects output (200+ rows).

On the other hand, when I use a small test flow, I get the results I expect.

They appear to be exactly the same, so why does the test work but the complete one not work?

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

lbendlin 8,479 Super User 2025 Season 2 on at

Like (1)

Report

Change your DAX query to already produce the exact outcome you want to compare with. No need to parse JSON.

Make sure your comparison is like for like - same field names, or no field names.

Was this reply helpful? Yes No
jsangerman 52 on at

Like (0)

Report

Ahh, getting rid of the parse is an obvious improvement. Thank you for that. However, the issue is still here.

You can see in the original post that the two arrays are identical (there is a single value at the bottom of the 250+ values in the SP list). Since I'm using NOT(CONTAINS(..., the result should only include values in the second (SP) list that are not in the first (the one from Power BI). Instead, I'm just getting the original list (SP), as if no comparison is being made.

Here is the copied output from the Select - SP Finance Projects action:

[
1,
2,
3,
...
277,
99999,
278,
279
]

And here's the output from the Select - Finance Master List action:

[
1,
2,
3,

...
277,
278,
279
]

Column names aren't an issue here, the direct input shouldn't be an issue. I have two arrays that are nearly identical, but the filter action isn't working the way it does in my simpler flow.

Was this reply helpful? Yes No