Forum Discussion
Auto complete a field based on another list data
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, ...
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.
nimesht thanks, but i did it via Power Automate.
- 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/3910384/highlight/true#M74092
- 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?
