Powerapps controls behaviour with different data source

[Rabbanisyed]

My app has 2 galleries 1 for getting the o365 distrubution list of exchange online. and the second display the members of the Distribution list. 

my project detail:

1. extract the 365 distribution groups i to a exel file and the imported in to sharepoint line as a list, this list is attached as items in gallery1 and i have enabled the scrollbars for the gallery to get the all the distribution list which fine till here

2. in second gallery2 i wanted to get the members of the distribution list whne user select any gallery1 item iam getting only the 100 users as i have 700+ users. how to acive this the gallery2 has a 365 connector

3. i understand that gallery control with sharepoint as a data source can load the records, but if other data soruce like excel or 365 connectors are used i will not getting all the records

i am attching the image 

the gallery1 is attached with SPlist and display the completed records 200

the gallery2 is attched with 365 connectors and load only 100 users insted of 769

This is related to exchange distribution lists, 

[BCLS776]

To keep performance acceptable, galleries do not always load all items initially and instead will wait until the user scrolls further down and then load more items.

To get around this, store your connector query into a collection (this will force it to perform the whole query) and then reference your collection in the gallery. 

Note, you can run into further limits on queries through non-delegable queries and the default limits for querying Sharepoint lists (500 items, which can be increased to 2000 items)

[Rabbanisyed]

What i have done is,  created a collection to store all the records then load to a new gallery3 to check whether i will get the full userlist but unfortunatley still loads 100 also set the maximum record to 2000  

ClearCollect(
GetDLmembers,
Office365Groups.ListGroupMembers(
(gallery1.Selected.ObjectId),
{'$top': 999}

)

but with the collection i am loading the All groups but not the members intrestingly i could not able to add the parameter(gallery1.Selected.ObjectId).value in the collection.

i hope explanation is clear tounderstand the scenario

[BCLS776]

Your syntax looks correct, and you should be able to pull 999 records without changing any settings. Time to raise this as a support issue with Microsoft?

[Rabbanisyed]

one more thing i would like to get help from you with the collection as shown above i am getting the records but it could not load in the gallery as it takes as a table. is their anyway to populate the Table in the gallery

i am attaching the image for your better understanding. thanks again for you responses👍

[BCLS776]

---

@Rabbanisyed wrote:

one more thing i would like to get help from you with the collection as shown above i am getting the records but it could not load in the gallery as it takes as a table. is their anyway to populate the Table in the gallery

i am attaching the image for your better understanding. thanks again for you responses👍

---

Yes, add .value to the Items property for the gallery and it will access the fields stored hierarchically below that.

[Rabbanisyed]

if you look at the below image i am getting only two properties value and Table, an the table has the fileds and i wanted to access the table to fetch the fields which is not getting in gallery

[BCLS776]

---

@Rabbanisyed wrote:

if you look at the below image i am getting only two properties value and Table, an the table has the fileds and i wanted to access the table to fetch the fields which is not getting in gallery

---

Have you checked out what you get when you type in GetDLmembers.value ?

[Rabbanisyed]

Get only TEXT, when i created a collection it converted in to table . is this possible to access the fields in the table.

[BCLS776]

I don't quite understand what you mean by "converted in to table", but here's what I am doing to get a usable list of people in a group:

I created a button with the following OnSelect code:

ClearCollect(colPeople,
    Office365Groups.ListGroupMembers(Label2.Text).value)
    // Label2.Text contains my Group ID

Then I can see the following when I inspect the collection colPeople:

The expression First(colPeople).displayName would bring up the first record's display name

Plugging colPeople into the Items property of a gallery creates a list of the individuals in the group

Are you getting something different than this?