Forum Discussion
Power automate dynamic export
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.
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!1. Having that slicer means nothing by itself. You need to convey that filter context over to the Power Automate visual. In the most simplistic version that means that "Column1" needs to be in the values well of the Power Automate visual. In a more standard setup you would use fields that are required by the flow, and that are filtered by your slicer selection through the data model.
2. You do that by enumerating the values
Thanks for the responce.
1.From what I understood I need to use Column 1 (as a value of Power Automate visual in my report) in the "Apply to each" step, in "Select an output from previous step" filed (Power BI data Column1).
I did that, and now the value under "Current item" in the for loop is {"Column1":"a"} and same for b,c,d. So when writting the filter, I have Table1/column1 eq {"Column1":"a"} (I guess that works like that). How to get only the "a" for equality comparrison?
2. Should I use "entity" somewhere?