Hmm, kind of, but not really. You need to retrieve the email that's for the chosen departments, then put all those emails together into a string, and plop that into your Approval task. Let's take a look...
First, I have my ApprovalMatrix where I identify which approver is associated with each department.
(Ignore that I'm the only person -- I am the only person that exists in my tenant haha.)
Next I'm going to create my MS Form and create a trigger on new MS Form response.
Here's what my form looks like:
This solution will work for any number of departments, whether it's 2 or 300.
Here's how I start the flow:
Now, to get into our department needs.
First, I'm initializing two variables. One holds our departments, the other holds our string of approver emails.
In the first one, notice I have an expression. That expression is splitting up the departments into an array by identifying the characters between them, replacing them with either a blank or a pipe, and then splitting where ever the pipe is.
split(replace(replace(replace(outputs('Get_response_details')?['body/r3cbfa311bdbc434190f4570ebd8b8f6c'],'","','|'), '["',''), '"]',''),'|')
The part that I've made orange above is just the dynamic content from the form.
Next, we're going to create an "Apply to Each" and point it at our "arrDepartments" array. We're going to loop through our departments!
The first action I drop in is the Get Items action, since we want to say "Hey SharePoint, please return the item where the Title is equal to this Department" (in my approval matrix, the title is the department.)
"Current Item" is a piece of dynamic content available in our Apply to Each, and it automatically picks up the next selected department per loop.
Next, still in our Apply to Each loop, we're going to use the "Append to string variable" action. A little bit of a formula here that, I'll be honest, I'm still learning the format of.. but it works! (This is all tested out btw.)
The expression shown here looks like this:
outputs('Get_items_-_match_department_to_matrix')?['body/value'][0]?['Approver']['Email']
It's saying "look at the first item returned from Get Items, find the approver, and then within the approver properties, please give me the email." If you update the part I've made orange to match whatever you've named your Get Items action, you should be good to copy / paste. (For example, if you left it as Get Items, you'd just have outputs('Get_items') and carry on with the rest of the formula.
⏰PLEASE NOTE: There is a semi-colon right after the expression has been entered -be sure to add it after your expression!
Annnnnd that's it! Now - on the ‼️OUTSIDE‼️OF YOUR APPLY TO EACH ... you can plop the 'txtApproverEmails" into your task "To" or email "To" - whatever you need. If you want to try it out first to see if you've got it down, try putting a compose outside of your loop and dropping your variable in, like this:
Here's the whole thing, top to bottom:
This should get you where you need to be - let me know if you have any issues.
Cheers,
Rhia
