Page Comparison

User Filter

Import only the active users.

accountEnabled eq true

User Filter

Import the users based in London city.

city eq 'London'

User Filter

Import users in a country.

country eq 'Ecuador'

User Filter

Import users of two countries.

country eq 'Ecuador' or country eq 'India'

User Filter

Import users of multiple countries.

country in ('Ecuador', 'India', 'Germany')

User Filter

Import users which are having userType as Member

userType eq 'Member'

User Filter

Import only Engineering department

department eq 'Engineering'

User Filter

Import users having the usage location as Japan or Great Britain.

usageLocation in ('JP','GB')

Group Filter

Import only Microsoft 365 groups (aka unified groups)

groupTypes/any(c:c+eq+'Unified')

Group Filter

Import the groups having a name starting with “team”.

startswith(displayName, 'team)

Only the users having the organization's email address.

endsWith(mail,'@organization.com')

Users having an email address.

NOT(mail eq null)

Another way to filter users having an email address.

mail ne null

Import only if the users have a company name that is not Microsoft.

companyName ne null and NOT(companyName eq 'Microsoft')

Do not import the users starting with Conf.

NOT startsWith(displayName, 'Conf')

Do not import the users having user type as Guest

not(userType in ('Guest'))

Import the users in Latium Office location.

officeLocation eq 'Latium Office'