Answered

Powerapps controls behaviour with different data source

(0) Share

Report

Posted on by Rabbanisyed

259

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,

Categories:

Building Power Apps

All responses (12)

Answers (1)

Sort by

BCLS776 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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 259 on at

Like
a
(0)

Report
Copy link

Link copied!

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 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

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 259 on at

Like
a
(0)

Report
Copy link

Link copied!

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 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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 259 on at

Like
a
(0)

Report
Copy link

Link copied!

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 8,994 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@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 259 on at

Like
a
(0)

Report
Copy link

Link copied!

Get only TEXT, when i created a collection it converted in to table . is this possible to access the fields in the table.
BCLS776 8,994 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
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?
Rabbanisyed 259 on at

Like
a
(0)

Report
Copy link

Link copied!

i was missing the VALUE in the collection, now gallery loads the members, but intrestingly i am getting only 100 records instead of 800 is my below syntax is correct, what more i have to do to get all the records in the gallery, will be greatful for your time
ClearCollect(GetDLMembers,
Office365Groups.ListGroupMembers(Grouplist.Selected.ObjectId).value,
{'$top':999}
)