How can I access Azure Alert Custom Properties in a Logic App

Question

How can I access Azure Alert Custom Properties in a Logic App

Robert Heynen 50

In the standard Common Alert schema, there is a "CustomProperties" object that holds an array of Key Value pairs (I am assuming this references the Custom Properties of the Alert"

How can I access the values from inside a Logic App that is sending an email?

I have tried expression variable('keyname')[0] but that will not allow me to save without instantiating the variable

Ultimately I am hoping to store the emailTo and emailCC in those fields so I can easily change them if needed. We have multiple clients that I want to send an alert to but need some flexibility as to who I can send it to

MayankBargali-MSFT 70,891 Reputation points

2023-07-27T05:12:51.74+00:00

Hi @Robert Heynen

Following up to see if you have reviewed the document and helped to resolve the issue. If not, then please share the response data/schema and what property you want to access so I can assist you further.

Please "Accept Answer" if the answer is helpful so that it can help others in the community.

1 answer

Your answer

MayankBargali-MSFT 70,891 Reputation points

2023-07-27T05:12:51.74+00:00

Hi @Robert Heynen

Following up to see if you have reviewed the document and helped to resolve the issue. If not, then please share the response data/schema and what property you want to access so I can assist you further.

Please "Accept Answer" if the answer is helpful so that it can help others in the community.

Answer 1

MayankBargali-MSFT 70,891

@Robert Heynen Thanks for reaching out. If you can share the schema or the response data (removing the sensitive information in your HTTP trigger output) then I can assist you with how you can access that property in your workflow. You can also refer to this document on how to create your workflow based on your alert.

Robert Heynen 50

My basic schema is a standard schema as provided by MS. What I am trying to do is send an email but with a dynamic To and CC....I notice schemas that have CustomProperties included but I am asking how I access those properties in the Logic App Builder. I am trying to drive this email from an Alert. Under an Alert under Action, there are CustomProperties....I am assuming the CustomProperties are those in the Action group however when I try to add a variable in the LogicApp, it fails.

{
    "data": {
        "alertContext": {
            "condition": {
                "allOf": [
                    {
                        "dimensions": [
                            {
                                "name": "",
                                "value": ""
                            }
                        ],
                        "metricName": "",
                        "metricNamespace": "",
                        "metricValue": null,
                        "operator": "",
                        "threshold": "",
                        "timeAggregation": ""
                    }
                ],
                "windowSize": ""
            },
            "conditionType": "",
            "properties": null
        },
        "customProperties": {
            "EmailCc": "",
            "EmailTo": "",
            "Environment": ""
        },
        "essentials": {
            "alertContextVersion": "",
            "alertId": "",
            "alertRule": "",
            "alertTargetIDs": [
                ""
            ],
            "configurationItems": [
                ""
            ],
            "description": "",
            "essentialsVersion": "",
            "firedDateTime": "",
            "monitorCondition": "",
            "monitoringService": "",
            "originAlertId": "",
            "resolvedDateTime": "",
            "severity": "",
            "signalType": ""
        }
    },
    "schemaId": ""
}

Robert Heynen 50

A schema shown here has the following and what I would like to do is see how I may access the customProperties

{
	"schemaId": "Microsoft.Insights/activityLogs",
	"data": {
		"status": "Activated",
		"context": {
			"activityLog": {
				"authorization": {
					"action": "Microsoft.Compute/virtualMachines/restart/action",
					"scope": "/subscriptions/11111111-1111-1111-1111-111111111111/resourceGroups/test-RG/providers/Microsoft.Compute/virtualMachines/test-VM"
				},
				"channels": "Operation",
				"claims": "{}",
				"caller": "******@domain.com",
				"correlationId": "aaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa",
				"description": "",
				"eventSource": "Administrative",
				"eventTimestamp": "2021-11-16T08:27:36.1836909+00:00",
				"eventDataId": "bbbbbbbb-bbbb-bbbb-bbbb-bbbbbbbbbbbb",
				"level": "Informational",
				"operationName": "Microsoft.Compute/virtualMachines/restart/action",
				"operationId": "cccccccc-cccc-cccc-cccc-cccccccccccc",
				"properties": {
					"eventCategory": "Administrative",
					"entity": "/subscriptions/11111111-1111-1111-1111-111111111111/resourceGroups/test-RG/providers/Microsoft.Compute/virtualMachines/test-VM",
					"message": "Microsoft.Compute/virtualMachines/restart/action",
					"hierarchy": "22222222-2222-2222-2222-222222222222/CnAIOrchestrationServicePublicCorpprod/33333333-3333-3333-3333-3333333303333/44444444-4444-4444-4444-444444444444/55555555-5555-5555-5555-555555555555/11111111-1111-1111-1111-111111111111"
				},
				"resourceId": "/subscriptions/11111111-1111-1111-1111-111111111111/resourceGroups/test-RG/providers/Microsoft.Compute/virtualMachines/test-VM",
				"resourceGroupName": "test-RG",
				"resourceProviderName": "Microsoft.Compute",
				"status": "Succeeded",
				"subStatus": "",
				"subscriptionId": "11111111-1111-1111-1111-111111111111",
				"submissionTimestamp": "2021-11-16T08:29:00.141807+00:00",
				"resourceType": "Microsoft.Compute/virtualMachines"
			}
		},
		"properties": {
			"customKey1": "value1",
			"customKey2": "value2"
		}
	}
}

https://learn.microsoft.com/en-us/azure/azure-monitor/alerts/alerts-non-common-schema-definitions

Robert Heynen 50 Reputation points

2023-07-28T21:09:28.2033333+00:00

Sorry I should not say Failed but rather it cannot find the customProperties in the LogicApp builder.
MayankBargali-MSFT 70,891 Reputation points

2023-07-31T16:24:51.61+00:00

@Robert Heynen Thanks for sharing more details. Let me review it if this is supported and get back to you.
Robert Heynen 50 Reputation points

2023-07-31T19:38:04.3533333+00:00

I was able to get the Custom Properties object by creating a variable as an Object using value triggerBody()?['data']?['customProperties'] Now I just need to know how to extract a value from the object...

For instance

{"Environment":"STAGE","TestingCustomProperties":"TestingCustomPropertiesValue"}

How do I acquire the values for 'TestingCustomProperties'?
Robert Heynen 50 Reputation points

2023-07-31T20:30:00.15+00:00

I am testing now but I believe I cna obtain the correct customproperty by initializing a variable as a string and using the expression triggerBody()?['data']?['customProperties']?['TestingCustomProperties']
MayankBargali-MSFT 70,891 Reputation points

2023-08-01T04:58:37.3166667+00:00

@Robert Heynen If this is the correct JSON object then you can use triggerBody()?['data']?['customProperties']?['TestingCustomProperties']

You don't need to initialize a variable as you can directly use it in any of your further actions. In case if you still want to use the variable and you are setting the value to the variable inside the for each loop then I will suggest to set the Degree of parallelism to 1 for your for each loop action by navigating to setting --> enable the concurrency control as it will help in overwriting your variable value inside the foreach loop.

{"Environment":"STAGE","TestingCustomProperties":"TestingCustomPropertiesValue"}
MayankBargali-MSFT 70,891 Reputation points

2023-08-03T05:18:08.9266667+00:00

@Robert Heynen Follow up to see how was your testing outcome and need any further assistance.

Share via

How can I access Azure Alert Custom Properties in a Logic App

1 answer

Your answer