How to convert sysid from lookup records to string.

[Al-jhon]

I'm trying to put the records from lookup to worknotes, but i'm getting the sysid of the users and not their names.
I can't dot walk their names if I directly get the record.

but if i use For Each, i can dot walk their names but it record a worknotes for each user.
I need to record their names in worknotes once and in array.

can anyone give me ideas?
Thank you.

[Yashsvi]

Hi @Al-jhon,

please check below links:

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0695947

https://www.servicenow.com/community/itom-forum/sys-id-to-string-value/m-p/912736

https://www.servicenow.com/community/developer-forum/convert-sys-id-to-string-value/m-p/1873720

Thank you, please make helpful if you accept the solution.

[Krushna R Birla]

Hi @Al-jhon 

can you please add more snapshot related to what you are getting and what you want at field level. Would be great for me to provide solution.

Thanks,

Krushna Birla

[OlaN]

Hi,

You can store all their names in a Flow variable.

First do a look up records, like you have already.

Then extract all the names in a for-each-loop, and store the data in a Flow variable.

Then after the loop is done, use the collected information in the Flow variable to update the record.

[Al-jhon]

Hello @OlaN , i tried your idea and i am getting the name already.
Now since I am looking up for records, there are many records i will get and i want to record it in worknotes once only and not by loop.