How do I convert string into sys_user reference field in Flow Designer?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-15-2025 02:08 AM
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.
How do I convert them back to sys_user reference fields so I can use them in approvals?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-15-2025 05:13 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-15-2025 06:41 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-15-2025 05:17 AM
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.
Ankur
✨ Certified Technical Architect || ✨ 9x ServiceNow MVP || ✨ ServiceNow Community Leader
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-15-2025 06:18 AM
For some reason, the flow reads them as String now because they are part of entries in the Multi-Row Variable set.