{"id":110965,"date":"2018-09-12T07:06:44","date_gmt":"2018-09-12T14:06:44","guid":{"rendered":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/"},"modified":"2018-09-12T07:06:44","modified_gmt":"2018-09-12T14:06:44","slug":"sending-pull-request-review-reminders-using-ms-flows","status":"publish","type":"power-automate","link":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/","title":{"rendered":"Advanced | Flow of the Week: Sending Pull Request review reminders using MS Flows"},"content":{"rendered":"

Hello Flow Fans!<\/p>\n

With the increasing number of code repositories it was getting difficult to keep track of Pull Requests (PRs) that need to be reviewed. As an effort to improve dev productivity and reduce PR wait times we created a simple flow using the Visual Studio Team Services (VSTS) connector to consolidate all PR links and send reminders to reviewers. Now, having a single email in their inbox every week with PRs to be reviewed saves everyone the hassle of navigating to each repository.<\/p>\n

Overview of the flow<\/strong><\/h1>\n
    \n
  1. Trigger the flow through Recurrence<\/li>\n
  2. Get the desired PRs using VSTS REST APIs<\/li>\n
  3. Parse response JSON<\/li>\n
  4. Iterate over reviewers list for each PR and prepare a dictionary of reviewer-PRs<\/li>\n
  5. Send emails to the reviewers with the list of PRs they need to review<\/li>\n<\/ol>\n

    The Flow in this article, sends emails to a filtered list of users to not spam members from other teams.<\/strong> This can be enhanced to send emails to users in an alias (not in scope of this article).<\/p>\n

    \"\"<\/p>\n

    \u00a0<\/p>\n

    First choose your Trigger<\/strong><\/h3>\n

    A recurrence trigger can be used as the aim is to send an email at regular intervals. \/you can set yours up like mine, or choose a schedule of your own.<\/p>\n

    \"\"<\/p>\n

    \u00a0<\/p>\n

    Now add an action to get Pull Requests from VSTS<\/strong><\/h3>\n

    The VSTS connector supports multiple actions; the one we used is called ‘Send an HTTP request to VSTS’. VSTS exposes hundreds of REST APIs https:\/\/docs.microsoft.com\/en-us\/rest\/api\/vsts\/?view=vsts-rest-4.1<\/a> at our disposal. We will leverage the Pull Requests APIs here.<\/p>\n

    \"\"\"\"<\/p>\n

    We use HTTP GET method to retrieve all active PRs where a particular reviewer was added. Account name is the Azure DevOps organization name (e.g. for jorg.visualstudio.com account name is jorg). Here, the query gets all the active pull requests where a particular reviewer has been added.<\/p>\n

    \"\"<\/p>\n

    \u00a0<\/p>\n

    Next we will add an action to Parse the JSON<\/strong><\/h3>\n

    The output is then parsed using the ‘Parse JSON’ connector. You can use a sample payload to generate schema as the response json structure could be complicated.<\/p>\n

    \"\"<\/p>\n

    \u00a0<\/p>\n

    Iterate over PRs<\/strong><\/h3>\n

    After which we iterate over all the PRs and reviewers to prepare a dictionary of Users and PRs.<\/p>\n

    \"\"<\/p>\n

    \u00a0<\/p>\n

    Iterate over reviewers for each PR<\/strong><\/h3>\n

    At this step, the reviewer list for each PR it iterated through and we prepare a Reviewer-PR map. E.g.<\/p>\n

    {
    \n“reviewer1_alias”: [
    \n“<tr>\\n<td>PR Title 1 <\/td>\\n<td>requester1<\/td>\\n<td > Pending review<\/td>\\n <td>     https:\/\/url1\\n<\/td>\\n<\/tr><\/a> ”
    \n],
    \n“reviewer2_alias”: [
    \n“<tr>\\n<td>PR Title 2 <\/td>\\n<td>requester2<\/td>\\n<td > Waiting for author<\/td>\\n <td>     https:\/\/url2\\n<\/td>\\n<\/tr><\/a> “,
    \n“<tr>\\n<td>PR Title 3 <\/td>\\n<td>requester2<\/td>\\n<td > Pending review<\/td>\\n <td>     https:\/\/url3\\n<\/td>\\n<\/tr><\/a> ”
    \n]
    \n}<\/p>\n

    \"\"
    \n    \"\"<\/a><\/p>\n

    \u00a0<\/p>\n

    \u00a0<\/p>\n

    \u00a0<\/p>\n

    \u00a0<\/p>\n

    \u00a0<\/p>\n

    \u00a0<\/p>\n

    \u00a0<\/p>\n

    \u00a0<\/p>\n

    \u00a0<\/p>\n

    \u00a0<\/p>\n

    \"\"<\/p>\n

    An extension here could be to check if the comments from the reviewer have been resolved or not.<\/p>\n

    \u00a0<\/p>\n

    Send email<\/strong><\/h3>\n

    To each of the above reviewers in the dictionary, we can use the\u00a0 ‘Send an email’ action with the outlook connector and pass in our parsed items. The email looks as follows.\"\"<\/p>\n

    Thanks for reading! Hope this helps improve dev productivity in your team as well. Please leave comments for any improvements or enhancements or questions you may have!<\/p>\n

    \u00a0<\/p>\n","protected":false},"excerpt":{"rendered":"

    Hey Flow Fans! Have you wanted to send automated PR Reminders out to your team? Look no further and follow along as Jyoti, one of the Microsoft Flow Engineers guides you through creating the Flow!<\/p>\n","protected":false},"author":355,"featured_media":0,"comment_status":"open","ping_status":"open","template":"","power-automate-category":[2590],"power-automate-tag":[2441,2591,2599],"coauthors":[2934],"class_list":["post-110965","power-automate","type-power-automate","status-publish","hentry","power-automate-category-flow-of-the-week","power-automate-tag-advanced","power-automate-tag-flow-of-the-week","power-automate-tag-fotw"],"yoast_head":"\nAdvanced | Flow of the Week: Sending Pull Request review reminders using MS Flows - Microsoft Power Platform Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Advanced | Flow of the Week: Sending Pull Request review reminders using MS Flows - Microsoft Power Platform Blog\" \/>\n<meta property=\"og:description\" content=\"Hey Flow Fans! Have you wanted to send automated PR Reminders out to your team? Look no further and follow along as Jyoti, one of the Microsoft Flow Engineers guides you through creating the Flow!\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/\" \/>\n<meta property=\"og:site_name\" content=\"Microsoft Power Platform Blog\" \/>\n<meta property=\"og:image\" content=\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2018\/09\/Pull_Request_Review_reminder_flow.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 min read\" \/>\n\t<meta name=\"twitter:label2\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data2\" content=\"Jyoti Pandey\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/\",\"name\":\"Advanced | Flow of the Week: Sending Pull Request review reminders using MS Flows - Microsoft Power Platform Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2018\/09\/Pull_Request_Review_reminder_flow.jpg\",\"datePublished\":\"2018-09-12T14:06:44+00:00\",\"dateModified\":\"2018-09-12T14:06:44+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/#primaryimage\",\"url\":\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2018\/09\/Pull_Request_Review_reminder_flow.jpg\",\"contentUrl\":\"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2018\/09\/Pull_Request_Review_reminder_flow.jpg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Power Automate\",\"item\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Advanced | Flow of the Week: Sending Pull Request review reminders using MS Flows\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"name\":\"Microsoft Power Platform Blog\",\"description\":\"Innovate with Business Apps\",\"publisher\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization\",\"name\":\"Microsoft Power Platform Blog\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"contentUrl\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png\",\"width\":194,\"height\":145,\"caption\":\"Microsoft Power Platform Blog\"},\"image\":{\"@id\":\"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Advanced | Flow of the Week: Sending Pull Request review reminders using MS Flows - Microsoft Power Platform Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/","og_locale":"en_US","og_type":"article","og_title":"Advanced | Flow of the Week: Sending Pull Request review reminders using MS Flows - Microsoft Power Platform Blog","og_description":"Hey Flow Fans! Have you wanted to send automated PR Reminders out to your team? Look no further and follow along as Jyoti, one of the Microsoft Flow Engineers guides you through creating the Flow!","og_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/","og_site_name":"Microsoft Power Platform Blog","og_image":[{"url":"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2018\/09\/Pull_Request_Review_reminder_flow.jpg","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"2 min read","Written by":"Jyoti Pandey"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/","name":"Advanced | Flow of the Week: Sending Pull Request review reminders using MS Flows - Microsoft Power Platform Blog","isPartOf":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/#primaryimage"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/#primaryimage"},"thumbnailUrl":"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2018\/09\/Pull_Request_Review_reminder_flow.jpg","datePublished":"2018-09-12T14:06:44+00:00","dateModified":"2018-09-12T14:06:44+00:00","breadcrumb":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/#primaryimage","url":"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2018\/09\/Pull_Request_Review_reminder_flow.jpg","contentUrl":"https:\/\/powerautomateblogmedia.azureedge.net\/powerautomateblog\/2018\/09\/Pull_Request_Review_reminder_flow.jpg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/sending-pull-request-review-reminders-using-ms-flows\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/"},{"@type":"ListItem","position":2,"name":"Power Automate","item":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/power-automate\/"},{"@type":"ListItem","position":3,"name":"Advanced | Flow of the Week: Sending Pull Request review reminders using MS Flows"}]},{"@type":"WebSite","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#website","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","name":"Microsoft Power Platform Blog","description":"Innovate with Business Apps","publisher":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#organization","name":"Microsoft Power Platform Blog","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","contentUrl":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-content\/uploads\/2020\/03\/Microsoft-Logo-e1685482038800.png","width":194,"height":145,"caption":"Microsoft Power Platform Blog"},"image":{"@id":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/#\/schema\/logo\/image\/"}}]}},"distributor_meta":false,"distributor_terms":false,"distributor_media":false,"distributor_original_site_name":"Microsoft Power Platform Blog","distributor_original_site_url":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog","push-errors":false,"_links":{"self":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110965"}],"collection":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate"}],"about":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/types\/power-automate"}],"author":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/users\/355"}],"replies":[{"embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/comments?post=110965"}],"version-history":[{"count":0,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate\/110965\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/media?parent=110965"}],"wp:term":[{"taxonomy":"power-automate-category","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-category?post=110965"},{"taxonomy":"power-automate-tag","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/power-automate-tag?post=110965"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.microsoft.com\/en-us\/power-platform\/blog\/wp-json\/wp\/v2\/coauthors?post=110965"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}