Parse JSON

[neill_long]

Hello,

I am getting an error when my flow runs and not too sure how to fix it.

The error is to do with the Parse JSON.  This is the error that I am getting:

[
  {
    "message": "Required properties are missing from object: DegreeCourse.",
    "lineNumber": 0,
    "linePosition": 0,
    "path": "[445]",
    "value": [],
    "schemaId": "#/items",
    "errorType": "required",
    "childErrors": []
  }
]

I have checked the list and there are a couple of empty fields in the 'DegreeCourse' column so I am assuming that the JSON is expecting a value and wont run if it is empty.  I dont have any experience with JSON, I followed a video and came up with this, which did initially work when all required fields had text in them:

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "AgreementType": {
                "type": "string"
            },
            "Course": {
                "type": "string"
            },
            "DegreeCourse": {
                "type": "string"
            },
            "Department": {
                "type": "string"
            },
            "OtherInformation": {
                "type": "string"
            },
            "Title": {
                "type": "string"
            }
        },
        "required": [
            "AgreementType",
            "Course",
            "DegreeCourse",
            "Department",
            "Title"
        ]
    }
}

What can I add to this to ensure it will still run even if there is an empty field, not necessarily in the DegreeCourse but for all the required fields?

thanks

[Sundeep_Malik · Accepted solution]

Hey @neill_long 

First remove everything from required. 

If it still gives you the error. Then make some changes in the schema, like in the type of every field write:

"type": ["string","null"]

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "AgreementType": {
                "type": ["string","null"]
            },
            "Course": {
                "type": ["string","null"]
            },
            "DegreeCourse": {
                "type": ["string","null"]
            },
            "Department": {
                "type": ["string","null"]
            },
            "OtherInformation": {
                "type": ["string","null"]
            },
            "Title": {
                "type": ["string","null"]
            }
        }
    }
}

Hopefully now it will work. 🙂

[neill_long]

so it now got past the parse json but failed on the next step which is a create CSV table:

The execution of template action 'Create_CSV_table' failed. The column values could not be evaluated: 'The template language expression 'item()['DegreeCourse']' cannot be evaluated because property 'DegreeCourse' doesn't exist, available properties are 'AgreementType, Course, Department, OtherInformation, Title'. Please see https://aka.ms/logicexpressions for usage details.'.

I dont understand why it is saying it doesn't exist on this.  Any ideas?

thanks

[Sundeep_Malik]

@neill_long 

Yup, now you can use coalesce function for this:

write the expression as:

coalesce(item()?['DegreeCourse'],false)

So, what it will do is, if it is not able to find degree course, it will just fill it with a value of false. If you give any other value, it will fill it with any other value. 

To read more about coalesce function, giving you a link:

https://www.c-sharpcorner.com/article/usage-of-coalesce-function-in-power-automate/

[neill_long]

brilliant thanks very much for your help