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


