Converting a sys_id to a string via a flow not working

[Bidduam]

I have a field on an asset record that is a list collector, storing users that have access to that asset.

I have a flow that is sometimes going to update/rerecord the list of users. In order to do that I am deleting the current users and updating the record with the new list from a flow. Everything works as I'd like to that level, however I want to add a work note simply saying that the list is being updated as part of a flow, record that flow name and record details, along what the list of users were before clearing the list, however I can't seem to be able to get the list via the flow.

Here are some details:

Table: alm_asset

Field name: u_asset_users (Asset Users)

Flow variable: existing_user_list (Existing user list)

I am doing a lit collector convert to array and a "for each" loop in order to get the user list and convert into their names, to add as a string on the work note field, however the "look up record" action keeps getting a "No record found in look up record action" error.

Flow screenshots:

Ideas?

[Ankur Bawiskar · Accepted solution]

@Bidduam 

you should use Lookup Records with this

Sys id [IS ONE OF] Get Catalog Variable->List variable

Then iterate those records using For Each

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

[Bidduam]

@Ankur Bawiskar 

Thanks, I updated it to look up records and it is now certainly getting the list of users, but for some reason it has converted the name to '' rather than the users actual names

[Ankur Bawiskar]

@Bidduam 

you got the list of users. The Records will show the display value from those records and hence you see the name of users there.

In the next step you can use For Each and iterate over that and use Lookup record and then use update

Check the below post where I shared example

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

[Ankur Bawiskar]

@Bidduam 

something like this and then use Update Record on that Lookup Record in Step 4 as Step 5 so that you can update the field you want

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