web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Pulling Department Hea...
Power Apps
Unanswered

Pulling Department Heads from A List

(0) ShareShare
ReportReport
Posted on by 4

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 ListDepartment Heads ListUI for the Engineer to Select Departments and Send EmailsUI for the Engineer to Select Departments and Send Emails

Categories:
I have the same question (0)
  • DavidZoon Profile Picture
    738 Most Valuable Professional on at

    Hello,

     

    You need to concat a filtered list of your departments, you can enter in your onselect : 

     

    Office365Outlook.SendEmail(Concat(Filter('Department heads',Title in ComboBox1.Selected.Value).'Department Head'.Email),";"),"subject","body")

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 325 Most Valuable Professional

#2
11manish Profile Picture

11manish 165

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 88 Super User 2026 Season 1

Last 30 days Overall leaderboard