Reference Values in ServiceNow table unable to process into Smartsheet

yh374

Hi. I have set up a connection between ServiceNow table and Smartsheet for when records get updated, it will feed back into Smartsheet. However, for the "Teams" field in my ServiceNow record, it references another table and can sometimes contain 2 or more Team names which shows up as Sys_IDs when I look at the Run Log. When I tried to run the workflow, it gives me an error when trying to retrieve each team name:

"Record does not exist with ID '39c24dee1b61234572ed74c8dc4bcb04, 0ac24dee1b61012342ed74c8dc4bcb0d' in 'sys_user_group'."

If separate out the ID, the Get Record junction works and I am able to properly ingest a single team name into my Smartsheet but once two more it fails.

My end goal is to be able to take each of the Sys_ID returned when a record has been updated from the Team field in ServiceNow, match it against the Team table and retrieve each of the Team names and update them into my Smartsheet Teams column like this:

Current Set up:

Any tips or suggestions?

Georgie

Hi @yh374,

I see that you have opened a support ticket for this issue and I can see that the case is currently being looked into - please continue to work with our Support team on this as they’ll be able to assist and communicate with you regarding your setup via private channels.

Thanks,

Georgie