Power Platform Community Forum Thread Details

I've been hacking my way through Parse JSON schema and Create Item. I have this schema and need one item to show up as a choise in create item. I see most of the items I need exept for "members". Members is an array also. The Apply to each I'm using "body('ParseJSONGroups')?['Objects']" for output from previous step.

The schema is down below.

{
    "type": "object",
    "properties": {
        "objects": {
            "type": "array",
            "items": {
                "type": "object",
                "properties": {
                    "uid": {
                        "type": "string"
                    },
                    "name": {
                        "type": "string"
                    },
                    "type": {
                        "type": "string"
                    },
                    "domain": {
                        "type": "object",
                        "properties": {
                            "uid": {
                                "type": "string"
                            },
                            "name": {
                                "type": "string"
                            },
                            "domain-type": {
                                "type": "string"
                            }
                        }
                    },
                    "members": {                   -----------------------------Here
                        "type": "array",
                        "items": {
                            "type": "string"
                        }
                    },
                    "comments": {
                        "type": "string"
                    },
                    "color": {
                        "type": "string"
                    },
                    "icon": {
                        "type": "string"
                    },
                    "tags": {
                        "type": "array"
                    },
                    "meta-info": {
                        "type": "object",
                        "properties": {
                            "lock": {
                                "type": "string"
                            },
                            "validation-state": {
                                "type": "string"
                            },
                            "last-modify-time": {
                                "type": "object",
                                "properties": {
                                    "posix": {
                                        "type": "integer"
                                    },
                                    "iso-8601": {
                                        "type": "string"
                                    }
                                }
                            },
                            "last-modifier": {
                                "type": "string"
                            },
                            "creation-time": {
                                "type": "object",
                                "properties": {
                                    "posix": {
                                        "type": "integer"
                                    },
                                    "iso-8601": {
                                        "type": "string"
                                    }
                                }
                            },
                            "creator": {
                                "type": "string"
                            }
                        }
                    },
                    "read-only": {
                        "type": "boolean"
                    },
                    "available-actions": {
                        "type": "object",
                        "properties": {
                            "edit": {
                                "type": "string"
                            },
                            "delete": {
                                "type": "string"
                            },
                            "clone": {
                                "type": "string"
                            }
                        }
                    }
                },
                "required": [
                    "uid",
                    "name",
                    "type",
                    "domain",
                    "members",
                    "comments",
                    "color",
                    "icon",
                    "tags",
                    "meta-info",
                    "read-only",
                    "available-actions"
                ]
            }
        }
    }
}

Categories:

Building flows

Hi @wlyttle,

If your intenstion is to hack and get members, can you please initialize an array variable before the loops, then append each member item inside the nested loop? After the loops complete, you will have a flat array of all members, which you can then use as choices in your "Create item" action.

Then these are your steps to separate the members:

Loop over body('ParseJSONGroups')?['Objects'] (outer loop).
Inside that, loop over items('Apply_to_each')?['members'] (inner loop).
Append each member to an array variable.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!