• Support
  • Careers
Hentsu
  • Solutions
    • Collaboration
    • Data
    • Applications
  • About Us
    • Powered by Code
    • Our Story
    • Our Partners
      • Amazon Web Services
      • Microsoft Solutions Provider
      • Google Cloud Platform
    • Team
    • Hentsū People
    • Join Our Team
  • Blog
  • Case Studies
  • Events
  • Contact
Select Page

Case Study: Microsoft Power Automate and Teams Collaboration

[et_pb_section fb_built="1" admin_label="The Challenge" _builder_version="4.1" collapsed="on"][et_pb_row _builder_version="4.1" collapsed="off"][et_pb_column type="4_4" _builder_version="4.1"][et_pb_text _builder_version="4.1"]

 The Challenge 

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure="3_5,2_5" _builder_version="4.1" collapsed="off"][et_pb_column type="3_5" _builder_version="4.1"][et_pb_text _builder_version="4.1"]

Hentsū has identified an opportunity to enhance internal communications in a way that fosters quality of life and reduces e-mail chatter. In this case study, we will be covering Power Automate use cases, as well as MS Teams collaboration, workflow automation, and more. The use of automated flows delivered through Teams channels allows Professional Services, DevOps, Managed Services, and Client Relations to communicate in a fluid and natural setting. Relying on an email to be manually composed after a priority incident or anomaly has been detected, leaves a single point of human failure open. 

Hentsū has decided to automate our client’s service escalations and high priority incidents through Power Automate. Formally known as Microsoft Flow, this platform streamlines communications between third-party and Microsoft apps to enhance productivity and reduce manual overhead. Think of Power Automate as a cloud-based algorithm service, that combines sets of flows to reduce manual or repetitive work that is often associated with reporting and communications between applications. This solution has also been curated internally for Bitbucket repository notifications related to merge or pull requests, as well as informative tech news updates.  

[/et_pb_text][/et_pb_column][et_pb_column type="2_5" _builder_version="4.1"][et_pb_text _builder_version="4.1" background_color="#ffbb22" custom_margin="0px|||0px|false|false" custom_padding="20px|20px|10px|20px|false|false" locked="off"]

REQUIREMENTS

  • Remove the risk associated with manual email communications
  • Fully automated alerting of priority incidents, service escalations, modifications to in-house code repositories and change control requests
  • Encourage MS Teams channels to be used as the primary internal communication vector between internal departments
  • Reduce e-mail traffic
  • A cloud-based technology news alert platform within MS Teams
  • Sufficient M365 licensing is required to support the solution
  • Overall workflow automation
