Graph API查询：解决属性报错并组合STARTS WITH与NOT运算符

1. Resolve the "Property 'groupTypes' does not exist" Error #

You’re querying the /users endpoint, but groupTypes is a property exclusive to groups, not users. Switch your endpoint to /groups instead.

2. Correct Filter Syntax for startswith + NOT Combination #

Here’s the fixed query with proper filter logic:

https://graph.microsoft.com/v1.0/groups?$count=true&$filter=startswith(displayName, 'xyz') and NOT(groupTypes/any(c: c eq 'Unified')) and securityEnabled eq false and mailEnabled eq true&$select=displayName,mail

Key Fixes in the Filter: #

• Removed invalid + characters around eq in the any clause (correct syntax is c eq 'Unified')
• Properly wrapped the groupTypes/any check inside NOT() to exclude unified groups
• Combined all conditions with and as required

Critical Reminder: #

Keep the ConsistencyLevel: eventual request header—this is mandatory when using $count=true alongside advanced filters like startswith and any for group resources.

内容的提问来源于stack exchange，提问作者BHL