Jun 14 2021 09:37 AM
Hello all -
I have a Sharepoint list that just contains 2 columns: Employee ID and Employee Name. Of course, both columns only contain unique values.
I want to create a second Sharepoint list with the same columns, but whenever an employee ID is entered into the first column, the corresponding employee name would appear in the second column. The same employee ID might be typed in several times, so that column could not be restricted to unique values.
Would a flow be the best way to achieve this, or is there a way to do it within the Sharepoint list itself?
Thank you!
Jun 14 2021 12:36 PM