cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Gdog55
Level: Powered On

Accessing Nested collection

 

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 CreatedCapture1.PNGRoot of collection
Capture2.PNGsub Collection

2 REPLIES 2
Lisabel0
Level 8

Re: Accessing Nested collection

You could try to open a support ticket here:

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

TopShelf-MSFT
Level 10

Re: Accessing Nested collection

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

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,682)