Add a filter on sys_user_group_table.list that excludes the types a user group already have

JoSte
Tera Contributor

Dear,

I hope someone can help me with creating a Catalog item that adds extra group types (from sys_user_group_type.list) to a given ServiceNow group.

On my ServiceNow Request, the end-user needs to enter in a first field the ServiceNow group, where he wants to add an extra group type to. In my second field on the form, the enduser must select a (group) types which it does not yet has.  

I tried to make use of a multi row variable set with two variables called 'ServiceNow group' and 'Types to add'.  

I want to make use of a flow that immediately add the selected type to the given ServiceNow group. To avoid that I add a type that the ServiceNow group already has, I like to implement an 'exclude script' so only a type that the ServiceNow group does not yet has, can be selected.  The types the group already has, should be exclude from the select box.  

I hope someone can help me with this query.  Big thanks in advance!

-Jo-

0 REPLIES 0