Flow+Alert+Slack - problems with calculated measure

[Kevin_Conseil]

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

[v-xuding-msft]

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]

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