SharePoint List Lookup: Get User_ID from Username

dietergletz this is List A which has the User ID (renamed from Title), Username and Color columns.

Then in List B you won't need the Title column. Create a new column which I've called Username, type is Lookup from the Color list then open the more options and select the other columns to be added to list B. It will still show Title instead of UserID so select that and Color.

The additional columns are added to List B. When you add a new item select the username; I'm going to select Chris and save it.

The UserID and Color columns are automatically populated:

Hope that helps.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)