How to convert sysid from lookup records to string.

Al-jhon
Kilo Sage

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.

Aljhon_0-1719990588501.png

 

1 ACCEPTED SOLUTION

Here's an example for reference.

Hope it helps!

 

flow-use-variable-to-store-multiple-values-update-single-record.png

And here is the append-data step expanded to explain that step.

 

flow-append-data-flow-variable-expanded.png

View solution in original post

10 REPLIES 10

Yes, and that is exactly what I wrote.

First use a look up records to query records.

Then add data to the flow variable in the for-each loop for all records found.

Lastly, after the loop is completed, you should have all the data stored in a Flow variable, and use that data to update the record.

Here's an example for reference.

Hope it helps!

 

flow-use-variable-to-store-multiple-values-update-single-record.png

And here is the append-data step expanded to explain that step.

 

flow-append-data-flow-variable-expanded.png

Hello @OlaN ,
how can i store the value from lookup records in array and put it in worknotes as one?

Thank you so much @OlaN and @Krushna R Birla .
I can now put the names on one worknotes.

Hi @Al-jhon 

 

As I understand it, you want to push all user names into an array and return it once in the worknotes. To do this, you need to use a 'For Each' action right after you look up the records. This action will iterate through all elements and push them into a variable. Create a flow variable to store all the elements.
Once this is done, you need to update the records using the flow variable

 

@OlaN has also demonstrated this in the snapshots. This is the only way you can push elements and update them at the form level.

 

This will definitely helps you to resolved your issue. Let me know in case you need to understand the flow or you can DM on LinkedIn.

 

If this solution resolves your query, kindly mark it as the accepted solution and give it a thumbs up.

 

Best Regards,
Krushna Birla