web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Graph API custom conne...
Power Apps
Unanswered

Graph API custom connector not returning all data.

(1) ShareShare
ReportReport
Posted on by 7
Hey,
So I've made a custom connector to get user data (custom security attributes) from Entra ID, but after it's all set up, the data returned in my collection inside PowerApps is incomplete.
 
This query in Postman works just fine, and returns all data:
https://graph.microsoft.com/v1.0/users/?$select=id,displayName,companyName,customSecurityAttributes,accountEnabled&$filter=companyName eq 'Comtegra S.A.'&$count=true
+ header: ConsistencyLevel: eventual
 
However when I try it with the same query in PowerApps, it stops about 3/4ths of the way.
This is how it's set up:
Clear(colFilteredOutUsers);
Clear(colUsers);
ForAll(GetuserfromEntraID.APIcall({ConsistencyLevel: "eventual",'$select':"id,displayName,companyName,customSecurityAttributes,accountEnabled", '$filter':"companyName eq 'Comtegra S.A.'",'$count': "true"}).value As GraphAPI,
    If(And(IsBlank(GraphAPI.customSecurityAttributes),GraphAPI.accountEnabled),
        Collect(colUsers,
            {
                ID: Text(GraphAPI.id),
                displayName: Text(GraphAPI.displayName),
                companyName: Text(GraphAPI.companyName),
                accountEnabled: Boolean(GraphAPI.accountEnabled),
                customAttrib: Boolean(IsBlank(GraphAPI.customSecurityAttributes))
            }
        ),
        Collect(colFilteredOutUsers,
            {
                ID: Text(GraphAPI.id),
                displayName: Text(GraphAPI.displayName),
                companyName: Text(GraphAPI.companyName),
                accountEnabled: Boolean(GraphAPI.accountEnabled),
                customAttrib: Boolean(IsBlank(GraphAPI.customSecurityAttributes))
            }
        )
    )    
)
 
Categories:
I have the same question (0)
  • Michael E. Gernaey Profile Picture
    53,433 Super User 2025 Season 2 on at
     
    How many rows are in the table that PostMan returns?
     
    Do you have more than 500? and it stops at 500 or do you have more than 2000 and it stops at 2000 or at 5000?
     
    You are probably looking at either a delegation issue, or you are looking a pagination issue in your custom connector.
  • DJ_Jamba Profile Picture
    2,837 Super User 2025 Season 2 on at
    As mentioned by @Michael E. Gernaey you need to cycle through the results using pagination and Do until.
    Add a top parameter e.g.
     
    ForAll(GetuserfromEntraID.APIcall({ConsistencyLevel: "eventual",'$select':"id,displayName,companyName,customSecurityAttributes,accountEnabled", '$filter':"companyName eq 'Comtegra S.A.'&$top=999",'$count': "true"}).value As GraphAPI
    ...and the results from the API will have something like a NextLink parameter which you use to get the next batch.

    Do Until the NextLink parameter is empty  

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 739 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 343 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard