SOLVED

sharepoint approval list

%3CLINGO-SUB%20id%3D%22lingo-sub-2811793%22%20slang%3D%22en-US%22%3Esharepoint%20approval%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2811793%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20all%2C%3CBR%20%2F%3EI%20would%20like%20to%20introduce%20some%20kind%20of%20approval%20procedure%20in%20sharepint.%20I%20would%20like%20that%20when%20an%20object%20is%20edited%2C%20it%20is%20sent%20to%20an%20approver%20beforehand%20who%20then%20approves%20it.%20The%20requestor%20and%20approver%20should%20be%20entered%20in%20an%20excel%20list%20with%20date%20and%20time.%20do%20you%20know%20a%20simple%20solution%3F%20thank%20you%20very%20much.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2811793%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Server%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2811940%22%20slang%3D%22en-US%22%3ERe%3A%20sharepoint%20approval%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2811940%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1160908%22%20target%3D%22_blank%22%3E%40Tison5%3C%2FA%3E%26nbsp%3BPower%20Automate%20is%20the%20app%20to%20do%20this.%20In%20your%20main%20SharePoint%20list%20you%20will%20need%20single%20line%20of%20text%20columns%20for%20the%20approver%20name%2C%20approval%20date%20and%20the%20outcome%20(which%20will%20either%20be%20approve%20or%20reject).%20You%20will%20also%20need%20a%20multiple%20lines%20of%20text%20column%20for%20any%20comments%20made%20by%20the%20approver.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20example%20below%20there%20is%20a%20second%20list%20in%20SharePoint%20with%20the%20approver's%20email%20for%20each%20department%20and%20it%20sends%20it%20to%20the%20approver%20for%20the%20department%20the%20user%20selected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%221-SP-List-Approvers.png%22%20style%3D%22width%3A%20469px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F315187i6BC0ED3B9D8B3818%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%221-SP-List-Approvers.png%22%20alt%3D%221-SP-List-Approvers.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20user%20adds%20a%20new%20item%20to%20the%20main%20list%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%222-SP-List-Approvals.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F315188i0B717BAE71F0FA95%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%222-SP-List-Approvals.png%22%20alt%3D%222-SP-List-Approvals.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20flow%20the%20trigger%20is%20the%20SharePoint%20%22when%20an%20item%20is%20created%22.%20Next%20we%20add%20an%20%22initialize%20a%20string%20variable%22%20action%20and%20set%20it%20to%20the%20department%20selected%20by%20the%20user.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%223a-Trigger-Var.png%22%20style%3D%22width%3A%20584px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F315189iF4A785C21F3B48F0%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%223a-Trigger-Var.png%22%20alt%3D%223a-Trigger-Var.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENext%2C%20add%20a%20SharePoint%20%22get%20items%22%20action%20and%20add%20a%20filter%20query%20so%20that%20it%20will%20only%20bring%20back%20the%20item%20in%20the%20approvers%20list%20with%20the%20seleted%20department.%20For%20this%20you%20need%20to%20add%20an%20expression%20from%20the%20dynamic%20content%20box%20of%20Title%20eq%20'%7BvarDepartment%7D'%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%223b-Get-Approvers.png%22%20style%3D%22width%3A%20788px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F315190i54C8568DB4843D5E%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%223b-Get-Approvers.png%22%20alt%3D%223b-Get-Approvers.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENext%2C%20add%20an%20%22apply%20to%20each%22%20action%20and%20select%20value%20from%20the%20get%20items%20section%20of%20the%20dynamic%20content%20box.%20Next%20add%20a%20%22start%20and%20wait%20for%20an%20approval%20action%22.%20Enter%20the%20information%20requested%20and%20for%20the%20assigned%20to%20select%20Approver%20from%20the%20gert%20items%20section%20of%20the%20dynamic%20content%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%224-Apply-StartWaitApproval.png%22%20style%3D%22width%3A%20636px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F315191i57C28A61E30C4FE2%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%224-Apply-StartWaitApproval.png%22%20alt%3D%224-Apply-StartWaitApproval.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnce%20the%20approval%20has%20been%20done%20we%20want%20the%26nbsp%3B%20item%20in%20the%20list%20updated%20with%20the%20details%20of%20the%20approver%20and%20any%20comments%20they%20made.%20So%20still%20inside%20the%20apply%20to%20each%20add%20an%20%22update%20item%22%20action%20and%20for%20the%20columns%20that%20hold%20the%20approval%20details%20you%20select%20these%20from%20the%20start%20and%20wait%20for%20an%20approval%20section%20of%20the%20dynamic%20content%20box.%20When%20you%20select%20responses%20comments%20you'll%20see%20that%20the%20actio%20wraps%20itself%20in%20another%20apply%20to%20each.%20This%20is%20expected.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%225-Apply-Update.png%22%20style%3D%22width%3A%20830px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F315193iFCBA19BDE9CBD264%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%225-Apply-Update.png%22%20alt%3D%225-Apply-Update.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20when%20the%20user%20adds%20an%20item%20to%20the%20list%20the%20flow%20will%20trigger%20and%20an%20email%20will%20be%20sent%20to%20the%20approver.%20This%20is%20in%20the%20form%20of%20an%20adaptive%20card%20which%20means%20the%20approver%20can%20select%20their%20decision%20and%20add%20any%20comments%20right%20within%20the%20email.%20tghey%20need%20to%20do%20this%20within%2030%20days%20or%20the%20approval%20times%20out%20and%20fails.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%226-Adaptive-Card-Email.png%22%20style%3D%22width%3A%20779px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F315204i6EC3A6303B44B6A1%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%226-Adaptive-Card-Email.png%22%20alt%3D%226-Adaptive-Card-Email.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20when%20the%20approvers%20clicks%20the%20submit%20button%20the%20adaptive%20card%20closes%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%226b-Approval.png%22%20style%3D%22width%3A%20783px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F315195i66DEF76EC8FA7634%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%226b-Approval.png%22%20alt%3D%226b-Approval.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20flow%20carries%20on%20running%20and%20updates%20the%20list%20item%20with%20the%20approval%20details%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%227-SP-UpdatedList.png%22%20style%3D%22width%3A%20851px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F315196i7666C799CC5E4F17%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%227-SP-UpdatedList.png%22%20alt%3D%227-SP-UpdatedList.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EInstead%20of%20the%20update%20item%20action%20you%20could%20get%20the%20approval%20details%20added%20to%20a%20table%20in%20Excel.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECome%20back%20with%20any%20questions%20about%20this.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hello all,
I would like to introduce some kind of approval procedure in sharepint. I would like that when an object is edited, it is sent to an approver beforehand who then approves it. The requestor and approver should be entered in an excel list with date and time. do you know a simple solution? thank you very much.

1 Reply
best response confirmed by Tison5 (New Contributor)
Solution

@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.

 

1-SP-List-Approvers.png

 

The user adds a new item to the main list:

 

2-SP-List-Approvals.png

 

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.

 

3a-Trigger-Var.png

 

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}'

 

3b-Get-Approvers.png

 

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:

4-Apply-StartWaitApproval.png

 

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.

 

5-Apply-Update.png

 

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.

 

6-Adaptive-Card-Email.png

 

And when the approvers clicks the submit button the adaptive card closes:

 

6b-Approval.png

 

The flow carries on running and updates the list item with the approval details:

 

7-SP-UpdatedList.png

 

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