Morning,
Apologies I am not sure what you mean by Can you help make it. I'm not sure what the ask is exactly and if its in Power Automate or the Canvas Apps
Can you explain the bottom more clearly.
The problem is this: one of the fields in the form requires users to choose the role needed, when the user enter that info, I would like to create the record on MS List and assign it to the correct department.
I have 17 roles in 3 departments and assigning this automatically will make it easier to email the correct Department Leader.
This field will be filled with the correct Leader: Maintenance, Marine, Production.
Ok, so they select a role. But are you saying they aren't selecting a department and you want to figure out based on the role, which department to send it too?
How are you passing the data to the flow? If what I asked is correct, then I would pass the department email to the flow. To figure out which one to do, in the app:
Note: understand I am making simple assumptions, versus designing a full solution here.
1. You have limited roles
2. You can simply create a Collection that looks like this, in the App.OnStart of the app. You can use a table or other configuration way to do it, this is the simple way to demonstrate what I think you are asking for.
ClearCollect(RoleDepartmentMappingCollection,
{ role: "Team Leader", department: "Production", departmentEmail: "Production@blah.com" },
{ role: "Team Leader 1", department: "Marine", departmentEmail: "Marine@blah.com"},
{ role: "Team Leader 2", department: "Production", departmentEmail: "Production@blah.com" },
{ role: "Team Leader 3", department: "Maintenance", departmentEmail: "Maintenance@blah.com" },
{ role: "Team Leader 4", department: "Production", departmentEmail: "Production@blah.com" }
);
3. I don.t know how you fill the roles dropdown but with this collection you set it to this
Items property = RoleDepartmentMappingCollection
In the Drop down box properties, set the Value = role
When you go to submit the data to the flow, getting the email is super easy, you do it by typing this
Dropdown1.Selected.departmentEmail
Here is a text label I added to my screen to show you when I selected Team Leader as the role it populated the email address automatically in the label
Now pass the email to your flow and in your flow you would have an expression for the CC and put the value of wherever you passed it into the flow.
Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey
