@Tison5 Power Automate is the app to do this. In your main SharePoint list you will need single line of text columns for the approver name, approval date and the outcome (which will either be approve or reject). You will also need a multiple lines of text column for any comments made by the approver.
In the example below there is a second list in SharePoint with the approver's email for each department and it sends it to the approver for the department the user selected.
The user adds a new item to the main list:
In the flow the trigger is the SharePoint "when an item is created". Next we add an "initialize a string variable" action and set it to the department selected by the user.
Next, add a SharePoint "get items" action and add a filter query so that it will only bring back the item in the approvers list with the seleted department. For this you need to add an expression from the dynamic content box of Title eq '{varDepartment}'
Next, add an "apply to each" action and select value from the get items section of the dynamic content box. Next add a "start and wait for an approval action". Enter the information requested and for the assigned to select Approver from the gert items section of the dynamic content:
Once the approval has been done we want the item in the list updated with the details of the approver and any comments they made. So still inside the apply to each add an "update item" action and for the columns that hold the approval details you select these from the start and wait for an approval section of the dynamic content box. When you select responses comments you'll see that the actio wraps itself in another apply to each. This is expected.
So when the user adds an item to the list the flow will trigger and an email will be sent to the approver. This is in the form of an adaptive card which means the approver can select their decision and add any comments right within the email. tghey need to do this within 30 days or the approval times out and fails.
And when the approvers clicks the submit button the adaptive card closes:
The flow carries on running and updates the list item with the approval details:
Instead of the update item action you could get the approval details added to a table in Excel.
Come back with any questions about this.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Accepted Solutions
@Tison5 Power Automate is the app to do this. In your main SharePoint list you will need single line of text columns for the approver name, approval date and the outcome (which will either be approve or reject). You will also need a multiple lines of text column for any comments made by the approver.
In the example below there is a second list in SharePoint with the approver's email for each department and it sends it to the approver for the department the user selected.
The user adds a new item to the main list:
In the flow the trigger is the SharePoint "when an item is created". Next we add an "initialize a string variable" action and set it to the department selected by the user.
Next, add a SharePoint "get items" action and add a filter query so that it will only bring back the item in the approvers list with the seleted department. For this you need to add an expression from the dynamic content box of Title eq '{varDepartment}'
Next, add an "apply to each" action and select value from the get items section of the dynamic content box. Next add a "start and wait for an approval action". Enter the information requested and for the assigned to select Approver from the gert items section of the dynamic content:
Once the approval has been done we want the item in the list updated with the details of the approver and any comments they made. So still inside the apply to each add an "update item" action and for the columns that hold the approval details you select these from the start and wait for an approval section of the dynamic content box. When you select responses comments you'll see that the actio wraps itself in another apply to each. This is expected.
So when the user adds an item to the list the flow will trigger and an email will be sent to the approver. This is in the form of an adaptive card which means the approver can select their decision and add any comments right within the email. tghey need to do this within 30 days or the approval times out and fails.
And when the approvers clicks the submit button the adaptive card closes:
The flow carries on running and updates the list item with the approval details:
Instead of the update item action you could get the approval details added to a table in Excel.
Come back with any questions about this.
Rob
Los Gallardos
Microsoft Power Automate Community Super User