Azure AD Connector - multiple accounts_filter criteria on importing accounts

[Ian]

Hi all. We are trying to apply multiple filter criteria to the ACCOUNTS_FILTER configuration on our Azure AD Connector, but can't work out the required syntax.

This statement:

startswith(extension_ourGUID#_employeeType,'Staff')&onPremisesSyncEnabled eq true

only applies the first filter (looking for startswith Staff), and doesn't filter by onPremisesSyncEnabled . I.e. we only want to import accounts that are both marked as 'Staff' and synched from on-premise.

Has anyone else managed to filter on multiple attributes in the ACCOUNTS_FILTER?

What's the syntax you used for writing those multiple filter criteria? It's not clear if it's powershell syntax or something else.

Many thanks for any help or suggestion.

Ian

[rushikeshvartak]

Is it working on postman ?

https://learn.microsoft.com/en-us/answers/questions/513163/filterquery-azure-ad-dynamic-versus-assig... 

https://learn.microsoft.com/en-us/answers/questions/898753/negation-in-filter-on-azure-resource-grap... 

[Ian · Accepted solution]

Thanks for your attention.

It was a syntax issue we tracked down, using the MS Graph Explorer. This worked:

startswith(extension_ourGUID#_employeeType,'Staff') AND onPremisesSyncEnabled eq true