Hi All,
I would like Pulling distinct items into a drop down list, and store the value into a "Single line of text" field in SharePoint List.
Let's say the data source list as below:
ID | Name | Department |
---|---|---|
1 | John | HR |
2 | Johnny | IT |
3 | Peter | IT |
3 | Mary | MKT |
And finally, the "Department" drop down list should only contains: "HR", "MKT", "IT" and the drop down list should allow multiple selection, alternatively, can I use check box list instead? Many thanks, Stehphen