cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rabbanisyed
Resolver II
Resolver II

Powerapps controls behaviour with different data source

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 

Rabbanisyed_0-1627211838777.png

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, 

 

1 ACCEPTED SOLUTION

Accepted Solutions

 

The issues is resolved... 

I got the results after struggling hours my syntaxt was wrong i used the following

ClearCollect(GetDlMembers,
Office365Groups.ListGroupMembers(Grouplist.Selected.ObjectId,{'$top':900}).value)

thanks for the time and response..  the people icon may call the collection and load the members if you look at bottom i have exact numbers 213 at both side one id from the o365 and other from the gallery ,

Rabbanisyed_0-1627494336475.png

 

View solution in original post

12 REPLIES 12
BCLS776
Community Champion
Community Champion

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)

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
Community Champion
Community Champion

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?

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👍

 

Rabbanisyed_0-1627285680171.png

 

BCLS776
Community Champion
Community Champion


@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👍

 

Rabbanisyed_0-1627285680171.png

 


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

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

 

Rabbanisyed_0-1627319675802.png

 

BCLS776
Community Champion
Community Champion


@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

 

Rabbanisyed_0-1627319675802.png

 


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

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

 

Rabbanisyed_0-1627320558683.png

 

BCLS776
Community Champion
Community Champion

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:

BCLS776_0-1627321513855.png

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?

 

 

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Users online (1,440)