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?

[Shubham_Jain]

@Bidduam 

Final Flow Steps Summary

1. "Get Record" Action: Fetch the alm_asset record.
2. Store u_asset_users in existing_user_list (Sys IDs string).
3. Convert List to Array: Split the Sys IDs into an array.
4. Loop Through the Array:
   • Use "Look Up Record" on sys_user where sys_id = current array element.
   • Append user.name to a variable.
5. Update Work Notes with:
   • Flow execution details.
   • Previous user list before clearing.

[diego2_898]

yes me too