[PowerAutomate] Unable to Fetch JSON Data from LogicApp

[Scenario]

LogicApp fails getting PowerShell script output.

 

[Objectives]

- Investigate the error and modify "Parse JSON" step to receive outputs from the PowerShell script

 

[Remediation]

Parse JSON content was modified to get NULL data in case that one of fields has NULL date as below

{
    "properties": {
        "Department": {
            "type": [
                "string",
                null
            ]
        },
        "Office": {
            "type": [
                "string",
                null
            ]
        }
    },
    "type": "object"
}

 

However, NULL should be convered with double quotes(") in the type array.

{
    "properties": {
        "Department": {
            "type": [
                "string",
                "null"
            ]
        },
        "Office": {
            "type": [
                "string",
                "null"
            ]
        }
    },
    "type": "object"
}

 

With the double quotations, Parse JSON step works.