Forum Discussion
Power automate dynamic export
- 1 year ago
you need to check the output of the trigger but it's likely something like
item()?['Column1']
Thanks for the responses! As I said, I am trying to filter my report based on the values in the slicer. In the slicer there are 8 values and I need to export power BI report in PDF per every value in the slicer and send it to email. As a first step, i tried to export the report with one (instead of loop for 8 values) specific value selected ( ReportLevelFilter: Table/column eq 'Value'). However, the report which I receive in email is not filtered at all and still returns the report where all values of the slicer are selected. Do you know what may be the reason for that and how to solve it?
(Also when I tried to insert ?filter=<Table>/<column> eq <'Value'> in the URL link of my report, the page wasn't filtered.)
The flow i currently have:
 
As I said, I am trying to filter my report based on the values in the slicer.
But you are not using the "slicer values", you are hard coding "BBB".
To use the "Slicer values" your Power Automate visual in Power BI must be filtered by said slicer. The filtered values are then handed over to Power Automate. Use those values.