web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Parse JSON item is empty
Power Automate
Answered

Parse JSON item is empty

(0) ShareShare
ReportReport
Posted on by 33

Hello,

I'm receiving json data and I would like to parse it. I generate a schema from my data and parse it succesfully, but then when I try to create an Element to Sharepoint into a ForEach it crashes, saying that the item is empty.

 

Here is the error : 

ExpressionEvaluationFailed. The execution of template action 'Appliquer_à_chacun_2' failed: the result of the evaluation of 'foreach' expression '@body('Analyser_JSON_2')?['body']?['Items']' is of type 'Null'. The result must be a valid array.

qzfqfz.PNG

Could you help me ?

Categories:
I have the same question (0)
  • yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    Hi @AdrienBeaussier 

     

    Can you confirm that the 'Items' key is of type array and there elements being populated into it? 

     

    Can you share the schema you have used and some sample data?

  • AdrienBeaussier Profile Picture
    33 on at

    Hi @yashag2255 and thanks for your answer.

    Here is the schema

    Spoiler (Highlight to read)
    {
     "type": "object",
     "properties": {
     "statusCode": {
     "type": "integer"
     },
     "headers": {
     "type": "object",
     "properties": {
     "X-Frame-Options": {
     "type": "string"
     },
     "X-Content-Type-Options": {
     "type": "string"
     },
     "Strict-Transport-Security": {
     "type": "string"
     },
     "Cache-Control": {
     "type": "string"
     },
     "Date": {
     "type": "string"
     },
     "Set-Cookie": {
     "type": "string"
     },
     "Server": {
     "type": "string"
     },
     "X-Powered-By": {
     "type": "string"
     },
     "Content-Length": {
     "type": "string"
     },
     "Content-Type": {
     "type": "string"
     },
     "Expires": {
     "type": "string"
     }
     }
     },
     "body": {
     "type": "object",
     "properties": {
     "Items": {
     "type": "array",
     "items": {
     "type": "object",
     "properties": {
     "Title": {
     "type": "string"
     },
     "EscapedTitleWithID": {
     "type": "string"
     },
     "DisplayID": {
     "type": "string"
     },
     "ObjVer": {
     "type": "object",
     "properties": {
     "Version": {
     "type": "integer"
     },
     "VersionType": {
     "type": "integer"
     },
     "ID": {
     "type": "integer"
     },
     "Type": {
     "type": "integer"
     }
     }
     },
     "Class": {
     "type": "integer"
     },
     "CheckedOutAtUtc": {
     "type": "string"
     },
     "CheckedOutAt": {
     "type": "string"
     },
     "LastModifiedUtc": {
     "type": "string"
     },
     "LastModified": {
     "type": "string"
     },
     "ObjectCheckedOut": {
     "type": "boolean"
     },
     "ObjectCheckedOutToThisUser": {
     "type": "boolean"
     },
     "CheckedOutTo": {
     "type": "integer"
     },
     "SingleFile": {
     "type": "boolean"
     },
     "ThisVersionLatestToThisUser": {
     "type": "boolean"
     },
     "CreatedUtc": {
     "type": "string"
     },
     "Created": {
     "type": "string"
     },
     "Files": {
     "type": "array"
     },
     "VisibleAfterOperation": {
     "type": "boolean"
     },
     "PathInIDView": {
     "type": "string"
     },
     "LastModifiedDisplayValue": {
     "type": "string"
     },
     "CheckedOutAtDisplayValue": {
     "type": "string"
     },
     "CreatedDisplayValue": {
     "type": "string"
     },
     "ObjectVersionFlags": {
     "type": "integer"
     },
     "Score": {
     "type": "integer"
     },
     "LastAccessedByMe": {
     "type": "string"
     },
     "AccessedByMeUtc": {
     "type": "string"
     },
     "AccessedByMe": {
     "type": "string"
     },
     "ObjectGUID": {
     "type": "string"
     },
     "ObjectCapabilityFlags": {
     "type": "integer"
     },
     "ObjectFlags": {
     "type": "integer"
     },
     "propertyID": {
     "type": "integer"
     },
     "BaseProperties": {
     "type": "array"
     }
     },
     "required": [
     "Title",
     "EscapedTitleWithID",
     "DisplayID",
     "ObjVer",
     "Class",
     "CheckedOutAtUtc",
     "CheckedOutAt",
     "LastModifiedUtc",
     "LastModified",
     "ObjectCheckedOut",
     "ObjectCheckedOutToThisUser",
     "CheckedOutTo",
     "SingleFile",
     "ThisVersionLatestToThisUser",
     "CreatedUtc",
     "Created",
     "Files",
     "VisibleAfterOperation",
     "PathInIDView",
     "LastModifiedDisplayValue",
     "CheckedOutAtDisplayValue",
     "CreatedDisplayValue",
     "ObjectVersionFlags",
     "Score",
     "LastAccessedByMe",
     "AccessedByMeUtc",
     "AccessedByMe",
     "ObjectGUID",
     "ObjectCapabilityFlags",
     "ObjectFlags",
     "propertyID",
     "BaseProperties"
     ]
     }
     },
     "MoreResults": {
     "type": "boolean"
     }
     }
     }
     }
    }
    { "type": "object", "properties": { "statusCode": { "type": "integer" }, "headers": { "type": "object", "properties": { "X-Frame-Options": { "type": "string" }, "X-Content-Type-Options": { "type": "string" }, "Strict-Transport-Security": { "type": "string" }, "Cache-Control": { "type": "string" }, "Date": { "type": "string" }, "Set-Cookie": { "type": "string" }, "Server": { "type": "string" }, "X-Powered-By": { "type": "string" }, "Content-Length": { "type": "string" }, "Content-Type": { "type": "string" }, "Expires": { "type": "string" } } }, "body": { "type": "object", "properties": { "Items": { "type": "array", "items": { "type": "object", "properties": { "Title": { "type": "string" }, "EscapedTitleWithID": { "type": "string" }, "DisplayID": { "type": "string" }, "ObjVer": { "type": "object", "properties": { "Version": { "type": "integer" }, "VersionType": { "type": "integer" }, "ID": { "type": "integer" }, "Type": { "type": "integer" } } }, "Class": { "type": "integer" }, "CheckedOutAtUtc": { "type": "string" }, "CheckedOutAt": { "type": "string" }, "LastModifiedUtc": { "type": "string" }, "LastModified": { "type": "string" }, "ObjectCheckedOut": { "type": "boolean" }, "ObjectCheckedOutToThisUser": { "type": "boolean" }, "CheckedOutTo": { "type": "integer" }, "SingleFile": { "type": "boolean" }, "ThisVersionLatestToThisUser": { "type": "boolean" }, "CreatedUtc": { "type": "string" }, "Created": { "type": "string" }, "Files": { "type": "array" }, "VisibleAfterOperation": { "type": "boolean" }, "PathInIDView": { "type": "string" }, "LastModifiedDisplayValue": { "type": "string" }, "CheckedOutAtDisplayValue": { "type": "string" }, "CreatedDisplayValue": { "type": "string" }, "ObjectVersionFlags": { "type": "integer" }, "Score": { "type": "integer" }, "LastAccessedByMe": { "type": "string" }, "AccessedByMeUtc": { "type": "string" }, "AccessedByMe": { "type": "string" }, "ObjectGUID": { "type": "string" }, "ObjectCapabilityFlags": { "type": "integer" }, "ObjectFlags": { "type": "integer" }, "propertyID": { "type": "integer" }, "BaseProperties": { "type": "array" } }, "required": [ "Title", "EscapedTitleWithID", "DisplayID", "ObjVer", "Class", "CheckedOutAtUtc", "CheckedOutAt", "LastModifiedUtc", "LastModified", "ObjectCheckedOut", "ObjectCheckedOutToThisUser", "CheckedOutTo", "SingleFile", "ThisVersionLatestToThisUser", "CreatedUtc", "Created", "Files", "VisibleAfterOperation", "PathInIDView", "LastModifiedDisplayValue", "CheckedOutAtDisplayValue", "CreatedDisplayValue", "ObjectVersionFlags", "Score", "LastAccessedByMe", "AccessedByMeUtc", "AccessedByMe", "ObjectGUID", "ObjectCapabilityFlags", "ObjectFlags", "propertyID", "BaseProperties" ] } }, "MoreResults": { "type": "boolean" } } } } }

    And a data sample :

    Spoiler (Highlight to read)
    {
     "Items": [
     {
     "Title": "13910-JOHN-DOE",
     "EscapedTitleWithID": "13910-JOHN-DOE (ID 171-175)",
     "DisplayID": "21312",
     "ObjVer": {
     "Version": 45,
     "VersionType": 5,
     "ID": 75,
     "Type": 786
     },
     "Class": 2,
     "CheckedOutAtUtc": "1601-01-01T00:00:00Z",
     "CheckedOutAt": "1601-01-01T00:00:00Z",
     "LastModifiedUtc": "2019-03-06T16:28:32Z",
     "LastModified": "2019-03-06T16:28:32Z",
     "ObjectCheckedOut": false,
     "ObjectCheckedOutToThisUser": false,
     "CheckedOutTo": 0,
     "SingleFile": false,
     "ThisVersionLatestToThisUser": true,
     "CreatedUtc": "2015-03-12T15:23:00Z",
     "Created": "2015-03-12T15:23:00Z",
     "Files": [],
     "VisibleAfterOperation": true,
     "PathInIDView": "101\\1-1000\\1205\\S\\v22",
     "LastModifiedDisplayValue": "06/03/2019 16:28",
     "CheckedOutAtDisplayValue": "01/01/1601 00:00",
     "CreatedDisplayValue": "12/03/2015 15:23",
     "ObjectVersionFlags": 2,
     "Score": 0,
     "LastAccessedByMe": "0001-01-01T00:00:00Z",
     "AccessedByMeUtc": "2019-01-03T10:56:24Z",
     "AccessedByMe": "2019-01-03T10:56:24Z",
     "ObjectGUID": "{E3018967-C1D5-4206-BFC1-0A7292FBBB8C}",
     "ObjectCapabilityFlags": -1,
     "ObjectFlags": 68,
     "propertyID": 0,
     "BaseProperties": []
     }
     ],
     "MoreResults": false
    }
    { "Items": [ { "Title": "13910-JOHN-DOE", "EscapedTitleWithID": "13910-JOHN-DOE (ID 171-175)", "DisplayID": "21312", "ObjVer": { "Version": 45, "VersionType": 5, "ID": 75, "Type": 786 }, "Class": 2, "CheckedOutAtUtc": "1601-01-01T00:00:00Z", "CheckedOutAt": "1601-01-01T00:00:00Z", "LastModifiedUtc": "2019-03-06T16:28:32Z", "LastModified": "2019-03-06T16:28:32Z", "ObjectCheckedOut": false, "ObjectCheckedOutToThisUser": false, "CheckedOutTo": 0, "SingleFile": false, "ThisVersionLatestToThisUser": true, "CreatedUtc": "2015-03-12T15:23:00Z", "Created": "2015-03-12T15:23:00Z", "Files": [], "VisibleAfterOperation": true, "PathInIDView": "101\\1-1000\\1205\\S\\v22", "LastModifiedDisplayValue": "06/03/2019 16:28", "CheckedOutAtDisplayValue": "01/01/1601 00:00", "CreatedDisplayValue": "12/03/2015 15:23", "ObjectVersionFlags": 2, "Score": 0, "LastAccessedByMe": "0001-01-01T00:00:00Z", "AccessedByMeUtc": "2019-01-03T10:56:24Z", "AccessedByMe": "2019-01-03T10:56:24Z", "ObjectGUID": "{E3018967-C1D5-4206-BFC1-0A7292FBBB8C}", "ObjectCapabilityFlags": -1, "ObjectFlags": 68, "propertyID": 0, "BaseProperties": [] } ], "MoreResults": false }
  • Verified answer
    yashag2255 Profile Picture
    24,769 Super User 2024 Season 1 on at

    Hi @AdrienBeaussier 

     

    I carried out a test on my side and it seems that the schema is not matched based on the sample data provided by you.
    Can you try to use below schema:
     
    {
        "type": "object",
        "properties": {
            "Items": {
                "type": "array",
                "items": {
                    "type": "object",
                    "properties": {
                        "Title": {
                            "type": "string"
                        },
                        "EscapedTitleWithID": {
                            "type": "string"
                        },
                        "DisplayID": {
                            "type": "string"
                        },
                        "ObjVer": {
                            "type": "object",
                            "properties": {
                                "Version": {
                                    "type": "integer"
                                },
                                "VersionType": {
                                    "type": "integer"
                                },
                                "ID": {
                                    "type": "integer"
                                },
                                "Type": {
                                    "type": "integer"
                                }
                            }
                        },
                        "Class": {
                            "type": "integer"
                        },
                        "CheckedOutAtUtc": {
                            "type": "string"
                        },
                        "CheckedOutAt": {
                            "type": "string"
                        },
                        "LastModifiedUtc": {
                            "type": "string"
                        },
                        "LastModified": {
                            "type": "string"
                        },
                        "ObjectCheckedOut": {
                            "type": "boolean"
                        },
                        "ObjectCheckedOutToThisUser": {
                            "type": "boolean"
                        },
                        "CheckedOutTo": {
                            "type": "integer"
                        },
                        "SingleFile": {
                            "type": "boolean"
                        },
                        "ThisVersionLatestToThisUser": {
                            "type": "boolean"
                        },
                        "CreatedUtc": {
                            "type": "string"
                        },
                        "Created": {
                            "type": "string"
                        },
                        "Files": {
                            "type": "array"
                        },
                        "VisibleAfterOperation": {
                            "type": "boolean"
                        },
                        "PathInIDView": {
                            "type": "string"
                        },
                        "LastModifiedDisplayValue": {
                            "type": "string"
                        },
                        "CheckedOutAtDisplayValue": {
                            "type": "string"
                        },
                        "CreatedDisplayValue": {
                            "type": "string"
                        },
                        "ObjectVersionFlags": {
                            "type": "integer"
                        },
                        "Score": {
                            "type": "integer"
                        },
                        "LastAccessedByMe": {
                            "type": "string"
                        },
                        "AccessedByMeUtc": {
                            "type": "string"
                        },
                        "AccessedByMe": {
                            "type": "string"
                        },
                        "ObjectGUID": {
                            "type": "string"
                        },
                        "ObjectCapabilityFlags": {
                            "type": "integer"
                        },
                        "ObjectFlags": {
                            "type": "integer"
                        },
                        "propertyID": {
                            "type": "integer"
                        },
                        "BaseProperties": {
                            "type": "array"
                        }
                    },
                    "required": [
                        "Title",
                        "EscapedTitleWithID",
                        "DisplayID",
                        "ObjVer",
                        "Class",
                        "CheckedOutAtUtc",
                        "CheckedOutAt",
                        "LastModifiedUtc",
                        "LastModified",
                        "ObjectCheckedOut",
                        "ObjectCheckedOutToThisUser",
                        "CheckedOutTo",
                        "SingleFile",
                        "ThisVersionLatestToThisUser",
                        "CreatedUtc",
                        "Created",
                        "Files",
                        "VisibleAfterOperation",
                        "PathInIDView",
                        "LastModifiedDisplayValue",
                        "CheckedOutAtDisplayValue",
                        "CreatedDisplayValue",
                        "ObjectVersionFlags",
                        "Score",
                        "LastAccessedByMe",
                        "AccessedByMeUtc",
                        "AccessedByMe",
                        "ObjectGUID",
                        "ObjectCapabilityFlags",
                        "ObjectFlags",
                        "propertyID",
                        "BaseProperties"
                    ]
                }
            },
            "MoreResults": {
                "type": "boolean"
            }
        }
    }
     
    Hope this Helps!
     
    If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
  • v-alzhan-msft Profile Picture
    Microsoft Employee on at

    Hi @AdrienBeaussier ,

     

    I have made a test on my side, the schema should as below and you could take a try with it:

    {
     "type": "object",
     "properties": {
     "Items": {
     "type": "array",
     "items": {
     "type": "object",
     "properties": {
     "Title": {
     "type": "string"
     },
     "EscapedTitleWithID": {
     "type": "string"
     },
     "DisplayID": {
     "type": "string"
     },
     "ObjVer": {
     "type": "object",
     "properties": {
     "Version": {
     "type": "integer"
     },
     "VersionType": {
     "type": "integer"
     },
     "ID": {
     "type": "integer"
     },
     "Type": {
     "type": "integer"
     }
     }
     },
     "Class": {
     "type": "integer"
     },
     "CheckedOutAtUtc": {
     "type": "string"
     },
     "CheckedOutAt": {
     "type": "string"
     },
     "LastModifiedUtc": {
     "type": "string"
     },
     "LastModified": {
     "type": "string"
     },
     "ObjectCheckedOut": {
     "type": "boolean"
     },
     "ObjectCheckedOutToThisUser": {
     "type": "boolean"
     },
     "CheckedOutTo": {
     "type": "integer"
     },
     "SingleFile": {
     "type": "boolean"
     },
     "ThisVersionLatestToThisUser": {
     "type": "boolean"
     },
     "CreatedUtc": {
     "type": "string"
     },
     "Created": {
     "type": "string"
     },
     "Files": {
     "type": "array"
     },
     "VisibleAfterOperation": {
     "type": "boolean"
     },
     "PathInIDView": {
     "type": "string"
     },
     "LastModifiedDisplayValue": {
     "type": "string"
     },
     "CheckedOutAtDisplayValue": {
     "type": "string"
     },
     "CreatedDisplayValue": {
     "type": "string"
     },
     "ObjectVersionFlags": {
     "type": "integer"
     },
     "Score": {
     "type": "integer"
     },
     "LastAccessedByMe": {
     "type": "string"
     },
     "AccessedByMeUtc": {
     "type": "string"
     },
     "AccessedByMe": {
     "type": "string"
     },
     "ObjectGUID": {
     "type": "string"
     },
     "ObjectCapabilityFlags": {
     "type": "integer"
     },
     "ObjectFlags": {
     "type": "integer"
     },
     "propertyID": {
     "type": "integer"
     },
     "BaseProperties": {
     "type": "array"
     }
     },
     "required": [
     "Title",
     "EscapedTitleWithID",
     "DisplayID",
     "ObjVer",
     "Class",
     "CheckedOutAtUtc",
     "CheckedOutAt",
     "LastModifiedUtc",
     "LastModified",
     "ObjectCheckedOut",
     "ObjectCheckedOutToThisUser",
     "CheckedOutTo",
     "SingleFile",
     "ThisVersionLatestToThisUser",
     "CreatedUtc",
     "Created",
     "Files",
     "VisibleAfterOperation",
     "PathInIDView",
     "LastModifiedDisplayValue",
     "CheckedOutAtDisplayValue",
     "CreatedDisplayValue",
     "ObjectVersionFlags",
     "Score",
     "LastAccessedByMe",
     "AccessedByMeUtc",
     "AccessedByMe",
     "ObjectGUID",
     "ObjectCapabilityFlags",
     "ObjectFlags",
     "propertyID",
     "BaseProperties"
     ]
     }
     },
     "MoreResults": {
     "type": "boolean"
     }
     }
    }

    You could Use sample payload to generate schema in the Parse JSON action and insert the Data sample in it as below:

    1.png2.png

    And the flow would run successfully as below:

    3.png

     

    Best regards,

    Alice       

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • AdrienBeaussier Profile Picture
    33 on at

    Thanks for your answers.

    Unfortunately I gave you a wrong data sample, I missed the header. I used JSON Parsing in other Flows and it worked well, but it seems that with the actual payload, the schema generated is wrong.

    {
     "statusCode": 200,
     "headers": {
     "X-Frame-Options": "SAMEORIGIN",
     "X-Content-Type-Options": "nosniff",
     "Strict-Transport-Security": "max-age=31536000; includeSubDomains;",
     "Cache-Control": "must-revalidate, max-age=0, private",
     "Date": "Wed, 31 Jul 2019 07:12:53 GMT",
     "Set-Cookie": "ASP.NET_SessionId=zqfzqggl8; path=/; secure; HttpOnly",
     "Server": "",
     "X-Powered-By": "",
     "Content-Length": "730340",
     "Content-Type": "application/json; charset=utf-8",
     "Expires": "Mon, 30 Jul 2018 07:12:53 GMT"
     },
     "body": {
     "Items": [
     {
     "Title": "1457348-JOHN-DOE",
     "EscapedTitleWithID": "14348-JOHN-DOE(ID 101-2600)",
     "DisplayID": "144756348",
     "ObjVer": {
     "Version": 14,
     "VersionType": 4,
     "ID": 2600,
     "Type": 101
     },
     "Class": 2,
     "CheckedOutAtUtc": "1601-01-01T00:00:00Z",
     "CheckedOutAt": "1601-01-01T00:00:00Z",
     "LastModifiedUtc": "2019-07-27T02:30:04Z",
     "LastModified": "2019-07-27T02:30:04Z",
     "ObjectCheckedOut": false,
     "ObjectCheckedOutToThisUser": false,
     "CheckedOutTo": 0,
     "SingleFile": false,
     "ThisVersionLatestToThisUser": true,
     "CreatedUtc": "2017-01-18T03:30:00Z",
     "Created": "2017-01-18T03:30:00Z",
     "Files": [],
     "VisibleAfterOperation": true,
     "PathInIDView": "101\\2-1001\\2600\\S\\v14",
     "LastModifiedDisplayValue": "27/07/2019 02:30",
     "CheckedOutAtDisplayValue": "01/01/1601 00:00",
     "CreatedDisplayValue": "18/01/2017 03:30",
     "ObjectVersionFlags": 0,
     "Score": 0,
     "LastAccessedByMe": "0001-01-01T00:00:00Z",
     "AccessedByMeUtc": "2019-01-03T10:56:30Z",
     "AccessedByMe": "2019-01-03T10:56:30Z",
     "ObjectGUID": "{D4F660C1-B0E1-4B48-B080-32AC0BEEBFD9}",
     "ObjectCapabilityFlags": -1,
     "ObjectFlags": 68,
     "propertyID": 0,
     "BaseProperties": []
     },
     {
     "Title": "250440-PAUL",
     "EscapedTitleWithID": "25056-PAUL (ID 101-650)",
     "DisplayID": "2500",
     "ObjVer": {
     "Version": 30,
     "VersionType": 4,
     "ID": 650,
     "Type": 101
     },
     "Class": 2,
     "CheckedOutAtUtc": "1601-01-01T00:00:00Z",
     "CheckedOutAt": "1601-01-01T00:00:00Z",
     "LastModifiedUtc": "2019-07-27T02:30:03Z",
     "LastModified": "2019-07-27T02:30:03Z",
     "ObjectCheckedOut": false,
     "ObjectCheckedOutToThisUser": false,
     "CheckedOutTo": 0,
     "SingleFile": false,
     "ThisVersionLatestToThisUser": true,
     "CreatedUtc": "2014-06-05T14:47:00Z",
     "Created": "2014-06-05T14:47:00Z",
     "Files": [],
     "VisibleAfterOperation": true,
     "PathInIDView": "101\\0-999\\650\\S\\v30",
     "LastModifiedDisplayValue": "27/07/2019 02:30",
     "CheckedOutAtDisplayValue": "01/01/1601 00:00",
     "CreatedDisplayValue": "05/06/2014 14:47",
     "ObjectVersionFlags": 2,
     "Score": 0,
     "LastAccessedByMe": "0001-01-01T00:00:00Z",
     "AccessedByMeUtc": "1899-12-30T00:00:00Z",
     "AccessedByMe": "1899-12-30T00:00:00Z",
     "ObjectGUID": "{58CBAEB0-B58C-4923-938E-FA06A3DEA918}",
     "ObjectCapabilityFlags": -1,
     "ObjectFlags": 64,
     "propertyID": 0,
     "BaseProperties": []
     },
     {
     "Title": "211550-JANE",
     "EscapedTitleWithID": "2110-JANE (ID 101-2729)",
     "DisplayID": "2110",
     "ObjVer": {
     "Version": 94,
     "VersionType": 44,
     "ID": 27429,
     "Type": 1041
     },
     "Class": 2,
     "CheckedOutAtUtc": "1601-01-01T00:00:00Z",
     "CheckedOutAt": "1601-01-01T00:00:00Z",
     "LastModifiedUtc": "2019-07-30T02:30:06Z",
     "LastModified": "2019-07-30T02:30:06Z",
     "ObjectCheckedOut": false,
     "ObjectCheckedOutToThisUser": false,
     "CheckedOutTo": 0,
     "SingleFile": false,
     "ThisVersionLatestToThisUser": true,
     "CreatedUtc": "2018-07-07T02:29:00Z",
     "Created": "2018-07-07T02:29:00Z",
     "Files": [],
     "VisibleAfterOperation": true,
     "PathInIDView": "101\\2-1001\\2729\\S\\v9",
     "LastModifiedDisplayValue": "30/07/2019 02:30",
     "CheckedOutAtDisplayValue": "01/01/1601 00:00",
     "CreatedDisplayValue": "07/07/2018 02:29",
     "ObjectVersionFlags": 0,
     "Score": 0,
     "LastAccessedByMe": "0001-01-01T00:00:00Z",
     "AccessedByMeUtc": "1899-12-30T00:00:00Z",
     "AccessedByMe": "1899-12-30T00:00:00Z",
     "ObjectGUID": "{504039CB-F881-4C20-8232-B66D87B9DA62}",
     "ObjectCapabilityFlags": -1,
     "ObjectFlags": 64,
     "propertyID": 0,
     "BaseProperties": []
     }
     ],
     "MoreResults": false
     }
    }



  • v-alzhan-msft Profile Picture
    Microsoft Employee on at

    Hi @AdrienBeaussier ,

     

    You could also use sample payload to generate schema in the Parse JSON action and insert the Data sample in it as my solutions.

     

    Have your problem been solved according to my solution?  If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

     

    Best regards,

    Alice       

     

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • AdrienBeaussier Profile Picture
    33 on at

    Hi @v-alzhan-msft 

     

    Actually thats what I've been trying to do since the beginning. Use my data to automatically generate a schema.
    But with this schema it won't work, and I don't know why

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 250 Super User 2026 Season 1

#2
Expiscornovus Profile Picture

Expiscornovus 222 Most Valuable Professional

#3
Haque Profile Picture

Haque 174

Last 30 days Overall leaderboard