You’re offline. This is a read only version of the page.
I want to parse json the response from a array variable.
I create an array this way
I get the response like this:
Share
Report[
"[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?
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:
I hope this information is helpful. If it is, please consider giving a thumbs up.
Best regards,
Venkadesh Sundaramurthy
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"}
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
All responses (
Answers (
