Create a valid JSON from append to array?

(0) Share

Report

Posted on by Oskarkuus

1,097

I want to parse json the response from a array variable.

I create an array this way

I get the response like this:

[
 "[filename: l1,fileextension: l1.jpg,fileID:281]",
 "[filename: l2,fileextension: l2.jpg,fileID:282]",
 "[filename: l5,fileextension: l5.jpg,fileID:283]",
 "[filename: l3,fileextension: l3.jpg,fileID:284]",
 "[filename: l1,fileextension: l1.jpg,fileID:281]",
 "[filename: l2,fileextension: l2.jpg,fileID:282]",
 "[filename: l5,fileextension: l5.jpg,fileID:283]",
 "[filename: l3,fileextension: l3.jpg,fileID:284]",
 "[filename: l1,fileextension: l1.jpg,fileID:281]",
 "[filename: l2,fileextension: l2.jpg,fileID:282]",
 "[filename: l5,fileextension: l5.jpg,fileID:283]",
 "[filename: l3,fileextension: l3.jpg,fileID:284]",
 "[filename: l1,fileextension: l1.jpg,fileID:281]",
 "[filename: l2,fileextension: l2.jpg,fileID:282]",
 "[filename: l5,fileextension: l5.jpg,fileID:283]",
 "[filename: l3,fileextension: l3.jpg,fileID:284]"
]

But when i try to create a parse json and try to create a schema

power automate generate this schema:

{
 "type": "array",
 "items": {
 "type": "string"
 }
}

And that schema does not give me any dynamic options.

How to generate a standard json schema from my array?

Categories:

General topics

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Chriddle 8,436 Super User 2025 Season 2 on at

Like (1)

Report

Your appended value is a string, that's why you don't get the intended schema.
Replace [ and ] with { and } and set the " accordingly
to append an object like this:

{"filename": "Value_from_dynamic _content1", "fileextension": "Value_from_dynamic _content2", "fileID": "Value_from_dynamic _content3"}

Was this reply helpful? Yes No
S-Venkadesh 925 Moderator on at

Like (1)

Report

Hi @Oskarkuus ,
Create a File object as below, add it to Array an then generate the schema from the output.
{
"filename": "abc",
"fileId": "001"
}

you schema will look like this:
{
    "type": "array",
    "items": {
        "type": "object",
        "properties": {
            "filename": {
                "type": "string"
            },
            "fileId": {
                "type": "string"
            }
        },
        "required": [
            "filename",
            "fileId"
        ]
    }
}

I hope this information is helpful. If it is, please consider giving a thumbs up.

Best regards,
Venkadesh Sundaramurthy

Was this reply helpful? Yes No