Accessing Nested collection

[Gdog55]

So i have created a custom connection that access the sharepoint rest api to get sharepoint user group information.

The results produce a nested collection.  I cannot figure out how to access the data in the nested collection either in a table or looping through the items to concatenate a column like LoginName.

Thank you...

Button:ClearCollect(userGroupData,OpenAPIProgram.GetuserGroups("924","spar","application/json; odata=nometadata"))

json returned:

{
"value": [
{
"Id": 3,
"IsHiddenInUI": false,
"LoginName": "SharePoint Assistance Request Owners",
"Title": "SharePoint Assistance Request Owners",
"PrincipalType": 8,
"AllowMembersEditMembership": false,
"AllowRequestToJoinLeave": false,
"AutoAcceptRequestToJoinLeave": false,
"Description": "",
"OnlyAllowMembersViewMembership": true,
"OwnerTitle": "Nickerson, Samuel",
"RequestToJoinLeaveEmailSetting": ""
},
{
"Id": 5,
"IsHiddenInUI": false,
"LoginName": "SharePoint Assistance Request Visitors",
"Title": "SharePoint Assistance Request Visitors",
"PrincipalType": 8,
"AllowMembersEditMembership": false,
"AllowRequestToJoinLeave": false,
"AutoAcceptRequestToJoinLeave": false,
"Description": "",
"OnlyAllowMembersViewMembership": true,
"OwnerTitle": "SharePoint Assistance Request Owners",
"RequestToJoinLeaveEmailSetting": null
}
]
}

Collection CreatedRoot of collection
sub Collection

[Lisabel0]

You could try to open a support ticket here:

https://powerapps.microsoft.com/en-us/support/pro/ticket/

[TopShelf-MSFT]

hi @Gdog55 I'm sorry to hear about this issue but thank you for posting it in the forum. 

Please take a look at the following thread. It is not your exact scenario, but may include some helpful workarounds. If that does not help, please consider submitting a ticket using the link supplied above. 

https://powerusers.microsoft.com/t5/General-Discussion/Nested-gallery-trying-to-collect-data-from-1s...

@TopShelf-MSFT