Flow Designer | Compare Requestor in Group Member Table and Create Task without Approval

[chatsaurav19]

Hi All,

I have a requirement where , for example , if a RITM is raised using a specific Catalog Item, then in the Flow Designer, it will be required to check if the 'Requestor' belongs to the 'Knowledge Function Group'. If 'yes' then the SCTASK would automatically get created without any approval. 

The end user populates the 'Knowledge Base' field in the Catalog Item and Submits the Request.

Tables:::

=======

Requestor ::: sc_req_item ( Get the Requestor Name ) 
Group-User Relationship ::: sys_user_grmember ( Get the Users against each Group )
Group Mapping ::: x_custom_table ( Mapping between Knowledge Base and Knowledge Function Group ) . The 'x_custom_table' is the table which holds the mapping between Knowledge Base and Knowledge Function Group ( which is basically the sys_user_group )

Query ::: What should be the correct approach to achieve this, using lookup record, as this involves all the three tables as stated above?  Would it be possible to achieve this using conditions if not then what should be the script? I was trying to use the below script but then will this work?

var groupName = fd_data.trigger.current.knowledge_functional_team.name;
//var reqT = fd_data.trigger.current.request.request_for.name;

var arr = [];
var grUserGr = new GlideRecord('sys_user_grmember');
grUserGr.addQuery('group.name', groupName);
grUserGr.query();
while (grUserGr.next()) {
    arr.push(grUserGr.getValue('user'));
}

for(i=0; i<=arr.length; i++){
  if(reqT == arr[i]){
    return true;
  }
}

Thanks and Regards,

Saurabh Chatterjee

[Uncle Rob]

According to Google, "Liczba" is Polish for numbers of a thing. AKA, count. 

[chatsaurav19]

Hi @Robert ,

My apologies for replying late but your solution worked! Loved the video as well.

Regards,

Saurabh

[Uncle Rob]

[Uncle Rob]

Here, I made a video for you.

https://www.youtube.com/watch?v=PGjMHPJrqz0

[Tim Sanders]

@Uncle Rob 

I've reviewed this article and watched the video and, for some reason, the Look Up Records does not appear to be working for me.  When I set the Name of the person in the Flow, it works, but when I try to pull the Requested For > Name (or any other dynamic value), the RUNTIME VALUE returns null (in the image I'm playing around with the sys_id, but it does appear to work with any dynamic value).  Any thoughts?

Thanks!