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
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"]
Key Considerations
- Identifying the triggers required to initiate each flow
- Locating the compatible Jira Service Desk and Bitbucket APIs/Webhooks required to establish secure connections to Power Automate
- Designating the purpose for each O365/Teams group and which members to be included in each
- Hentsū staff were already accustomed to MS Teams and its many collaboration features
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
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
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]