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

Hi Community,

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

1. 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.

2. 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!