web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Parse JSON not working...
Power Automate
Unanswered

Parse JSON not working in Power Automate

(0) ShareShare
ReportReport
Posted on by 14

I created a New Flow to automate the VM creation and send emails with the IP address and server details to the registered email address. But in the Flow after the creation of the VM, I added a Parse JSON to get the IP address and details. But unfortunately, it's failing with the below error.

mailrhk_0-1676969046454.png

 

 

 

 

Categories:
I have the same question (0)
  • VictorIvanidze Profile Picture
    13,079 on at

    Please show the output of "read a template deployment".

  • mailrhk Profile Picture
    14 on at
    {
        "type""object",
        "properties": {
            "$schema": {
                "type""string"
            },
            "contentVersion": {
                "type""string"
            },
            "parameters": {
                "type""object",
                "properties": {
                    "publicIPAddresses_se_ip_name": {
                        "type""object",
                        "properties": {
                            "defaultValue": {
                                "type""string"
                            },
                            "type": {
                                "type""string"
                            }
                        }
                    }
                }
            },
            "variables": {
                "type""object",
                "properties": {}
            },
            "resources": {
                "type""array",
                "items": {
                    "type""object",
                    "properties": {
                        "type": {
                            "type""string"
                        },
                        "apiVersion": {
                            "type""string"
                        },
                        "name": {
                            "type""string"
                        },
                        "location": {
                            "type""string"
                        },
                        "tags": {
                            "type""object",
                            "properties": {
                                "Billing": {
                                    "type""string"
                                },
                                "Owner": {
                                    "type""string"
                                }
                            }
                        },
                        "sku": {
                            "type""object",
                            "properties": {
                                "name": {
                                    "type""string"
                                },
                                "tier": {
                                    "type""string"
                                }
                            }
                        },
                        "properties": {
                            "type""object",
                            "properties": {
                                "ipAddress": {
                                    "type""string"
                                },
                                "publicIPAddressVersion": {
                                    "type""string"
                                },
                                "publicIPAllocationMethod": {
                                    "type""string"
                                },
                                "idleTimeoutInMinutes": {
                                    "type""integer"
                                },
                                "ipTags": {
                                    "type""array"
                                }
                            }
                        }
                    },
                    "required": [
                        "type",
                        "apiVersion",
                        "name",
                        "location",
                        "tags",
                        "sku",
                        "properties"
                    ]
                }
            }
        }
    }
  • VictorIvanidze Profile Picture
    13,079 on at

    You've provided a template. Could you show the real output and mark values you wish to retrieve?

  • mailrhk Profile Picture
    14 on at

    Sorry i am new to this, how can i get the output....

  • mailrhk Profile Picture
    14 on at

    an you please help me to create schema , or you can suggest some article. 

  • mailrhk Profile Picture
    14 on at

    are you looking for this value?

     

    {
    "statusCode": 200,
    "headers": {
    "Pragma": "no-cache",
    "Transfer-Encoding": "chunked",
    "Vary": "Accept-Encoding",
    "x-ms-ratelimit-remaining-subscription-reads": "11999",
    "x-ms-request-id": "50c29b17-9f32-41b4-8771-2466fe8edd41",
    "x-ms-correlation-request-id": "50c29b17-9f32-41b4-8771-2466fe8edd41",
    "x-ms-routing-request-id": "NORTHCENTRALUS:20230222T125022Z:50c29b17-9f32-41b4-8771-2466fe8edd41",
    "Strict-Transport-Security": "max-age=31536000; includeSubDomains",
    "X-Content-Type-Options": "nosniff",
    "Timing-Allow-Origin": "*",
    "x-ms-apihub-cached-response": "true",
    "x-ms-apihub-obo": "false",
    "Cache-Control": "no-cache",
    "Date": "Wed, 22 Feb 2023 12:50:21 GMT",
    "Content-Type": "application/json",
    "Expires": "-1",
    "Content-Length": "5139"
    },
    "body": {
    "id": "/subscriptions/61ebc8ad-68bc-46af-901e-1a111621e85f/resourceGroups/testing/providers/Microsoft.Resources/deployments/dev",
    "name": "dev",
    "properties": {
    "templateLink": {
    "uri": "https://antworksworkflow.blob.core.windows.net/workflow/testtemplate.json",
    "contentVersion": "1.0.0.0"
    },
    "templateHash": "12883322460085956818",
    "parametersLink": {
    "uri": "https://antworksworkflow.blob.core.windows.net/workflow/testparameters.json"
    },
    "parameters": {
    "location": {
    "type": "String",
    "value": "centralindia"
    },
    "networkInterfaceName": {
    "type": "String",
    "value": "se927"
    },
    "networkSecurityGroupName": {
    "type": "String",
    "value": "se-nsg"
    },
    "networkSecurityGroupRules": {
    "type": "Array",
    "value": [
    {
    "name": "RDP",
    "properties": {
    "priority": 300,
    "protocol": "TCP",
    "access": "Allow",
    "direction": "Inbound",
    "sourceAddressPrefix": "*",
    "sourcePortRange": "*",
    "destinationAddressPrefix": "*",
    "destinationPortRange": "3389"
    }
    }
    ]
    },
    "subnetName": {
    "type": "String",
    "value": "default"
    },
    "virtualNetworkName": {
    "type": "String",
    "value": "testing-vnet"
    },
    "addressPrefixes": {
    "type": "Array",
    "value": [
    "10.5.0.0/16"
    ]
    },
    "subnets": {
    "type": "Array",
    "value": [
    {
    "name": "default",
    "properties": {
    "addressPrefix": "10.5.0.0/24"
    }
    }
    ]
    },
    "publicIpAddressName": {
    "type": "String",
    "value": "se-ip"
    },
    "publicIpAddressType": {
    "type": "String",
    "value": "Static"
    },
    "publicIpAddressSku": {
    "type": "String",
    "value": "Standard"
    },
    "pipDeleteOption": {
    "type": "String",
    "value": "Detach"
    },
    "virtualMachineName": {
    "type": "String",
    "value": "se"
    },
    "virtualMachineComputerName": {
    "type": "String",
    "value": "se"
    },
    "virtualMachineRG": {
    "type": "String",
    "value": "testing"
    },
    "osDiskType": {
    "type": "String",
    "value": "StandardSSD_LRS"
    },
    "osDiskDeleteOption": {
    "type": "String",
    "value": "Detach"
    },
    "virtualMachineSize": {
    "type": "String",
    "value": "Standard_B2s"
    },
    "nicDeleteOption": {
    "type": "String",
    "value": "Detach"
    },
    "adminUsername": {
    "type": "String",
    "value": "antworks"
    },
    "adminPassword": {
    "type": "SecureString"
    },
    "patchMode": {
    "type": "String",
    "value": "AutomaticByOS"
    },
    "enableHotpatching": {
    "type": "Bool",
    "value": false
    }
    },
    "mode": "Incremental",
    "provisioningState": "Failed",
    "timestamp": "2023-02-22T12:50:19.0460089Z",
    "duration": "PT4M31.131828S",
    "correlationId": "f8826eca-32f5-4b4d-b247-6b83560e9f23",
    "providers": [
    {
    "namespace": "Microsoft.Network",
    "resourceTypes": [
    {
    "resourceType": "networkInterfaces",
    "locations": [
    "centralindia"
    ]
    },
    {
    "resourceType": "networkSecurityGroups",
    "locations": [
    "centralindia"
    ]
    },
    {
    "resourceType": "virtualNetworks",
    "locations": [
    "centralindia"
    ]
    },
    {
    "resourceType": "publicIpAddresses",
    "locations": [
    "centralindia"
    ]
    }
    ]
    },
    {
    "namespace": "Microsoft.Compute",
    "resourceTypes": [
    {
    "resourceType": "virtualMachines",
    "locations": [
    "centralindia"
    ]
    }
    ]
    }
    ],
    "dependencies": [
    {
    "dependsOn": [
    {
    "id": "/subscriptions/61ebc8ad-68bc-46af-901e-1a111621e85f/resourceGroups/testing/providers/Microsoft.Network/networkSecurityGroups/se-nsg",
    "resourceType": "Microsoft.Network/networkSecurityGroups",
    "resourceName": "se-nsg"
    },
    {
    "id": "/subscriptions/61ebc8ad-68bc-46af-901e-1a111621e85f/resourceGroups/testing/providers/Microsoft.Network/virtualNetworks/testing-vnet",
    "resourceType": "Microsoft.Network/virtualNetworks",
    "resourceName": "testing-vnet"
    },
    {
    "id": "/subscriptions/61ebc8ad-68bc-46af-901e-1a111621e85f/resourceGroups/testing/providers/Microsoft.Network/publicIpAddresses/se-ip",
    "resourceType": "Microsoft.Network/publicIpAddresses",
    "resourceName": "se-ip"
    }
    ],
    "id": "/subscriptions/61ebc8ad-68bc-46af-901e-1a111621e85f/resourceGroups/testing/providers/Microsoft.Network/networkInterfaces/se927",
    "resourceType": "Microsoft.Network/networkInterfaces",
    "resourceName": "se927"
    },
    {
    "dependsOn": [
    {
    "id": "/subscriptions/61ebc8ad-68bc-46af-901e-1a111621e85f/resourceGroups/testing/providers/Microsoft.Network/networkInterfaces/se927",
    "resourceType": "Microsoft.Network/networkInterfaces",
    "resourceName": "se927"
    }
    ],
    "id": "/subscriptions/61ebc8ad-68bc-46af-901e-1a111621e85f/resourceGroups/testing/providers/Microsoft.Compute/virtualMachines/se",
    "resourceType": "Microsoft.Compute/virtualMachines",
    "resourceName": "se"
    }
    ],
    "error": {
    "code": "DeploymentFailed",
    "message": "At least one resource deployment operation failed. Please list deployment operations for details. Please see https://aka.ms/arm-deployment-operations for usage details.",
    "details": [
    {
    "code": "Conflict",
    "message": "{\r\n \"status\": \"Failed\",\r\n \"error\": {\r\n \"code\": \"ResourceDeploymentFailure\",\r\n \"message\": \"The 'AzureAsyncOperationWaiting' resource operation completed with terminal provisioning state 'Failed'.\",\r\n \"details\": [\r\n {\r\n \"code\": \"OSProvisioningClientError\",\r\n \"message\": \"OS Provisioning for VM 'se' did not finish in the allotted time. However, the VM guest agent was detected running. This suggests the guest OS has not been properly prepared to be used as a VM image (with CreateOption=FromImage). To resolve this issue, either use the VHD as is with CreateOption=Attach or prepare it properly for use as an image:\\r\\n * Instructions for Windows: https://azure.microsoft.com/documentation/articles/virtual-machines-windows-upload-image/ \\r\\n * Instructions for Linux: https://azure.microsoft.com/documentation/articles/virtual-machines-linux-capture-image/ \"\r\n }\r\n ]\r\n }\r\n}"
    }
    ]
    }
    }
    }
    }

  • mailrhk Profile Picture
    14 on at

    @VictorIvanidze Can you please help on this....

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
trice602 Profile Picture

trice602 398 Super User 2025 Season 2

#2
David_MA Profile Picture

David_MA 323 Super User 2025 Season 2

#3
Expiscornovus Profile Picture

Expiscornovus 183 Most Valuable Professional

Last 30 days Overall leaderboard