Flow Designer - Is User in Group

sgmartin
Kilo Guru

‎10-22-2020 11:34 AM

First crack at using action to lookup a user in an Active Directory Group in Flow Designer.  Have a Service Request that is having the user select user from the sys_user table and also a Group to check in AD.  Is there any documentation on this or examples?  I've gone through the ServiceNow docs to setup the Microsoft AD spoke and in my Flow I select the Action for Microsoft AD and then Is User in Group.  I feed it the user name and the group but it fails.

0 Helpfuls
  • 1,961 Views
3 REPLIES 3

sachin_namjoshi
Kilo Patron
Kilo Patron

‎10-22-2020 02:05 PM

You need to query sys_user_grmember table to find if user belongs to group in your flow.

 

Regards,

Sachin

0 Helpfuls

sgmartin
Kilo Guru

‎10-22-2020 02:10 PM

This function I'm assuming since it's part of the Microsoft AD Spoke is to check whether or not the User is in an Active Directory Group, not a ServiceNow group.

0 Helpfuls

sachin_namjoshi
Kilo Patron
Kilo Patron
In response to sgmartin

‎10-22-2020 02:23 PM

I see that AD spoke function only needs group name and user name to check if user is member of group.

 

What's the error message you are getting?

 

Regards,

Sachin

0 Helpfuls