List collector shows sysid instead of display value

[jeffD1]

Hello,

I have an issue with a list collector. I am building a scoped app. This app has two custom tables. One has a list of Key Business Users and the other is an extension of the task table named Visit Log.

The key user table has two fields, a reference to sys_users and a watch list collector. This table has no issues. The field "key_user" which is the reference field to the sys_user table is set to display=true on this table. I also has a Reference List for this table with columns User, User.userid, and user.email listed.

On the second table called Visit Log I have a list collector that references the table for key business users. When I select a record in this collector it shows the user as intended, but once saved the user is converted to a sysid.

There is a properly setup display value on the referenced table and the table has a reference list. I am rather confused on what to check now.

Any ideas?

[Shashikant Yada · Accepted solution]

Kindly right click on column header -> List layout and add necessary columns, that should help to view the respective value.

Thanks
Shashikant

Hit Helpful or Correct on the impact of response.

[jeffD1]

I am not sure I understand. All needed columns display in the various views. The issue is that the list collector is storing sysids instead of the user's name.

Then this is the reference list: 

Selected user before saving: 

List display after saving: