Change field value based on another field value

[Cuba_RJ]

Hi,

I have a flow that will update a MS List based on answers provided by users in a MS Form, it was built using the templates we can find on Power Automate so there is no fancy coding here. 

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.

I searched online and I noticed maybe variables would be useful or even working with arrays, but I have 0 idea on how to make that happening.

Can you help to make it?

[FLMike]

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

[Cuba_RJ]

Hi, FLMike.

Sorry for not being clear enough, I am new to Flows and sometimes I don´t even know how to make the right question. So, let me clear some of your assumptions: 

The set up I am using is a Microsoft Form to collect requests, A Microsoft List to receive the requests plus to control other information and a Power Automate Flow that will get the info from the form and send them to the MS List.

At first, I thought of making this using the "Update Item" in Flow, but then I realized it could be done using some flow in the MS List, similar to a "auto fill cascading combobox" in Excel or Access.

A better example for you: 
User will open the form and request a Production Leader for a certain day, then user will not point Department in the form, just the role. Once one of the forms were saved then the List would self-update to assign the CC Leader box as per my image (Department). The this is the field I need to be updated accordingly:

A collection of roles in Department Production would contain: Production Supervisor, Production Leader, CRO, Production Operator and a Lab Tech.

[Cuba_RJ]

Hi. Is it possible to make it?