When using custom filter inputs for selecting the synchronization source "Microsoft 365 - Azure Directory / Entra ID / Global Address List / GAL (internal user list)" ("Global Address List"), all filter expressions are possible according to the Microsoft documentation.
Standard Filters
The following filters are applied automatically and without separate input:
| Standard Filter | Meaning |
|---|---|
| userType eq 'Member' | Only genuine users in the Microsoft 365 Azure Directory |
| accountEnabled eq true | Only active users |
Examples of Custom Filters
The following filter expressions can be defined in addition to the standard filters.
| Example | Meaning |
|---|---|
|
startswith(companyName, 'Meyer') |
Only Microsoft 365 users whose company name starts with "Meyer" |
| startswith(givenName, 'O') | Only Microsoft 365 users whose first name starts with "O" |
| city eq 'Frankfurt' | Only Microsoft 365 users from the city "Frankfurt" |
|
onPremisesExtensionAttributes/extensionAttribute1 eq 'yes' |
Only Microsoft 365 users whose custom extension "extensionAttribute1" has the value "yes" |
| onPremisesExtensionAttributes/extensionAttribute1 ne null | Only Microsoft 365 users whose custom extension "extensionAttribute1" not equals value "NULL" |
| extension_TENANT_ID_msExchExtensionAttribute17 eq '01' |
Only Microsoft 365 users whose custom extension "extensionAttribute17" has a value of "01".
Important! Since Microsoft Extension attributes > number 15 are only allowed in the Beta Graph API, an adjustment from sync.blue® support for the affected connection is necessary in advance! |
|
endsWith(mail,'@microsoft.com') |
Only Microsoft 365 users whose email address ends with "@microsoft.com". In certain scenarios, it may be helpful to use userPrincipalName instead of mail. |
|
businessPhones/any(p:startsWith(p, '%2B49 5661')) |
Only Microsoft 365 users whose business phone number begins with "+495661" |
| businessPhones/any(p:p ge '!') or mobilePhone ne null | Only Microsoft 365 users with a phone number. |
| ... | ... |
Here Microsoft describes additional properties for users (and here for organizational contacts) that can be used for filter expressions.
Comments
0 comments
Please sign in to leave a comment.