Unanswered

Graph API custom connector not returning all data.

(1) Share

Report

Posted on by Herbata

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:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Michael E. Gernaey 53,960 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Herbata

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.

Was this reply helpful? Yes No
DJ_Jamba 2,837 Moderator on at

Like (1)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No