Unable to set Catalog Task Assigned To field using RITM variable value

Cobbsalad · ‎01-07-2022

I am attempting to create my first Flow Designer flow related to Service Catalog. I have a reference variable on the RITM that has a qualifier to show only users who are members of a particular group:

The customer selects a user from this field on the RITM. I am using Get Catalog Variables to retrieve the variable field name. When testing, I can see that a sys_id is retrieved at this step:

I then want to Create a Catalog Task and set the Assigned To on the catalog task to the same user as the above. It appears to be setting the value, based on the screenshot below, but when I look at the RITM/SCTASK form, there's no value in the Assigned To field:

Can anyone tell me what I'm doing wrong and how to fix?

Mohamed Rahim1 · ‎01-10-2022

Ok that one works!!

Ok, so that's the issue!!

the Name variable is reference to group members table while it should be to sys_user table with reference qualifier the group name they are member of

the problem with your setup is that you are filling in data from a table and populate it to a field that reference another table and then when you select the members from the new table you are not getting the expected output (Sys_ID) of the user but you are getting the Sys_ID from his membership of a group

to fix this issue, change the name to be reference to active users in the Sys_user table

View solution in original post

Mohamed Rahim1 · ‎01-07-2022

Ok, can you open the create catalog task and show me how did you configure it?

it's better not to show the execution but the actual workflow configuration

is it through script or dot walking? is the assigned to is hard coded or it's dynamic also do you have any business rules/dictionary override applied to the assigned to field like the assigned to needs to be member of the assignment group?

Cobbsalad · ‎01-07-2022

Yes, here it is.. I get the catalog variable in Step 5 and so on Step 7 I dragged the hss_architect_name pill over from Step 5. The Assigned To is not hard coded..the end user selected a name from the list of group members earlier in the flow and yes, this user is a member of the assignment group.

shloke04 · ‎01-08-2022

Okay. Couple of things to verify here to get you to a solution:

1) Can you confirm if Display Value is set for User table?

2) Also at the same time can you check if there is more than one display value present in your User table which might be the cause it is showing as Empty on the record.

3) Navigate to your Catalog Task form and then try selecting a user and save the record and see if that is getting visible or not on the form once the record is saved.

For above two points, I answered a similar question on how to validate display values, please have a look below:

https://community.servicenow.com/community?id=community_question&sys_id=96f0e2671b744190d018c8ca234bcb60

Let me know how you go with this approach.

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

Cobbsalad · ‎01-10-2022

Name and Location are both Display Values on the User table.. I can manually select a user on the Catalog task, save the record, and it shows up fine. We have this currently working via Workflow Editor, but am trying to convert this over to Flow Designer.

Mohamed Rahim1 · ‎01-10-2022

what you shared is the user table

I need to see the variable definition on the catalog