Unanswered

Filter Array

(0) Share

Report

Posted on by meskerkj

Hello,

I am designing a flow which will pull a lit of items from a Power BI report and another list of items from an Excel spreadsheet. I want to filter out those items that are common to both lists and take one action with the items unique to the Power BI list, and another action with the items unique to the Excel list.

I have set up the flow to send me HTML tables of the lists so I know it is pulling the correct list from Power BI and the correct list from Excel. But in the filter array step I have it filtering 'SelectPBIArray' where 'SelectPBIArray' does not contain 'SelectExcelArray' and it is outputting the complete Power BI list from that step, even though there are entries that should be eliminated. I have tried but have been unable to get it to filter correctly.

Have I missed a step? Or is there a better way to get the unique items from each list?

Thanks!

Categories:

General topics

All responses (2)

Answers (0)

Sort by

CDTaal 7 on at

Like
a
(0)

Report
Copy link

Link copied!

Have you tried to store the output in seperate variables and compare those (instead of directly calling the output)? I can see you initialize 2 variables but you seem to still use the output of the SelectArray function for the filter?
First pull one list, store it, then pull the other and store it. Last, you compare the variables instead of the lists itself. That worked for me in similar problems, hope it works for you as well. I can not really explain it, other than that sometimes output of 2 similar functions overwrites.
meskerkj 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, I tried putting the lists in variables and making the variable type "Array" but it still won't filter, it gives me back the full list as before.