Power Automate - Building Flows

Answered

Parse Json to include Null?

(0) Share

Report

Posted on by hmenzel

How can I edit this parse Json to allow "null" items? The flow needs to proceed both with or without a file attachment.

{

"type": "array",

"items": {

"type": "object",

"properties": {

"name": {

"type": "string"

"link": {

"type": "string"

"id": {

"type": "string"

"type": {},

"size": {

"type": "integer"

"referenceId": {

"type": "string"

"driveId": {

"type": "string"

"status": {

"type": "integer"

"uploadSessionUrl": {}

"required": [

"name",

"link",

"id",

"type",

"size",

"referenceId",

"driveId",

"status",

"uploadSessionUrl"

]

}

All responses (5)

Answers (1)

Matthy79 4,178 Super User 2024 Season 1 on at

Like (0)

Report

Re: Parse Json to include Null?
hmenzel 23 on at

Like (0)

Report

Re: Parse Json to include Null?

Ah, okay. Where would I add this exactly?
Verified answer

Matthy79 4,178 Super User 2024 Season 1 on at

Like (0)

Report
Re: Parse Json to include Null?

Ok, now I think I got it. You don't need the change the schema. The content is the problem. You could use this function in the content to solve the problem.

coalesce(null, json('[]'))

Instead of null you have to put in whatever is currently in the content field.
hmenzel 23 on at

Like (0)

Report

Re: Parse Json to include Null?

Thanks for the suggestion. I added those (see below), but it still produced an error "Unable to process template language expressions in action 'Parse_JSON' inputs at line '0' and column '0': 'Required property 'content' expects a value but got null. Path ''.'." Any other ideas?

{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "name": {
                "type": [
                    "string",
                    "null"
                ]
            },
            "link": {
                "type": [
                    "string",
                    "null"
                ]
            },
            "id": {
                "type": [
                    "string",
                    "null"
                ]
            },
            "type": {},
            "size": {
                "type": "integer"
            },
            "referenceId": {
                "type": "string"
            },
            "driveId": {
                "type": "string"
            },
            "status": {
                "type": "integer"
            },
            "uploadSessionUrl": {}
        },
        "required": [
            "name",
            "link",
            "id",
            "type",
            "size",
            "referenceId",
            "driveId",
            "status",
            "uploadSessionUrl"
        ]
    }
}
Matthy79 4,178 Super User 2024 Season 1 on at

Like (0)

Report

Re: Parse Json to include Null?

Not sure if I understood the question correct but you can change the type to an array and add the possibility to allow null.

change the type from

"type": "string"

to

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

Community site session details

Parse Json to include Null?

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Parse Json to include Null?

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates