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))
            }
        )
    )    
)
 
Zrzut ekranu 2024-12-17 o 12.23.10.png
Zrzut ekranu 2024-12-17 o 12.22.57.png
Categories:
I have the same question (0)
  • 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  
  • Michael E. Gernaey Profile Picture
    53,692 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.

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
Kalathiya Profile Picture

Kalathiya 421

#2
WarrenBelz Profile Picture

WarrenBelz 365 Most Valuable Professional

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 339 Super User 2025 Season 2

Last 30 days Overall leaderboard