Power Platform Community Forum Thread Details

Hi. I'm creating a fairly sophisticated app to record and manage parts held for quality issues on our production floor. I feel I've got a pretty good feel for PowerApps at this point but there is one problem that I am struggling with.

One of the features of this app will be the ability for the Engineer evaluating the issue to provide feedback to department heads when it is determined that the problem is due to a workmanship issue or some other preventable issue. I have a field in my main "Quality Hold" list to specify the department that did the work that generated the quality issue. In my app I want a combo box that will to pull from a list of departments (and department heads) and populate the combo box items with the department names (see the images below). Then, when the user selects a department or departments or enters something, that data will be stored to in the "Department" field in my "Quality Hold" list.

Lastly, when the engineer clicks the "Notify Department Head" button, the app pulls the list of departments that were selected in the combo box and sends an email to the department heads listed on the "Department Heads" list (if a listing exists since the user can manually enter something into the department list).

I just can't seem to get my head around this one. Can someone point me in the right direction? Thanks!

Department Heads ListUI for the Engineer to Select Departments and Send Emails