( Flow Designer ) How to check the actual existing group and the existing group before ?

ericlung
Tera Contributor

Hello Servicenow Community,

 

The context :

I have a record producer where I can modify group to add new member or remove member in a Existing Group .

( Screenshot of Record Producer )

screenshot1.png

 

screenshot2.png

 

If the "Group Type" Field is "Assignment Group"  . It will create a new Task where I send to a Servicedesk the task to Add or Remove members from a group call "APP_Fufillment_group".

 

And everything will be done through a Flow after the end-user click on "submit" .

 

Issue :

When I do my flow after the If Condition check . 

I try a " Look up Record " action where I look at the Group Member Table in order to get All the member from the Catalog Variables .

 

Screenshot of the 2 Look up action :

ericlung_4-1686657569936.png

 

 

Screenshot of the first Look up record :

 

The value for the first "Look Up Group Member Records" is :

Table : Group Member[sys_user_grmember]

Conditions : Group | Is | 1 - Get Catalog Variables > Existing Group

 

ericlung_0-1686656774828.png

 

Screenshot of the Second Look up record :

ericlung_1-1686656788354.png

 

Screenshot of the data pill used in the look up record condition :

ericlung_2-1686656989894.png

 

But after the First Look Up Action , I create a second action in order to get the members BEFORE the submit of my record producer .

 

 

Questions:

 

1) How do I get all the members of the existing group ( Initial Group ) before the Flow trigger ?

 

2) How to do the check between those 2 groups in order to see if :

    - I add new member to the group ?

    - I remove some members from the initial existing group ? 

 

3) How to display multiple value of data pill inside a field ( Description(description) ) from Create a Catalog Task Record action because It only display the sys_id ?

I try to use a For each loop but it create multiple task (sc_task ) instead I want all value display into One sc_task record .

ericlung_5-1686657760329.png

 

Thank you to all community member

0 REPLIES 0