For Each Row in JSON Aray create Share point Item

[Chiders]

I'm to extract the data from a Aray, and cycle through each row.

However my current set up retuns blank from each Item.

I've tried "for each, create variable" however this just returned Null's

JSON Output example:

{

    "body": [

        {

            "Spread": "3",

            "Logger ID": "2742003651",

            "Adress": "53 fewcett lane, leeds ls124pg",

            "Logger Status": "Leak",

            "Leak Date": "30/06/2021",

            "Reason For Alarm": "Job(s) raised",

            "Correlated?": "Yes",

            "Sounded?": "Yes",

            "Comments": "1",

            "Order": "Morec",

            "DMA": "G077 COTTINGLEY",

            "Date": "23/07",

            "Level": "31"

        },

        {

            "Spread": "6",

            "Logger ID": "10042010333",

            "Adress": "20 Windmill Ct, Leeds LS12 4WB, UK",

            "Logger Status": "Leak",

            "Leak Date": "19/06/2021",

            "Reason For Alarm": "Job(s) raised",

            "Correlated?": "Yes",

            "Sounded?": "Yes",

            "Comments": "1",

            "Order": "Morec",

            "DMA": "G077 COTTINGLEY",

            "Date": "23/07",

            "Level": "29"

        },

Share Point:

[v-bofeng-msft · Accepted solution]

Hi @Chiders :

I've made a test but it worked well on my side:

My List:

My Flow:

Content:

{
    "body": [
        {
            "Spread": "3",
            "Logger ID": "2742003651",
            "Adress": "53 fewcett lane, leeds ls124pg",
            "Logger Status": "Leak",
            "Leak Date": "30/06/2021",
            "Reason For Alarm": "Job(s) raised",
            "Correlated?": "Yes",
            "Sounded?": "Yes",
            "Comments": "1",
            "Order": "Morec",
            "DMA": "G077 COTTINGLEY",
            "Date": "23/07",
            "Level": "31"
        },
        {
            "Spread": "6",
            "Logger ID": "10042010333",
            "Adress": "20 Windmill Ct, Leeds LS12 4WB, UK",
            "Logger Status": "Leak",
            "Leak Date": "19/06/2021",
            "Reason For Alarm": "Job(s) raised",
            "Correlated?": "Yes",
            "Sounded?": "Yes",
            "Comments": "1",
            "Order": "Morec",
            "DMA": "G077 COTTINGLEY",
            "Date": "23/07",
            "Level": "29"
        }]
}

Schema:

{
    "type": "object",
    "properties": {
        "body": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "Spread": {
                        "type": "string"
                    },
                    "Logger ID": {
                        "type": "string"
                    },
                    "Adress": {
                        "type": "string"
                    },
                    "Logger Status": {
                        "type": "string"
                    },
                    "Leak Date": {
                        "type": "string"
                    },
                    "Reason For Alarm": {
                        "type": "string"
                    },
                    "Correlated?": {
                        "type": "string"
                    },
                    "Sounded?": {
                        "type": "string"
                    },
                    "Comments": {
                        "type": "string"
                    },
                    "Order": {
                        "type": "string"
                    },
                    "DMA": {
                        "type": "string"
                    },
                    "Date": {
                        "type": "string"
                    },
                    "Level": {
                        "type": "string"
                    }
                },
                "required": [
                    "Spread",
                    "Logger ID",
                    "Adress",
                    "Logger Status",
                    "Leak Date",
                    "Reason For Alarm",
                    "Correlated?",
                    "Sounded?",
                    "Comments",
                    "Order",
                    "DMA",
                    "Date",
                    "Level"
                ]
            }
        }
    }
}

The Result:

• I noticed that you may have more than one Parse JSON action, please make sure that the Body of Apply to each 3 is correct
• Please check the Schema or check the data structure of the SP list

Best Regards,

Bof