Forum Discussion

Kevin_Conseil's avatar
Kevin_Conseil
Helper II
7 years ago

Flow+Alert+Slack - problems with calculated measure

Hi everyone,

 

I am using Flow topost a slack message when an alert is triggered. 

 

Everything works fine except for the alerts that are based on a calculated measure. the tile value is blank and no data are displayed. 

 

Any idea why is it happening and is there a workaround ?

 

Best,

Kevin

Need Help

2 Replies

  • v-xuding-msft's avatar
    v-xuding-msft
    Community Support
    7 years ago

    Hi Kevin_Conseil ,

    Can you please share more details?

    • How do you set the condition and threshold for alert? 
    • Can you please share the formula of the measure?
    • And please tell us what the results it should be.

    Best Regards,

    Xue Ding

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

    • MichaelTranPBI's avatar
      MichaelTranPBI
      New Member
      6 years ago

      Hi Xue,

       

      I am also having the same problem. I can see the values on the dashboard but when it's passed to Flow the TileValue is null

       

      Here is the error message below when running Flow test.

      InvalidTemplate. Unable to process template language expressions for action 'CU_Check' at line '1' and column '2683': 'The template language function 'greater' expects all of its parameters to be either integer or decimal numbers. Found invalid parameter types: 'Null'.'.
       
      I was trying to cast the TileValue to integer but got another error message.
      InvalidTemplate. Unable to process template language expressions for action 'JT_Check' at line '1' and column '2683': 'The template language function 'int' was invoked with a parameter that is not valid. The value cannot be converted to the target type.'.
       
      I have set the manage alerts for the tile with condition below threshold of -0.2.
       
      I need both "TileValue" to be less than -0.2 and "isAlertTrigger" is true before I email alert.
       
      I have used expression to convert  the TileValue to integer but getting the error message above.
      My expression: int(body('JT_Alert')?['tileValue'] )
       
      Thanks,
      Michael Tran