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]

Not sure how to ask for this... but I'd like to see the "full length data pill" that you're calling that returns a runtime value of null.

[Tim Sanders]

Thanks for replying, @Uncle Rob!  Here's what the Look Up Group Member Records looks like in my Flow, including the pill path.