Forum Discussion
Power automate dynamic export
you need to check the output of the trigger but it's likely something like
item()?['Column1']
Yeah, I provide that filter
"filter": { "table": "Name", "column": "companies", "operator": "eq", "value": "current loop value" }. Doesn't help. How do I ensure that column controls data model?
you cannot use eq for lists of values. use in
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.
So then I have two further questions:
1) I have a slicer with 8 possible values. Do you say that it is not possible to just get the names of those 8 values, initialize a variable with those 8 names as an array and loop through the array, checking the fact that table/column value equals to the current name in a loop, right? (So in example, if I have the column with a, b, c, d, "select all" options and i need to have 4 reports with visualiztions per each one (exluding select all), it is not enough to create an array ["a", "b","c", "d"] as value and loop through it?)
2) Do you imply that i have to somehow pass the reference to that slicer (or smth like that) to the loop and make it run through actual column? How do I do that for table "Table1"and column "Column1"?
Thank you!