logic app - send an email v2 - dynamic content
When I add dynamic content functions into my email body, as per the diagram, they fail to appear. Can some bright person please tell me why?
Also, how do I fix this issue? Im not an html dev.
Can this be remediated via simple drag and drop or this a bug in the logic app which requires it be written in?
Any help would be great.
Ive been dragging variables and parse json functions to no avail.
Im not a developer so if something is broken here, I would really appreciate some pointers please?
i suspect there is some sort of disparty between the parse json output and the send an email v2 output being generated:
parse json output:
{
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['office365']['connectionId']"
}
},
"method": "post",
"body": {
"To": "allen.visser@gmail.com",
"Subject": "POSITIVE: REG APP EXP @{variables('displayName')} ",
"Body": "<p>appid : @{body('Parse_JSON')?['properties']?['value']?['type']?['type']?['type']?['items']?['type']?['properties']?['appId']}<br>\n<br>\n<br>\nappid : @{body('Parse_JSON')?['d']?['properties']?['value']?['items']?['properties']?['appId']}<br>\n</p>",
"Importance": "Normal"
},
"path": "/v2/Mail",
"authentication": "@parameters('$authentication')"
}
}
and the parse json body:
{
"inputs": {
"host": {
"connection": {
"name": "@parameters('$connections')['office365']['connectionId']"
}
},
"method": "post",
"body": {
"To": "allen.visser@vaxowave.com",
"Subject": "POSITIVE: REG APP EXP @{variables('displayName')} ",
"Body": "<p>appid : @{body('Parse_JSON')?['properties']?['value']?['type']?['type']?['type']?['items']?['type']?['properties']?['appId']}<br>\n<br>\n<br>\nappid : @{body('Parse_JSON')?['d']?['properties']?['value']?['items']?['properties']?['appId']}<br>\n</p>",
"Importance": "Normal"
},
"path": "/v2/Mail",
"authentication": "@parameters('$authentication')"
}
}
***********************
{
"properties": {
"properties": {
"properties": {
"@@@odata.context": {
"properties": {
"type": {
"items": {
"type": "string"
},
"type": "array"
}
},
"type": "object"
},
"@@@odata.nextLink": {
"properties": {
"type": {
"items": {
"type": "string"
},
"type": "array"
}
},
"type": "object"
},
"value": {
"properties": {
"items": {
"properties": {
"properties": {
"properties": {
"appId": {
"properties": {
"type": {
"items": {
"type": "string"
},
"type": "array"
}
},
"type": "object"
},
"displayName": {
"properties": {
"type": {
"items": {
"type": "string"
},
"type": "array"
}
},
"type": "object"
},
"id": {
"properties": {
"type": {
"items": {
"type": "string"
},
"type": "array"
}
},
"type": "object"
},
"passwordCredentials": {
"properties": {
"items": {
"properties": {
"properties": {
"properties": {
"customKeyIdentifier": {
"properties": {
"type": {
"items": {
"type": "string"
},
"type": "array"
}
},
"type": "object"
},
"displayName": {
"properties": {},
"type": "object"
},
"endDateTime": {
"properties": {
"type": {
"items": {
"type": "string"
},
"type": "array"
}
},
"type": "object"
},
"hint": {
"properties": {},
"type": "object"
},
"keyId": {
"properties": {
"type": {
"items": {
"type": "string"
},
"type": "array"
}
},
"type": "object"
},
"secretText": {
"properties": {},
"type": "object"
},
"startDateTime": {
"properties": {
"type": {
"items": {
"type": "string"
},
"type": "array"
}
},
"type": "object"
}
},
"type": "object"
},
"required": {
"items": {
"type": "string"
},
"type": "array"
},
"type": {
"type": "string"
}
},
"type": "object"
},
"type": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
},
"required": {
"items": {
"type": "string"
},
"type": "array"
},
"type": {
"type": "string"
}
},
"type": "object"
},
"type": {
"type": "string"
}
},
"type": "object"
}
},
"type": "object"
},
"type": {
"type": "string"
}
},
"type": "object"
}
Solution
When I add dynamic content functions into my email body, as per the diagram, they fail to appear.
You can get the values from dynamic content in email body like below-
Code-
{
"definition": {
"$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
"actions": {
"Data": {
"inputs": {
"variables": [
{
"name": "Data",
"type": "string",
"value": "{\n\"FirstName\": \"Ikhtesam\",\n\"LastName\": \"Afrin\"\n}"
}
]
},
"runAfter": {
"Display_Name": [
"Succeeded"
]
},
"type": "InitializeVariable"
},
"Display_Name": {
"inputs": {
"variables": [
{
"name": "DisplayName",
"type": "string",
"value": "TestSecret"
}
]
},
"runAfter": { },
"type": "InitializeVariable"
},
"Parse_JSON": {
"inputs": {
"content": "@variables('Data')",
"schema": {
"properties": {
"FirstName": {
"type": "string"
},
"LastName": {
"type": "string"
}
},
"type": "object"
}
},
"runAfter": {
"Data": [
"Succeeded"
]
},
"type": "ParseJson"
},
"Send_an_email_(V2)": {
"inputs": {
"body": {
"Body": "<p><strong>This is a onfirmation email-</strong><br>\n<br>\nVariables display name: @{variables('DisplayName')}<br>\n<br>\nFirstName is: @{body('Parse_JSON')?['FirstName']}<br>\n<br>\nLastName is: @{body('Parse_JSON')?['LastName']}</p>",
"Importance": "Normal",
"Subject": "POSITIVE Secret expired @{variables('DisplayName')}",
"To": "*****@xyz.com"
},
"host": {
"connection": {
"name": "@parameters('$connections')['office365']['connectionId']"
}
},
"method": "post",
"path": "/v2/Mail"
},
"runAfter": {
"Parse_JSON": [
"Succeeded"
]
},
"type": "ApiConnection"
}
},
"contentVersion": "1.0.0.0",
"outputs": { },
"parameters": {
"$connections": {
"defaultValue": { },
"type": "Object"
}
},
"triggers": {
"manual": {
"inputs": {
"schema": { }
},
"kind": "Http",
"type": "Request"
}
}
},
"parameters": {
"$connections": {
"value": {
"office365": {
"connectionId": "/subscriptions/**************/resourceGroups/*********/providers/Microsoft.Web/connections/office365",
"connectionName": "office365",
"id": "/subscriptions/***********/providers/Microsoft.Web/locations/eastus/managedApis/office365"
}
}
}
}
}
I am getting the email with all the values in it.
You can format the email body as per your requirement.
- PowerPivot extract text after different characters
- Error: "OrganizationFromTenantGuidNotFound" (even with Microsoft 365 subscription)
- Office 365 REST API - Creating a Contact gives me HTTPCode 400
- How to get the current user’s Delve URL via Microsoft Graph API
- Office 365 Exchange Online permission is not visible for registered application in azure active directory
- Outlook IMAP search not returning correct value with BODY search criteria
- Connect-ExchangeOnline with German 0365 cloud always times out
- Do i need to have Microsoft 365 subscription to use Graph API for outlook in python?
- SPFX get Microsoft Outlook room events using Graph API
- MailKit OAuth2 SMTP Office365 Send Mail
- How do I make the number stay the same, but continue from where it was left off if the day is different
- Wrong date format when reading outlook calendar event
- Get Email (V2) in power automate is throwing an "ID is Malformed"
- Send javamail using Office365
- Shared Folder is missing in the Office My Addin ribbon suddenly in Angular Office Addin Project
- How to count resolved comments only via VBA in Excel
- Download SharePoint file from Microsoft Graph API using "sourcedoc" ID
- Microsoft Graph API - "Decline event" call fails
- Problem when trying to read Office365 calendar
- Change Identity Source for Azure Accounts and Groups
- Django: send email via Office365
- Failed to validate the signature of the actionable message card Power Automate
- Power BI to users without Power BI
- Locate and/or reinstall link to MS Query in Excel 365
- Using Office365 excel array formulas, how to remove duplicates, keeping the last value?
- My Power Automate email has no attachment contents
- Configure microsoft teams incoming webhook json payload
- How to create a Office 365 Outlook alias from .NET via API
- Checking the if Outlook is reachable with Powershell (GCCH)
- How to remove line within tables?