azureazure-logic-apps
Append result in Azure Logic Apps
I have below json input to logic apps
[
{
"ACTIVITYID": "0002868073",
"STATUS": "Released",
"COMMENTS": [
{
"COMMENT": "Comment_1"
},
{
"COMMENT": "Comment_2"
}
]
},
{
"ACTIVITYID": "0002868071",
"STATUS": "Approved",
"COMMENTS": [
{
"COMMENT": "Comment_3"
},
{
"COMMENT": "Comment_4"
}
]
}
]
I want output like
0002868073 Released Comment_1 Comment_2
0002868071 Approved Comment_3 Comment_4
Here is my logic apps code view
{
"definition": {
"$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
"actions": {
"For_each_-_ActivityLoop": {
"actions": {
"Append_to_string_variable_2": {
"inputs": {
"name": "FinalComment",
"value": "@variables('AppendInnerComment')"
},
"runAfter": {
"For_each_-_CommentsLoop": [
"Succeeded"
]
},
"type": "AppendToStringVariable"
},
"For_each_-_CommentsLoop": {
"actions": {
"Append_to_string_variable": {
"inputs": {
"name": "InnerComment",
"value": "@items('For_each_-_CommentsLoop')['COMMENT']"
},
"runAfter": {},
"type": "AppendToStringVariable"
},
"Append_to_string_variable_3": {
"inputs": {
"name": "AppendInnerComment",
"value": "@variables('InnerComment')"
},
"runAfter": {
"Append_to_string_variable": [
"Succeeded"
]
},
"type": "AppendToStringVariable"
}
},
"foreach": "@items('For_each_-_ActivityLoop')['COMMENTS']",
"runAfter": {},
"type": "Foreach"
},
"Set_variable_2": {
"inputs": {
"name": "FinalOutput",
"value": "@{items('For_each_-_ActivityLoop')['ACTIVITYID']}@{items('For_each_-_ActivityLoop')['STATUS']}@{variables('FinalComment')}"
},
"runAfter": {
"Append_to_string_variable_2": [
"Succeeded"
]
},
"type": "SetVariable"
}
},
"foreach": "@body('Parse_JSON')",
"runAfter": {
"Parse_JSON": [
"Succeeded"
]
},
"type": "Foreach"
},
"Initialize_FinalComment": {
"inputs": {
"variables": [
{
"name": "FinalComment",
"type": "string"
}
]
},
"runAfter": {
"Initialize_variable_-_AppendInnerComment": [
"Succeeded"
]
},
"type": "InitializeVariable"
},
"Initialize_FinalOutput": {
"inputs": {
"variables": [
{
"name": "FinalOutput",
"type": "string"
}
]
},
"runAfter": {
"Initialize_FinalComment": [
"Succeeded"
]
},
"type": "InitializeVariable"
},
"Initialize_InnerComment": {
"inputs": {
"variables": [
{
"name": "InnerComment",
"type": "string"
}
]
},
"runAfter": {
"Initialize_FinalOutput": [
"Succeeded"
]
},
"type": "InitializeVariable"
},
"Initialize_variable_-_AppendInnerComment": {
"inputs": {
"variables": [
{
"name": "AppendInnerComment",
"type": "string"
}
]
},
"runAfter": {},
"type": "InitializeVariable"
},
"Parse_JSON": {
"inputs": {
"content": "@triggerBody()",
"schema": {
"items": {
"properties": {
"ACTIVITYID": {
"type": "string"
},
"COMMENTS": {
"items": {
"properties": {
"COMMENT": {
"type": "string"
}
},
"required": [
"COMMENT"
],
"type": "object"
},
"type": "array"
},
"SAPUSERID": {
"type": "string"
},
"STATUS": {
"type": "string"
}
},
"required": [
"ACTIVITYID",
"STATUS",
"SAPUSERID",
"COMMENTS"
],
"type": "object"
},
"type": "array"
}
},
"runAfter": {
"Initialize_InnerComment": [
"Succeeded"
]
},
"type": "ParseJson"
}
},
"contentVersion": "1.0.0.0",
"outputs": {},
"parameters": {},
"triggers": {
"manual": {
"inputs": {
"method": "POST",
"schema": {
"items": {
"properties": {
"ACTIVITYID": {
"type": "string"
},
"COMMENTS": {
"items": {
"properties": {
"COMMENT": {
"type": "string"
}
},
"required": [
"COMMENT"
],
"type": "object"
},
"type": "array"
},
"SAPUSERID": {
"type": "string"
},
"STATUS": {
"type": "string"
}
},
"required": [
"ACTIVITYID",
"STATUS",
"SAPUSERID",
"COMMENTS"
],
"type": "object"
},
"type": "array"
}
},
"kind": "Http",
"type": "Request"
}
}
},
"parameters": {}
}
However, I get the output:
0002868073 Released Comment_1 Comment_1 Comment_2
0002868071 Approved Comment_1Comment_1Comment_2Comment_1Comment_1Comment_2Comment_1Comment_2Comment_3Comment_1Comment_2Comment_3Comment_4
Please advice to get the desired result.
Solution
Is this what you want?
{
"definition": {
"$schema": "https://schema.management.azure.com/providers/Microsoft.Logic/schemas/2016-06-01/workflowdefinition.json#",
"actions": {
"For_Each_Activity": {
"actions": {
"Append_To_Final_Array": {
"inputs": {
"name": "Final Array",
"value": "@{items('For_Each_Activity')['ACTIVITYID']} @{items('For_Each_Activity')['STATUS']} @{trim(variables('Concatenated Comments'))}"
},
"runAfter": {
"For_Each_Comment": [
"Succeeded"
]
},
"type": "AppendToArrayVariable"
},
"For_Each_Comment": {
"actions": {
"Append_To_Concatenated_Comments": {
"inputs": {
"name": "Concatenated Comments",
"value": "@{items('For_Each_Comment')['COMMENT']} "
},
"runAfter": {},
"type": "AppendToStringVariable"
}
},
"foreach": "@items('For_Each_Activity')['COMMENTS']",
"runAfter": {
"Set_Concatenated_Comments": [
"Succeeded"
]
},
"type": "Foreach"
},
"Set_Concatenated_Comments": {
"inputs": {
"name": "Concatenated Comments",
"value": "@{string('')}"
},
"runAfter": {},
"type": "SetVariable"
}
},
"foreach": "@triggerBody()",
"runAfter": {
"Initialize_Concatenated_Comments": [
"Succeeded"
]
},
"runtimeConfiguration": {
"concurrency": {
"repetitions": 1
}
},
"type": "Foreach"
},
"Initialize_Concatenated_Comments": {
"inputs": {
"variables": [
{
"name": "Concatenated Comments",
"type": "string"
}
]
},
"runAfter": {
"Initialize_Final_Array": [
"Succeeded"
]
},
"type": "InitializeVariable"
},
"Initialize_Final_Array": {
"inputs": {
"variables": [
{
"name": "Final Array",
"type": "array"
}
]
},
"runAfter": {},
"type": "InitializeVariable"
},
"Initialize_Result": {
"inputs": {
"variables": [
{
"name": "Result",
"type": "string",
"value": "@{join(variables('Final Array'), '\r\n')}"
}
]
},
"runAfter": {
"For_Each_Activity": [
"Succeeded"
]
},
"type": "InitializeVariable"
}
},
"contentVersion": "1.0.0.0",
"outputs": {},
"parameters": {},
"triggers": {
"manual": {
"inputs": {
"method": "POST",
"schema": {
"items": {
"properties": {
"ACTIVITYID": {
"type": "string"
},
"COMMENTS": {
"items": {
"properties": {
"COMMENT": {
"type": "string"
}
},
"required": [
"COMMENT"
],
"type": "object"
},
"type": "array"
},
"SAPUSERID": {
"type": "string"
},
"STATUS": {
"type": "string"
}
},
"required": [
"ACTIVITYID",
"STATUS",
"SAPUSERID",
"COMMENTS"
],
"type": "object"
},
"type": "array"
}
},
"kind": "Http",
"type": "Request"
}
}
},
"parameters": {}
}
- How to check Debug.Writeline() output in VS code?
- C# API - Provide download of files from Azure Blobstorage
- localhost:300/api is not working : "This page isn’t working"
- Creating an Azure Linux VM with Ubuntu 20.04 with Terraform
- Failed to deploy path that does not exist
- Using Azure WAF for my server(not in Azure)
- How and where to define an environment variable on Azure
- Azure Data Factory - Unable to preview data
- Azure yaml trigger pipeline every 14 days on a Saturday
- Diagnostic setting not included in Azure Portal ARM template export
- How do I read the original pdf file in set indexer datasource in a custom WebApiSkill after enabling "Allow Skillset to read file data"
- How do I store vectors generated by AzureOpenAIEmbeddingSkill in indexer given my current setup
- Authenticating using the Azure CLI is only supported as a User (not a Service Principal)
- Azure Function App - frequent hang and deadlocks
- Sign Tool for Azure Trusted Service Account Error information: "Error: SignerSign() failed." (-2147467259/0x80004005)
- How to convert the premium file share to premium block blob storage account or standard general purpose v2 storage account?
- How to generate an azure blob url with SAS signature in nodejs sdk v12?
- How to Assign Role to New User with Graph API
- Directory disappears from azure cloud shell (home)
- Application Insights Logging Exceptions as Trace
- Issue with Azure key vault and Azure storage account deployment
- AddDataProtection().PersistKeysToAzureBlobStorage().ProtectKeysWithAzureKeyVault() getting httpVerb Error while accessing the blob storage
- temporary_name_for_rotation must be specified when changing any of the following properties: pod_subnet_id
- Native Node.js Metrics in Application Insights
- Azure Key Vault Disabled public access, how to access it through the portal via internet
- Using Google.Cloud.BigQuery.V2 API in Azure Functions
- Azure Functions no job found (python)
- Azure Machine Learning - Online Endpoint Schedule/Cost management
- Is it possible to read File from same folder where Azure function exists
- Make WAF policy to only allow Azure Load Testing or Azure Services