Power Platform Community Forum Thread Details

I have 2 filters on a report, Distributor number and company number. Each handle a few views on the report. I need to build a power bi to PDF export that checks if both filters equal each other, only those results should be exported. Before this, I had the export working when there was only 1 filter, but now with the second filter, I'm having trouble. So far, I've gotten the report to export, but it's not actually applying the filter to the report.

So what I need is that, for Each Distributor, I need to match the Company, so both filters have the same value. I would like to do this on the data end, but because they come from 2 different sources, I don't really have a way to join the tables so that's why we're needing to have 2 filters, otherwise the best thing would've been to just join the data, have 1 filter and we're good.

I tried applying a condition where the Distributor = Company, but that doesn't work. It runs through the list of distributors and the workflow would just end, and it doesn't export anything. I tried that both as a Control Condition and Filter Array, neither worked.

This post here is pretty much what I need, but I need it to export it to pdf and loop through all the Distributor numbers.

Below is a screenshot of my flow:

What I'm doing here is putting both Distributor and Company and passing it as an array, looping through for each Distributor number. And then in my Power BI report level filter I'm putting in the table name and column name (which is the Distributor filter) has to equal each Company name, and based on that filter out the report. It exports for each distributor, but the filter isn't actually applying and the PDF's come out all the same. Any help on this would be greatly appreciated!!

Categories:

General topics