Help Needed: Multi-Select Dropdown with Pre-Selected Options and Dynamic Update

Question

Hi Community, 
 I have a requirement involving a multi-select dropdown in an Appian interface. Here's the scenario:

First Screen : 
 
 I have a multi-select dropdown that is a mandatory field. 
 Users must select at least one option. 
 The selected options are saved in the database table, with each option stored in a separate row.

Next Screen : 
 
 The same multi-select dropdown is presented, but it is not a mandatory field. 
 When the page loads, it should pre-select the options that the user selected in the previous screen (fetched from the database). 
 The current user should be able to select more options or deselect previously selected options. 
 Upon submission, the form should save the updated selections.

I am looking for guidance on how to: 
 
 Pre-select the options in the multi-select dropdown based on the user's previous selections. 
 Allow users to dynamically update their selections (add or remove options) and save these changes. 
 
 Any help or examples on how to implement this would be greatly appreciated. 
 Thank you!

Prasanta Paul · Answer

You can query the previous data you have, and set the data with the help of a!defaultValue function.

kaushikr0003 · Answer

Sorry for the very late reply. I swapped the multiple dropdown component for an editable grid by adding a dropdown field to the grid. I made the dropdown field mandatory, so users must select a value before moving on. Let me know if you need more details!

kaushikr0003 · Answer

Sorry for the very late reply. I replaced the multiple dropdown component with an editable grid that includes a dropdown field. The dropdown shows pre-selected values from the previous screen (fetched from the database), and the user can add more options or remove previously selected ones. Let me know if you need more details!