Forum Discussion
Solved
Power automate dynamic export
I have a dashboard with some different visualization for several companies financial data. In the dashboard there is a column where I can choose which companies data to include in the current visuali...
you need to check the output of the trigger but it's likely something like
item()?['Column1']
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?
you need to check the output of the trigger but it's likely something like
item()?['Column1']