Forum Discussion
Query run on Power Automate brings back null for the Selected Value
Thanks for the reply from lbendlin , please allow me to provide another insight.
Hi dataexplorer123 ,
You need to replace the measure in the query text with the dynamic content of the corresponding measure in Power BI.
Below is my testing process.
1. Create two measures and add them to the data in the Power Automate Flow visual.
Selected Country = SELECTEDVALUE('Table'[Country])
Selected Date = SELECTEDVALUE('Table'[Date])
2. Then edit the Power Automate Flow
3. Returning to the report, both slicers select values to be passed to the corresponding two measures.
Then click the Run Flow button to trigger the flow.
4. The final result successfully shows the values of both measures.
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This works partially as it gives all the listed dates and Country/Zones.
Hi dataexplorer123 ,
Does the data in the Power Automate Flow visual contain only the /Selected Zone/ and /Selected Date/ measures?
Have other fields been added?How are data fields in the Power Automate Flow visual affected by external filtering?
Best Regards,
Dengliang Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Not added other fields, only selected zone and selected date
