Forum Discussion
Query run on Power Automate brings back null for the Selected Value
I have added a new measure, Selected Zone (Selected Zone = SELECTEDVALUE('Table'[Zone])) and Selected Date (Selected Date = SELECTEDVALUE('Table'[Date])). This is the value selected from the slicer ...
How should I connect my slicer (selected option) with the actual filters on Power Automate?
lbendlin
Super User
Super UserYou cannot do that when you "run a query" unless that flow gets input from Power BI via the Power Automate visual - which would need to be subjected to the filter context dictated by the slicer.
Could you please explain it more along with an example/use case
- lbendlin
In your Power BI report add a Flow visual and add the measure (or any other relevant columns or measures) into its value well
Create a new flow from that visual
Use the Payload of the "Power BI Flow button pressed" trigger as a modifier of the DAX query you are planning to run against the semantic model.