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']
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?