Re: Don't send email if the flow body is empty
Thanks for reply,
The connector is "
Kusto - Run query and visualize results ". I have tried the expression @empty(body('Run_query_and_visualize_results')). But it's always return false whether the "Kusto - Run query and visualize results" return data or not. I have tried follwoing option that didn't work for me :
@contains(body('Run_query_and_visualize_results')?['body'], 'com.microsoft')
empty(item()?['appId'])
@and(empty(item()?['appId']), empty(item()?['standardDeviationRate']))
@and(empty(item()?['appId']), empty(item()?['standardDeviationRate']))
@empty(body('Run_query_and_visualize_results')?['body'])
@equals(body('Run_query_and_visualize_results')?['body'], '')
@equals(body('Run_query_and_visualize_results'), '')
@contains(body('Run_query_and_visualize_results'), 'com.microsoft')
@empty(body('Run_query_and_visualize_results'))
@not(empty(body('Run_query_and_visualize_results')['body']))
@contains(coalesce(body('Run_query_and_visualize_results')['body'], ''), 'com.microsoft')
@empty(coalesce(body('Run_query_and_visualize_results')['body'], ''))
Error-:
InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '2168': 'The template language expression 'not(empty(body('Run_query_and_visualize_results')['appId']))' cannot be evaluated because property 'appId' doesn't exist, available properties are 'attachmentName, attachmentContent, body'. Please see
https://aka.ms/logicexpressions for usage details.'.
@not(empty(body('Run_query_and_visualize_results')['body']['appId']))
Error-:
InvalidTemplate. Unable to process template language expressions for action 'Condition' at line '1' and column '2168': 'The template language expression 'not(empty(body('Run_query_and_visualize_results')['body']['appId']))' cannot be evaluated because property 'appId' cannot be selected. Property selection is not supported on values of type 'String'. Please see
https://aka.ms/logicexpressions for usage details.'.
Thanks
Biswapati