Forum Discussion
Power automate dynamic export
you need to check the output of the trigger but it's likely something like
item()?['Column1']
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!