Multiple Approvers, Please Help!!

[JD2301]

Hi guys,

I've got a query about having multiple approvers set up for my document to flow through too.

I've built a timesheet document in Excel titled 'Timesheet Requests'. If the 'Send for Approval' column has 'Yes' entered, an email notification sends out to an approver to approve or reject the request.  Once approved, the row deletes from the 'Timesheet Requests' document and moves into my 'Timesheet Approvals' document, using the add a row to a table and delete a row actions. 

My issue is, I need the approvals to go to different people based on the values entered in the 'Total Amount' column.
£0 - £250, it needs to go to just 1 approver (Supervisor)
£250-£500 = 2 approvers (Supervisor first, if they approve then it needs to go to the Manager to also approve)
£500+ = 3 approvers (Supervisor, if approved then to Manager, if approved then onto the CEO to also approve)
I have this all set up in my Excel sheet so if the value is £600 for example, there are 3 email addresses linked to this who all need to approve. I'm trying to get the email notifications to flow in the correct order and only move onto the next approver once the previous one has approved.

Currently, the emails are sending out to the 3 approvers at the same time which is where the issue is.

Any help would be appreciated.

Thanks.

[v-zhos-msft]

Hi @JD2301 ,

It seems there are multiple Approvers in you flow, and you want to manage sequential approvals with Microsoft Flow.

I am afraid you need to separate the Approvers in different Approval actions.

For example, there are 3 Approvers, so you need three Approval actions in the follow for each person.

Here is a docs about 'Manage sequential approvals with Microsoft Flow',you can take a reference:

https://docs.microsoft.com/en-us/flow/sequential-modern-approvals

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JD2301]

Hi @v-zhos-msft 

Thanks for the reply, I got this figured out now.
Is there a way to send the whole table in my excel sheet for approval at once rather than individually line by line? I don't really want 50 approvals to go out to the approver for 1 document, if I could get the whole sheet send out in my approval message that would be perfect. Or even be able to atatch the document to the approval notification?

Thanks.

[v-zhos-msft]

Hi @JD2301 ,

I have made a flow for your scenario, please check it for a reference.

Sending the whole table in the Approval.

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[JD2301]

Hi @v-zhos-msft 

Thanks for the reply. I've just tried this out and got it to work, however there are still a few things that I need to change so hoping you can provide me with some more knowledge.

So now all the submissions are listed in the details section of the 'start and wait for an approval' email notification, as shown below with test man 1 and test man 2.



However when I press approve (or reject), this action only does something for the first line in the spreadsheet (Test man 1). I then get another email notification asking to approve or reject again, with the exact same info on it but this will be for the second line in the spreadsheet (test man 2). 

Is there a way that only 1 approval can be used for multiple lines on the spreadsheet? Which is the reason I wanted to get all the submissions in the one approval rather than sending out a seperate email each time? 

My flow now looks like this:

The Add a row into a table action adds the info from the 'Requests' document into my 'Approved' document once it has been approved. The delete a row deleted the entry from the 'Requests' sheet as it is no longer needed there once it has been approved. Can this happen for multiple rows at a time rather than just individual lines?

Thanks fo your help.