Formatting data from Select variable or Parse Json

[andrewp3283]

HI

I have a flow that is getting data from two separate SP lists, one holds the Auditor information and the other holds the answers to the audit. the lists are connected by a reference number, i can get the data passed into flow when asking for a reference number, and when it generates the HTML the questions and answers are all coming out on one line, i can find where to format this to show the blow:

Current Output:

{"Question":"Where applicable has an F-10 been completed? is it readily available?","Answer":"Yes"},{"Question":"Where applicable is a CPHSP on site?","Answer":"Yes"},{"Question":"Is an up to date Health & Safety plan on site?","Answer":"Yes"},

Output Required:

Question: Where applicable has an F-10 been completed? is it readily available?

Answer:    Yes

Question: Where applicable is a CPHSP on site?

Answer:    Yes

Question:  Is an up to date Health & Safety plan on site?

Answer:    Yes

thanks for the help

[Naveen_772]

@andrewp3283  How this output is generated? I mean what is the format of the output is it String or an object?

Also, can you attach screenshots for your flow?

[andrewp3283]

Hope this helps, the first Get Items retrieves the record based on the refno entered,  the second Get Items then gets the questions and answers from the Answer list again based on the refno entered.

The compose HTML in the Apple to each 2 "body" element takes the output from the Parse JSON

[andrewp3283]

I have made some changes now but it is only exporting the first record not all of them, this is the Json for the parse Json in flow

{

    "type": "array",

    "items":{

        "type": "object",

        "properties":{

            "Question":{

                "type": "string"

            },

            "Answer":{

                "type": "string"

            }

        }

    }

}

it does what i want but on only the first record, i have this in a apply to each