How do I convert string into sys_user reference field in Flow Designer?

alberttagle
Tera Contributor

I have a requirement to use MRVS to capture some information, and ask approvals from the listed users within MRVS.  The input to MRVS was a sys_user reference field, but when looking into the flow, it is captured now as Strings.

alberttagle_0-1736935537605.png

alberttagle_1-1736935683468.png

 

How do I convert them back to sys_user reference fields so I can use them in approvals?

 

 

4 REPLIES 4

Mark Manders
Mega Patron

Check the content of the string. It could very well be the sys_id and then you don't have to do anything else. If not, you can do a lookup record(s) on the sys_user table where your string field equals the field on the user table.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

How will I check if the string is the sys ID or the user ID?
I tried both User ID and Sys ID in the redbox below, but on the 2nd screenshot, I still do not get what I need.

alberttagle_1-1736950995744.png

 

alberttagle_2-1736951054983.png

Ankur Bawiskar
Tera Patron
Tera Patron

@alberttagle 

can you share the flow step?

Are you not able to select those users in Approval action directly?

Ideally you should since those are reference variables

If my response helped please mark it correct and close the thread so that it benefits future readers.

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

For some reason, the flow reads them as String now because they are part of entries in the Multi-Row Variable set.

alberttagle_0-1736950728662.png