Help with Parse/Join

[calcag]

Hello,

I'm building a flow to run a search on a SPO list and return it to Power Apps, and can't figure out why I'm getting an error at "Join"action 

The flow

I ran a test and used the result as a schema model for parse action, it's like this:

{
    "type": "object",
    "properties": {
        "value": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "Id": {
                        "type": "integer"
                    },
                    "Title": {
                        "type": "string"
                    },
                    "Demandstatus": {
                        "type": "string"
                    },
                    "ID": {
                        "type": "integer"
                    }
                }
            }
        }
    }
}

Any suggestions?

[calcag · Accepted solution]

Update: I figured out what was happening, just changed the input of Join action to "value" instead of "body"

[v-litu-msft]

Hi @calcag,

I am glad your issue has been solved by yourself.
If your problem has been solved, You could 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,
Community Support Team _ Lin Tu