{"id":431,"date":"2020-12-18T10:19:16","date_gmt":"2020-12-18T09:19:16","guid":{"rendered":"https:\/\/dynamiacs.com\/?p=431"},"modified":"2021-02-20T19:57:14","modified_gmt":"2021-02-20T18:57:14","slug":"multiple-approver-from-sharepoint","status":"publish","type":"post","link":"https:\/\/dynamiacs.com\/?p=431","title":{"rendered":"Multiple Approver from SharePoint"},"content":{"rendered":"\n

During the Covid-19 crisis, many companies were forced to send their employees’ workplaces to the home office overnight. <\/p>\n\n\n\n

Unfortunately, some business processes fail by the wayside, especially where the approval of documents such as incoming invoices or delivery bills was concerned.<\/p>\n\n\n\n

A possible solution is to create a corresponding list in SharePoint, in which information about the requestor and the approving person or group of persons is stored and the document is attached.<\/p>\n\n\n\n

The information about the approving person or person group can be mapped with the field type “Person or Group” with activated “Allow multiple Selection” option. <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Here in my example I react on a newly created entry in a corresponding SharePoint list. For this I use the standard SharePoint Connector and the trigger When an item is created<\/strong>.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

In order to use the action Start and wait for an approval<\/strong> correctly, a few steps have to be done before, because otherwise the Start and wait for an approval<\/strong> would be included in an Apply to Each function, because the SharePoint list would return more than one entry in the corresponding column of the type Person.<\/p>\n\n\n\n

To do this, I first initialize a variable using the action “Initialize a variable”. For this variable I use the type String.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

In order to get to the mail addresses to which the approval workflow should be sent, the first thing I need to do is include a Parse JSON<\/strong> action, which is performed in an Apply to each<\/strong> context on the Approver column.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

In the Parse JSON<\/strong> action I have to integrate the information from the When an item is created<\/strong> trigger. For this I use the function Generate from Example<\/strong> where I fill in the output of the When an item is created<\/strong> trigger. <\/p>\n\n\n\n

Here is the required JSON schema from my example.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

With this schema, I can then next use the Append to string variable<\/strong> action to populate the variable with the required mail addresses. To do this, I use the value for Email from the Parse Json<\/strong> step. <\/p>\n\n\n\n

It is important to add a semicolon after variable in the value field, otherwise there will be an error in the next step, because there is no listing of the mail addresses if there are more than one approvers.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Now the preparations are done so that the approval workflow can run correctly.<\/p>\n\n\n\n

In my example I use the Approve type Approve\/Reject – First to respond<\/strong> to make sure that only one person has to approve.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Next are a few screenshots from the example process I used. Here, 2 people were stored as possible approvers.<\/p>\n\n\n\n

First releasing person:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Second releasing person: <\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

After the second person has approved, the approval request updates with the first person, indicating that the approval has already been done by someone else.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

In my workflow, I have then updated the corresponding SharePoint list entry via the action “Update Item”, <\/strong>in order to be able to recognize by whom the release has been made.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Here is an overview of the update process.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

Finally I want to visualize the complete process:<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n

How cool is that \ud83d\ude09<\/p>\n","protected":false},"excerpt":{"rendered":"

During the Covid-19 crisis, many companies were forced to send their employees’ workplaces to the home office overnight.  Unfortunately, some business processes fail by the wayside, especially where the approval of documents such as incoming invoices or delivery bills was concerned. A possible solution is to create a corresponding list in SharePoint, in which information…<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":false,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","footnotes":""},"categories":[8],"tags":[50,51,34,52],"class_list":["post-431","post","type-post","status-publish","format-standard","hentry","category-blog","tag-approval","tag-powerautomate","tag-sharepoint","tag-variable"],"taxonomy_info":{"category":[{"value":8,"label":"Blog"}],"post_tag":[{"value":50,"label":"Approval"},{"value":51,"label":"PowerAutomate"},{"value":34,"label":"SharePoint"},{"value":52,"label":"Variable"}]},"featured_image_src_large":false,"author_info":{"display_name":"Jan","author_link":"https:\/\/dynamiacs.com\/?author=2"},"comment_info":0,"category_info":[{"term_id":8,"name":"Blog","slug":"blog","term_group":0,"term_taxonomy_id":8,"taxonomy":"category","description":"","parent":0,"count":38,"filter":"raw","cat_ID":8,"category_count":38,"category_description":"","cat_name":"Blog","category_nicename":"blog","category_parent":0}],"tag_info":[{"term_id":50,"name":"Approval","slug":"approval","term_group":0,"term_taxonomy_id":50,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"},{"term_id":51,"name":"PowerAutomate","slug":"powerautomate","term_group":0,"term_taxonomy_id":51,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw"},{"term_id":34,"name":"SharePoint","slug":"sharepoint","term_group":0,"term_taxonomy_id":34,"taxonomy":"post_tag","description":"","parent":0,"count":2,"filter":"raw"},{"term_id":52,"name":"Variable","slug":"variable","term_group":0,"term_taxonomy_id":52,"taxonomy":"post_tag","description":"","parent":0,"count":1,"filter":"raw"}],"_links":{"self":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts\/431","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=431"}],"version-history":[{"count":4,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts\/431\/revisions"}],"predecessor-version":[{"id":643,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=\/wp\/v2\/posts\/431\/revisions\/643"}],"wp:attachment":[{"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dynamiacs.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}