On the face of it, it\u2019s a fairly straight forward requirement, however in an Approve action we can only capture the Outcome and Comments from the first approver, so there\u2019s no easy way to capture a selection of the next approver (Or any other information for that matter).<\/p>\n
The easiest resolution for this is actually to look at using Outlook Actionable messages with Adaptive cards, which would allow us to capture additional information. The only downside to this is that we would need to handle the Adaptive Card response via an HTTPS Flow trigger, which is a Premium connector! In this environment, the client doesn\u2019t have access to Premium Connectors which rules out that option.<\/p>\n The work around that I suggested, does require that the list of approvers for the second stage be available at the point that the workflow is triggered. For this solution we decided that using a SharePoint configuration list provided the functionality that we needed and would meet the business requirements that we captured. The approval process becomes:<\/p>\n To show this approach in a working manner for this post, I\u2019ve built the following:<\/p>\n We could just as easily have used the users Line Manager and then make a business decision in the flow based on the Line Managers department from their profile (with of course a catch all option for when AD doesn\u2019t have the information!), but I wanted to keep this simpler for now to show the mechanism in action.<\/p>\n We start with a simple Selected File trigger, This allows the user to select a file and then use the context menu to submit the file for approval.<\/p>\n Immediately after, we pick up the selected item using a Get Item action. This gives us access to the file path and other useful info later. The next step then uses a Get Items action to select the correct Approver group from the configuration file list.<\/p>\n The filter query uses the Title from the lookup field in the source Item to filter the configuration list result. Watch the \u2018\u2019 around the dynamic data! (In our sample data above, the Title should equal \u201cFinance Tier 1\u201d or the other group name value. Once we have that item, we just need to parse it using a Parse JSON action to make it useful.<\/p>\n I usually build the schema for these from a first run of the Get Items action, using the Generate from Sample option. It does sometimes however provide a very rigid schema that may not meet your needs as this one didn\u2019t. I had to remove a number of data types and required fields from the schema to make it work every time.<\/p>\n If you find yourself playing with JSON much, I heartily recommend reading John Liu\u2019s post \u201cA thesis on the Parse JSON action in Microsoft Flow<\/a>\u201d where he dives deeply into the issue with this action and it\u2019s schema.<\/p><\/blockquote>\n Next up is a couple of Initialize Variable actions, the first to immediately set the First Approver e-mail using the Expression<\/p>\n body(‘Parse_Approvers’)[‘value’][0][‘FirstApprover’][‘Email’]<\/em><\/strong><\/p>\n This takes the output of our Parse JSON method, extracts the first item in the Value collection returned (we know we\u2019re only pulling back one item!) and then gets the value of the First Approver email field and sets it as the string value of the variable. The second action just creates an empty container ready for us to use later in the flow.<\/p>\n And then we need an Array to hold our Custom Responses to be passed into the Approvals process. At this point, we add in any \u2018static\u2019 options that we want included, in this case the Reject option.<\/p>\n The next step is where the dynamic approvers comes in. We\u2019re going to process the Second Approvers field from the configuration item. This is a multi-select People field in SharePoint, allowing us to select a number of user accounts. The only caveat really is that their e-mail must be populated. So far for this demo I\u2019ve tried with up to 3 people selected but I see no reason why this wouldn\u2019t work for more, depending on how the App and E-mail handles the larger number of options (You\u2019ll see this in a short while.)<\/p>\n First we add an Apply to Each action and set the target of this to the following expression:<\/p>\n body(‘Parse_Approvers’)?[‘Value’][0][‘SecondApprovers’]<\/em><\/strong><\/p>\n This addresses the first Item in the query to the config list (again, we know we\u2019re only returning the one item, so this is safe.), we then get the Second Approvers collection. Then in an Append to Array action inside the apply to each, we use the following expression to pull out the e-mail of the Second Approver.<\/p>\n items(‘Process_Second_Approvers’)?[‘Email’]<\/em><\/strong><\/p>\n This is then concatenated with the text \u201cApproved \u2013 Send to \u201c to form the response object that we need.At this point, we know have everything that we need to trigger our first Approval process and wait for the outcome.<\/p>\n You\u2019ll notice that I\u2019ve switched the Response Options from individual items to a single block, this allows me to pass in the AuthEmails array that we created earlier. The rest of the information is straight forward, we pass the e-mail of the first approver, then a link to the item and it\u2019s title. You can of course use the Details box to pass in more detailed content using Markdown.<\/p>\n At this point, an approvals process is kicked off and the First Approver will receive a notification by e-mail and directly in Teams if you have the Approvals app installed (Which is well worth doing!). The dynamic responses we put into our response block show up as choices in a drop down on the Approval app and as individual drop downs in the e-mail. Sadly the e-mail does NOT work as I\u2019d have liked for this. It would certainly be better as an individual drop down as per the app.<\/p>\n With those issue aside, the next step in the flow is to process the first approval, and this is a simple matter of checking to see if our outcome was a Rejection. If it was then we can do something with the result, such as set the content approval status in SharePoint and notify the requestor. If the approval is granted and sent to the next stage, then you may want to update a status field before moving on. I\u2019m showing that using a multi-line text field and just appending a message onto it.<\/p>\n As we move down the approval route, the next step is to use a Set Variable action to update the empty Second Approver Email variable that we configured earlier. This is done using the Substring function to separate out the Second Approver e-mail from the Outcome text.<\/p>\n substring(outputs(‘Wait_for_First_Stage_Approval’)?[‘body\/outcome’],19)<\/em><\/strong><\/p>\n In this case, 19 is the number of characters that appears in the Outcome upto and including the space in front of the e-mail address, which we know is perfectly valid, because it came from a People picker field.<\/p>\n![\"SNAGHTML14491a9\"](\"http:\/\/www.myfatblog.co.uk\/wp-content\/uploads\/2021\/01\/SNAGHTML14491a9.png\" "\\"SNAGHTML14491a9\\"")
<\/a><\/p>\nDynamic second stage approvals without premium connectors?<\/h1>\n
\n
\n
\n
<\/a><\/p>\n\n
<\/a><\/p>\nBuilding the flow<\/h2>\n
<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n<\/a><\/p>\n