jfox0603's avatar
jfox0603
Frequent Visitor
4 years ago
Status:
Investigating

***BUG*** Power Automate Email alert raised by KPI Tile Alert has wrong value for field Tile Value

I have several Power Automate flows that i have created and tied to alerts raised by KPI Visualization tiles on a Power BI Dashboard. The alerts generated by the dashboard are fine, but when i use the "Tile Value" in the PA Flow,  I am getting incorrect values in the subsequent emails or adaptive cards.

4 Comments

  • v-cazheng-msft's avatar
    v-cazheng-msft
    Icon for Community Support rankCommunity Support
    Status changed:
    New
    to
    Investigating

    Hi jfox0603 

     

    Thanks for your feedback. Could you please provide a screenshot to let me know how you set your Power Automate flow so I can test at my side?

     

    Best Regards,

    Community Support Team _Caiyun

  • jfox0603's avatar
    jfox0603
    Frequent Visitor

    Thanks for the response. Here are a series of screen shots.

     

    KPI Viz on Dashboard

     

    Dashboard Alert Setup

     

    Flow Definition

     

    Power BI Alert...Note Current value is 291322, which is correct

     

    Flow Alert Message - Notice current value shows 246,841...incorrect. Threshold is correct, and the 36,000 is hard coded in the flow def.

     

     

        

        

  • jfox0603's avatar
    jfox0603
    Frequent Visitor

    Note...if i change the date range on the KPI to just the current date, the alert through Power Automate works as expected. it just gives incorrect values when more that one day is shown in the KPI. Is it grabbing an average or some other summarization???