Graph SDK | .orderBy not working in B2C tenants

Question

Hi,

I would like to read out all users with the Microsoft Graph SDK (Typescript) and get them sorted by the "createdDateTime".

In normal Azure tenants this works without any problems, but in a B2C tenant it does not work so far.

This is how my query looks:

let response = await client.api('/users')

                .count(true)

                .header('ConsistencyLevel','eventual')

                .filter(`createdDateTime ge 2023-01-01T00:00:00Z and createdDateTime le 2023-12-31T23:59:59Z`)

                .select('userPrincipalName, createdDateTime, mail, id, displayName')

                .orderby('createdDateTime')

                .top(100)

                .get();

• Am I doing something wrong?
• Or does this really not work for B2C clients?

If I remove the .orderby its working - but I really need this.

Best regards

Diego

Answer 1

Hi @Diego

Sorting the set of users using the createdDateTime property is an advanced query, but advanced queries do not support Azure AD B2C tenants, so you cannot currently sort using the createdDateTime property for Azure AD B2C tenant users.

Hope this helps.

If the reply is helpful, please click Accept Answer and kindly upvote it. If you have additional questions about this answer, please click Comment.