Tech@ProSiebenSat.1
ProSiebenSat.1 Tech Blog
7 min readOct 29, 2024

--

By Aleksandar Culafic​

How to Greeting Bot

Automating the onboarding process in organizations can significantly improve efficiency and team dynamics. A greeting bot, developed with Power Automate, introduces new team members in Microsoft Teams channels on a regular and structured basis.

What is Power Automate?

“Power Automate” is a tool for automating workflows, focused on avoiding repetitive tasks and optimizing processes. It is part of the “Power Platform,” a comprehensive platform made up of several tools that work together to meet various business requirements. The bot sends automated messages on the 1st and 15th of each month to introduce new colleagues. These messages include names, departments and job titles. These personalized greetings ensure that the entire team is informed about new members and that they feel welcomed right from the start.

Benefits of Using Power Automate

Power Automate allows to create custom workflows without in-depth programming knowledge. The flow is set to send messages only on specified days, excluding weekends or holidays. This increases the possibility that team members will see and engage with the messages.

The greeting bot significantly reduces the administrative workload for team administrators by automating manual tasks and ensuring consistent communication. This not only increases efficiency, but also promotes a friendly and welcoming atmosphere in the team. New members feel welcome thanks to the personal approach. Overall, the bot strengthens the team dynamics, improves internal communication, and saves time.

Creating the Welcome Message

When drafting the welcome message, several requirements must be met:

· Clear structure: the message should be clear and well-organized for easy readability

· Personalization: Include personalized information, such as names, departments and working titles of new members

· Relevant content: It should list all relevant details about new employee onboarding that are of interest to the team

· Adaptability: The message should align with the company’s specific needs

· Courtesy and professionalism: Maintain a friendly and professional tone

· Visual design: Use appealing visual elements or formatting where appropriate to increase reader attention

Who we are and what we do

We are the process automation team and act as an internal Center of Excellence (CoE) that establishes and develops process automation within the Group. We aim to build a citizen developer community in order to integrate automation directly into the teams.

As a point of contact, we assist in creating apps and workflows. For complex projects with high return on investment potential, we also offer full development services. In such cases, we go through the entire process step by step together with the contact person. We document, scrutinize, and analyze the individual steps to determine whether and how automation can be implemented sensibly and profitably. Our approach ensures a thorough and targeted implementation that meets the Group’s requirements and objectives.

Our process automation team

Philipp Slupina
Lead​
Roland Geropp
Automation Expert​
Gregor Holert
Automation Expert​
Aleksandar Culafic​
Working Student​

Targeted audience

This article targets anyone interested in implementing a greeting bot with using Power Automate to welcome new members to the company. In particular, the target group includes users who want to develop an automated solution to optimize the onboarding process and facilitate the integration of new team members. Especially for people who already have basic knowledge of Power Automate and have or want to develop concrete ideas for implementing a greeting bot.

Requirements

Power Automate / Microsoft account: A Microsoft account is required to access Power Automate, with the appropriate permissions. This must be assigned.

Microsoft Teams access: The bot will be used in a Microsoft Teams channel, so it must have the necessary access rights and permissions in Teams.

Understanding of the workflows: A basic understanding of Power Automate and its functionality is important. This includes creating and managing flows and working with triggers and actions.

Teams channel management: Basic knowledge of managing and configuring Teams channels is helpful.

Testing the flow: Thoroughly test the flow in a test environment to ensure it works as desired and no errors occur.

Documentation: Create documentation on how the bot works and how to configure the flow.

Training: Train the relevant team members on how to use the bot and manage the flow.

Microsoft Teams serves as an example, but the bot can also be used in other communication tools as long as the corresponding Power Automate connectors are available.

Implementation process

The greeting bot is designed to be activated regularly, such as on the 1st or 15th of a month, to automatically introduce new team members in a Teams channel. First, the flow checks whether the current day is a working day to avoid sending messages on weekends or public holidays. If this condition is met, the flow accesses central data sources such as the Teams Admin Center, SharePoint, or other databases to retrieve the names, departments, and job titles of the new team members, for example.

Based on this data, the bot creates a structured and personalized welcome message that can be tailored to the company’s specific requirements. This message is then automatically posted in the Teams channel, informing the entire team about the new members. This fosters a consistent and friendly welcome culture and helps integrate new members into the team.

The development of this greeting bot begins with logging into Power Automate and creating a new scheduled flow. The flow is configured to trigger only on specified days and working days. Next, relevant data sources are integrated to obtain information about the new team members. Once the message template is created and the exact requirements have been agreed with the relevant department, the flow is tested in a test environment to ensure it works correctly. After successful testing, the flow is implemented in the production environment and monitored regularly to ensure smooth and efficient communication.

As visualized in Image 1, the graphic shows our implementation process for the greeting bot. It illustrates the individual steps and processes involved in setting up and implementing the bot. This serves as an example of our own implementation.

Image 1: Implementation process for the greeting bot

Challenges

Implementing such a project comes with many challenges, many of which only become apparent during execution.

One challenge is checking for weekends and public holidays, as shown in Image 2. The graphic shows a loop that stores the current date. This date is then compared with a list in SharePoint that contains public holidays. It also checks whether the saved date falls on a Saturday or Sunday.

If the date falls on a weekend or public holiday, a delay of 24 hours (one day) is inserted. Once the delay expires, the date is checked again. This process repeats until a working day is found. Only when a valid working day is identified does the flow continue.

This method ensures that the greeting bot sends messages only on working days, thus optimizing the effectiveness of the greetings.

Another challenge is formatting the post itself. The result is created in Power Automate using HTML, a programming language. Previous experience with HTML is a great advantage here. Variables such as name, date and lists must be formatted correctly and adapted accordingly in the programming language of Power Automate.

Image 2: Review of working days and public holidays

This requires precise adjustment of the formatting in the text to ensure that the end result meets the desired standard. Incorrect formatting can lead to confusing or incomplete messages, so correct application is essential to achieve the result as shown in Image 3.

Image 3: Sample greeting

Conclusion

The greeting bot developed with Power Automate is a valuable solution for improving the integration of new employees into teams. It automates the welcome process, creating consistently structured and personalized communication that ensures a positive welcome culture.

Automation reduces administrative burdens while ensuring that new team members are introduced efficiently and consistently. This contributes to a harmonious working environment and helps new colleagues integrate quickly into the team. The greeting bot therefore proves to be a useful tool for promoting internal communication and increasing efficiency within the company

--

--

ProSiebenSat.1 Tech Blog
ProSiebenSat.1 Tech Blog

Published in ProSiebenSat.1 Tech Blog

We make digital entertainment happen! Reaching millions of viewers and users each day is the basis of our success. Creating real emotions among our viewers and users, we develop first-class products and take our technology to the next level every single day. 🎬

Tech@ProSiebenSat.1
Tech@ProSiebenSat.1

Written by Tech@ProSiebenSat.1

Turn code into experience @P7S1 and join us 👉 bit.ly/3kNWJns

No responses yet