I have a Dropdown box in a form, which the items are result of a filter Sharepoint list, with Name column as the dropdown items.
How can I add additional names to the filter table ? I found several post, but no direct way, mostly suggest using a collection to store the filter result, then add data to the collection.
Thanks a lot for your help.
I would try using collection then.
My scenario is I have a SP list, with Name, User ID and Department as column.
I have a submission form with a Department dropdown box and a Name dropdown box.
The items of the Name dropdown box is base on the selection of Department Dropdown box. However, When a specific option is selected at Department, I will need to refresh the option items of Name Dropdown box, with additional name added, which are not stored in SP list.
How can I refresh the collection with additional records added to the when a specific option is selected at Department?
Appreciate your help.
You can create your collection on OnChange of the department dropdown. So, every time department dropdown changes a collection with your desired values will be created. And that collection will be the source of name dropdown.