(Again in Flow) Error : "message": "Invalid type. Expected Object but got Array." while trying to Convert an Array of Objetc to a single String with a single field from each object

[OSBSoto]

Hi everyone, I know this is a topic that comes with frequency at the forums, I had read many threats with the same topic, but still haven't figure how to solve this so I'm just publishing my very exact scenario.

Main Objective: Concatenate an N<=31 "Numbers" into a single string separating them with commas in order to Send an Email with that single line, instead of N emails each with a different "Number".

First, I had a PowerApp that register on a SharePoint List.

On the SharePoint List, two different columns have Choice with Select Multiple Items available (corresponding to months and days in number format). With the PowerApp it works nicely without any flaws and stores in the SPL steamy.

Second, there is a Flow that "When an item is created" that goes like this:

And with the Parse JSON (I'm not good at all using JSONs) got this created from the "Dias de Cobertura" auto-generated schema, but still haven't been able to put it to work.,,

{

    "type": "object",

    "properties": {

        "type": {

            "type": "string"

        },

        "properties": {

            "type": "object",

            "properties": {

                "Id": {

                    "type": "object",

                    "properties": {

                        "type": {

                            "type": "string"

                        }

                    }

                },

                "Value": {

                    "type": "object",

                    "properties": {

                        "type": {

                            "type": "string"

                        }

                    }

                },

                "@@odata.type": {

                    "type": "object",

                    "properties": {

                        "type": {

                            "type": "string"

                        }

                    }

                }

            }

        }

    }

}

But in the end, fails. any advice to solve this?

[abm]

Hi @OSBSoto 

Which step you having errors please?

Thanks

[OSBSoto]

Parsing the JSON and trying to Append it to the string variable

[abm · Accepted solution]

Hi @OSBSoto 

Your schema is not quite right. Its an arrary you iterating and make sure generate the right schema. Then append to an array each values.

Thanks

[OSBSoto]

Thanks you for the support; it helped a lot.