Query run on Power Automate brings back null for the Selected Value

[dataexplorer123]

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 (single selection) on the same dashboard page where I have inserted power automate button. I have used these selected values in the report card and it is giving back results, also I have used these measures to generate URLs for the paginated report and it worked. But when I call those values in Power Automate, somehow it gives back null output.

Inside Power Automate, I have used the step "Run a query against a dataset" and inserted "EVALUATE
ROW(
"SelectedZone", [SelectedZone]
) "
I tried to check the interactions between the power automate and slicers and it is perfectly synced. I don't know what am I doing wrong. PLEASE help, it's super urgent!!!
 

[Anonymous]

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.

[dataexplorer123]

This works partially as it gives all the listed dates and Country/Zones.

[Anonymous]

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.

[dataexplorer123]

Not added other fields, only selected zone and selected date

[Anonymous]

Hi @dataexplorer123 ，

The SELECTEDVALUE function will only return a single value.
In my testing, Power Automate Flow will only return the single date/country selected in the slicer, not all of them.

How is your Power Automate Flow designed?

Can you provide some sample data? We can better understand the problem and help you.
How to provide sample data in the Power BI Forum - Microsoft Fabric Community
Or show it as a screenshot or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

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.

[lbendlin]

Power Automate has no way to understand what you mean by "SELECTEDVALUE".  There is no such concept when connecting to a semantic model from the outside.  You need to provide the actual filter values.

[dataexplorer123]

How should I connect my slicer (selected option) with the actual filters on Power Automate?

[lbendlin]

You 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.

[dataexplorer123]

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.