Add items selected from combo-box (lookup) to collection, send email to certain user(s) based on selection

[jharville1]

I have a combo-box called 'reviewComboBox' (that contains items pulled from a Lookup column) inside my application. Some of the items are: January, February, March, April, May ... and so on.

My combo-box allows for multiple selections. I would like for: when the user selects multiple items and submits the form once they have made all their changes (ex: selecting what items they'd like, and de-selecting what they would not like if they change their mind), the items selected in that combo-box will be added together to a collection in the form of a table. Here's a visual of the collection I'd like if the 3 items: 'January' , 'February' , and 'March' are selected in the combo-box -->

I have tried the following code (as well as ClearCollect(colReviewItems, yourComboBox.SelectedItems) ) in both the "OnSelect" and "OnChange" properties (in the 'Advanced Properties') section of my combo-box, but nothing is collected at all... Does anybody see any issue with my code?

-------------------------------------

I have been told from other users on this forum that I wouldn't need to create a collection, as I can rather simply reference yourComboBox.SelectedItems in any place of my app. However, the reason why I am trying to collect the items from the combo-box is because I'm building an 'Approvals' application that creates an approval for each of the items selected in the combo-box. The collection will count each item stored in it and ultimately uses a patch statement to create the approvals. I already have the 'Approvals' app built so that it creates one approval for the entire form, but need to tweak it to create an approval for each item selected.

The application: consists of one form with an input text field where the user inserts their name, and a combo-box section. I want each item selection within the combo-box to route the form to a specific person, since the look-up that my combo-box is using is pulling from a separate list ('review materials') that has 2 columns. One for the item (ex: January), and the second column for an email address. So in one row, there is a corresponding Item and Email Address.

ex: January emails (routes) the form to 123@gmail.com for approval of that 1 item (January), while February emails the form to xyz@gmail.com for approval of that 1 item (February). If both January and February are selected, both of the email recipients stated will be sent an email for approval of those 2 items (January and February).

My goal is to add those items selected to the collection, write code to have a count of how many items are in that collection, and then create sub-approvals for each item with a patch. But as of now, I just need help adding those selected combo-box items to a collection, where I can later count how many are in the collection and send out emails based on what was selected.

[jharville1]

@RandyHayesThanks again for your help, I can't say how grateful I am. Happy Thanksgiving! 🙂

[RandyHayes]

@jharville1 

No problem.  Glad to help and have a Happy Thanksgiving also!