Auto complete a field based on another list data

[claudiugherasim]

Hello,

I have 2 lists in SharePoint. One contains the user in a People Column and another column, single line of text, where I filled the name of the owned computer.

No I want this information, computer name, to be automatically filled in another list, based on the username, when I add items to the list.

I add items to the list via MS Forms, MS Power Automate, MS Flow.

Thank you.

[#2]

Hi @claudiugherasim,

Unfortunately, we cannot use People column for the lookup, hence you will have to store the user information in a normal text field if you want to use that for the lookup.

[#3]

So I need to create a single text field, like a number for each employee and search based on that, right? But it can automatically bring the data?

[#4]

@nimesht thanks, but i did it via Power Automate.

[#5]

Yes, if it's text field we can use Lookup List to copy multiple fields from another list based on the selected value.

Reference from another post with similar requirement.
https://techcommunity.microsoft.com/t5/sharepoint/sharepoint-list-concatenate-multiple-rows/m-p/3910...