This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(140.8, 5%, 23%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERH%3C/text%3E%3C/svg%3E)
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
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.
@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.
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": ""
}
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": "user-email@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
Sorry I should not say Failed but rather it cannot find the customProperties in the LogicApp builder.
@Robert Heynen Thanks for sharing more details. Let me review it if this is supported and get back to you.
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'?
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']
@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"}
@Robert Heynen Follow up to see how was your testing outcome and need any further assistance.