I am trying to get an output of the query which has triggered an alert in the logic app ( to parse it and send an email to specific receiver).
I can't run the query itself in the logic app, I have to get result from an allert.
I'm defining the logic app, specifying first step as When HTTP request is received (I provided webhook URL in an alert accordingly) and different input schemas from https://learn.microsoft.com/en-us/azure/azure-monitor/alerts/alerts-non-common-schema-definitions (expected to have it working with monitoringService = Log Alerts V1 – Metric) but ending up with not having SearchResult.tables property in received JSON.
The query just aggregates some data and condition is to trigger an alert when num rows > X, so in addition to have triggered alert, I need to receive that aggregated data in my email. All guidances refer to Azure Alert + Logic App, however I am stuck in Step 1 - Logic App receives JSON without any query output related data like SearchResult.tables property.
what am I missing? TIA!
