@amanmcse
https://graph.microsoft.com/beta/users?$filter=extension_[appid]_AppRole in ( 'a')
does it possible to filter B2C users by custom attributes with IN and NOT IN clauses or HAS clause?
Hi @17487350 This question is too broad, what information do you want to filter?
Hi @CarlZhao-MSFT
Need to filters B2C users based on the user custom property.
https://graph.microsoft.com/beta/users?$filter=extension_[appid]_AppRole in ( 'a')
As far as I know, dynamic property doesn't support filter IN operator, have you tried eq? https://graph.microsoft.com/beta/users?$filter=extension_[appid]_test eq 'value'
Hi @17487350
According my test, dynamic property doesn't support filter IN or NOT operators. I suggest you submit a user voice to add support for this feature.
Or you can also use the startswith operator, which should also work:
https://graph.microsoft.com/beta/users?$filter=startswith(extension_[appid]_AppRole,'role1') or startswith(extension_[appid]_AppRole,'role2')
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Thanks @CarlZhao-MSFT
"startswith" working fine.
doe it possible to filter the users who are not having the role1.
I dont want to use the OR clause here.
https://graph.microsoft.com/beta/users?$filter=startsWith(extension_[appid]_AppRole, 'role2')
startswith only working with role1 not role2 and role3
Hi @17487350
This is just one way I found, if it doesn't meet your requirements, I'd still suggest you submit a user voice to add support for the filter IN operator, and I'll upvote it for you :)
2 people are following this question.