[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" admin_label="CTA" _builder_version="4.1" collapsed="off"][et_pb_row _builder_version="4.1"][et_pb_column type="4_4" _builder_version="4.1"][et_pb_text _builder_version="4.1" locked="off"]

DOWNLOAD THIS CASE STUDY

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" admin_label="Key Considerations " _builder_version="4.1" background_color="#333333" collapsed="off"][et_pb_row _builder_version="4.1" width="90%" custom_padding="10px|0px|10px|10px|false|false"][et_pb_column type="4_4" _builder_version="4.1"][et_pb_text _builder_version="4.1" ol_font="|600|||||||" ol_text_color="#ffbb22" custom_padding="20px||||false|false"]

document icon Key Considerations 

  1. Identifying the triggers required to initiate each flow 
  2. Locating the compatible Jira Service Desk and Bitbucket APIs/Webhooks required to establish secure connections to Power Automate 
  3. Designating the purpose for each O365/Teams group and which members to be included in each 
  4. Hentsū staff were already accustomed to MS Teams and its many collaboration features
[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" admin_label="The Solution" _builder_version="4.1" collapsed="off"][et_pb_row _builder_version="4.1"][et_pb_column type="4_4" _builder_version="4.1"][et_pb_text _builder_version="4.1" hover_enabled="0" custom_padding="30px||||false|false"]

 The Solution - Workflow Automation  

[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row column_structure="1_2,1_2" _builder_version="4.1"][et_pb_column type="1_2" _builder_version="4.1"][et_pb_text _builder_version="4.1" background_color="#ffbb22" custom_margin="0px|||0px|false|false" custom_padding="20px|20px|10px|20px|false|false" locked="off"]

TECHNOLOGIES USED 

  • AWS (Amazon Web Services), Microsoft Azure, Citrix, Duo Security, Zabbix, and FortiGate
    • All sending vendor PSIRT advisories to Microsoft Teams channels which inform Hentsū of required/emergency security patches and events
  • Atlassian (Jira & Bitbucket)
    • Service escalations and change control request notifications
  • RSS technology news feed subscriptions
    • Centralized to a single Teams channel to encourage technical discussions and debates
[/et_pb_text][/et_pb_column][et_pb_column type="1_2" _builder_version="4.1"][et_pb_text _builder_version="4.1"]Hentsū had reached a crossroads and identified that e-mail is not the most effective method to collaborate on service-related escalations and priority requests. Instead, we sought out to leverage the tools already available to us with our Microsoft 365 subscriptions to remove the human element from the detection of a variety of events. It was quickly evident that MS Teams with the help of Power Automate flows, has the capability to effectively tie the appropriate teams together and promote collaboration in an automated fashion. In short, workflow automation was achieved. We no longer had to rely on a single person(s) to detect a problem and manually loop individuals in through an e-mail chain. This can often be difficult to track. Alternatively, Power Automate would monitor our Jira Service requests and the bulk of our core technology vendors,’ based on the priority level.[/et_pb_text][/et_pb_column][/et_pb_row][et_pb_row _builder_version="4.1"][et_pb_column type="4_4" _builder_version="4.1"][et_pb_text _builder_version="4.1" custom_padding="||20px||false|false"]

These alerts are visible in the dedicated Teams channel and using group membership, the correct individuals are always included. In addition to workflow automation, our goal was to achieve consistency, both in the fashion that the alerts are delivered and the syntax in which they appear.

After designing the initial HTTP request-based flows from our vendors’ PSIRT advisory alerts and internal Jira ticketing system, we re-purposed the flows for other scenarios. Bitbucket repository updates, branch changes, commit/pull requests, and informational messages were integrated into Power Automate by modifying existing flow templates. This allowed our DevOps and Professional Services teams to collaborate and review one another’s code in an open channel that is inclusive to all team members. Members of these channels can modify their Teams chat notifications to be as informative as they would like.  

To add some alure and showcase the innovative solutions, we connected RSS news feeds to an internal channel dedicated to Cloud Technology News. This provides a consistent platform that engineers could use to stay up to date with the most recent news in our sector. This concept is quite attractive for Financial Services clients who are looking for curated news presented in a central location, relating to their corresponding sector(s). 

The beauty of these automated workflow solutions are their sustainability and re-usability. Using traditional e-mail has its benefits but does not have the consistency required by many developers and in-house technology teams.

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.1" background_color="#333333"][et_pb_row _builder_version="4.1" width="90%"][et_pb_column type="4_4" _builder_version="4.1"][et_pb_text _builder_version="4.1" custom_padding="20px||10px||false|false"]

  Technical Details 

During the planning phase, the most difficult challenge was deciding on the trigger that would actuate each flow. Though a simple HTTP request was used for most scenarios, each trigger required vigorous fine-tuning to ensure consistency across all platforms, especially for external vendors, due to the lack of insight into their internal systems. When using HTTP based webhooks, it is a challenge to figure out which applications expose their APIs. It is important to consider the limitations of Power Automate in relation to specific connections and the available actions associated with each. 

For our internal based Atlassian applications (Jira & Bitbucket), research and probing were required to locate the exposed APIs used to set off the desired webhook events. Once located, the Webhook URLs were used as an initial trigger for each flow. Observing the specific responses and behavior from each app was necessary to curate the final communications via Teams and reduce un-necessary chatter or errors. Defining the variables and deciding on how to initialize each variable within the flow was necessary to deliver an informative notification which makes sense. Specific actions or behaviors are associated to each defined variable based on certain conditions. For example, when a variable matches “Priority 1,” the flow will then take action to inform the relevant Teams channel with a matching event title. The output formatting for an event is directly related to the variables within each flow. The output message syntax for each event went through multiple revisions before being considered acceptable. 

One of the most important aspects of the project was to utilize malleable templates, which allow for exporting and re-use in similar scenarios. We designed the flows so that only select triggers and variables would need to be altered during future re-purposing efforts. The sustainability of a solution and its potential to be recycled, is one of the main requirements for the approval of a project within Hentsū. 

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.1"][et_pb_row _builder_version="4.1" custom_padding="30px||||false|false"][et_pb_column type="4_4" _builder_version="4.1"][et_pb_text _builder_version="4.1"]

 Caveats 

  • Users must be willing to default to MS Teams rather than email for alerting and reporting 
  • Not all applications and vendors have the required APIs exposed for webhooks to be utilized as a trigger 
  • A dedicated and licensed M365 service account is required to host the Power Automate flows 
  • Flows may require maintenance if the webhook call-backs or variables are altered 
[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section][et_pb_section fb_built="1" _builder_version="4.1" background_color="#333333"][et_pb_row _builder_version="4.1" width="90%"][et_pb_column type="4_4" _builder_version="4.1"][et_pb_text _builder_version="4.1" custom_padding="20px||10px||false|false"]

 Impact 

The choice to automate over a fixed platform comes with its advantages and disadvantages. Workflow automation is accomplished with this particular solution. Overall, the automated flows that Hentsū adopted have enhanced team collaboration and increased communication between our global departments. Reducing human error and relying on manual alerting processes is no longer a concern for most of our core systems. The ability to templatize the flows for re-use has added huge benefits and ensured sustainability of the solution. We are looking forward to the enhancement and up-cycling of these solutions for both internal and external use cases.

[/et_pb_text][/et_pb_column][/et_pb_row][/et_pb_section]

Date/Time

Date(s) - 01/01/1970
12:00 AM - 12:00 AM

Location

600 5th ave. NY, NY

Upcoming Events

  • Webinar Series: Pushing the Limits of Microsoft Modern Workplace7 Apr, 2020
  • The Trading Show Europe 201917 Oct, 2019
  • Charity Night At The Gallery25 Sep, 2019
More

hentsu pbi logo

Agile collaboration, Data and Applications for Financial Services. Cloud Delivered.

Solutions

Collaboration

Data

Applications

About Us

Powered by Code

Our Story

Our Partners

Team

Hentsū People

Join Our Team

Blog

All Posts

 

Case Studies

All Case Studies

Events

View All Events

 

Contact

Contact Us

  • Twitter
  • LinkedIn
  • instagram
  • YouTube
© 2019 Hentsu Ltd | Privacy Policy | Terms & Conditions | Your Privacy Settings
Hentsū to Join Portfolio BI

NEW YORK, NY February 23, 2021 | Portfolio BI, a leading provider of front-to-back solutions for order management, portfolio management, data management, and reporting for the buy-side, announced it has completed the acquisition of  Hentsū, a global provider of fully managed AWS and Azure cloud platforms for fund managers with on-demand applications, compute clusters, and connectivity to market data providers, brokers, and exchanges. The Acquisition will Strengthen and Expand Portfolio BI’s Offering to include FinTech Managed Cloud Services, Data Science, and DevOps.