I have a flow that includes a query against a Power BI dataset followed by a conditional switch that sends an email based on the output of the query.
The output I expect to see is "good" as that is the result of the field in the report. But the output I'm getting in Power Automate is "rev". I believe this is because the output of the query does not include the date filter. When I apply the date filter, my output is "good", when no filter is applied, it is "rev".
Do I need to first apply a filter in my flow to match the filter that exists in my report? If so, how do I do that?

Report
All responses (
Answers (