Association networking tools can really boost the sense of empowerment among your members. A modern, flexible system should be able to offer a range of compelling networking options that are intuitive for users.
One of our past webinars, Using the Microsoft Power Platform: A Real World Example for Associations, deals with this directly. We show how organizations can combine Cobalt’s AMS product functionality with Microsoft’s Power Platform. The net result is an association networking software experience for your members without any custom development on your part.
In this article, I’ll expand on the possibilities of Microsoft Power Automate for association networking and give a more detailed look at how this could work for your organization. I’ll touch on utilizing the strengths of Power BI and other software solutions under the Power Platform. The solutions often go hand-in-hand for maximum effectiveness.
Combining Two Powerful Toolsets
Cobalt’s association management software (AMS) is built on top of Microsoft Dynamics 365. Our customers get the features included in Cobalt’s out-of-the-box solution AND those included in Microsoft’s Power Platform.
In our Power Automate webinar, we demonstrate how this can work through a real-world example. The solution we showed uses the Power Platform to facilitate a “membership matching” service for professional networking. Here’s how it works at a high level.
- Members create a profile with certain information about themselves, like their job title, professional development interests, industry, etc.
- Once they’ve set up their profile, they can submit match requests where they detail the qualities of a person they are looking to network with, the person they want to mentor — or be mentored by.
- The solution then uses Power Automate (part of the Power Platform) to go through all of the profiles and finds a profile that matches the criteria in the request.
- Automated email notifications are sent out.
This solution requires very little upkeep— an organization can set it up once and never think about it again, but it will continue to provide value to members.
But before we get any further into the weeds on how we pulled this off, let’s take a step back to go over the basics.
What is the Power Platform?
Microsoft’s Power Platform is comprised of five different products. These different products allow business users to build end-to-end business solutions in a no-code or low code environment (i.e. you don’t need to be a developer).
The five Power Platform products are:
What is Microsoft Power Automate?
Power Automate, formerly known as Microsoft Flow, is a cloud-based service that allows users to create and automate workflows between different applications, services, and systems. In the simplest terms, this is how organizations can set up varying levels of automation. Organizations can basically set up their own “if then” statements that will trigger workflows or actions.
With Power Automate, you can make a wide range of tasks and processes more efficient without the need for extensive coding or programming skills. It offers a user-friendly interface that enables you to set a combination of triggers, conditions, and actions throughout your flow.
If you already have a Dynamics 365 license, you probably also have a free license included for Power Automate and the rest of the Power Platform, but for more information on pricing for licenses, check out our breakdown and analysis here. As always, if you have questions or need clarification on what the best option is for you, our team is here to help.
Easy, Powerful Power Automate Applications for Associations
The matching solution uses Power BI to analyze the data collected during the sign-up and request process, but the matching itself is done by Power Automate.
As the automation arm of the Power Platform, Power Automate is great for creating statements that follow the “when this happens… do this thing” logic.
Like any creative process, getting started with your flow outline can be challenging. But get this – as of 2023, Power Automate now leverages natural language processing technology so that you can type out exactly what you want the flow to do. The AI tool will help to create a starting template for you.
You can customize it further as needed, but this has already been a huge time saver during the build process! Even better, we’re seeing the same type of technology being implemented in Power Apps, Power Virtual Agents, and Power BI. We love this extended accessibility for those of use who are new to the game.
Here are a few easy ways associations can use Power Automate to automate certain tasks:
- Send out a survey to a class attendee once they’ve attended a class using Microsoft’s Customer Voice.
- Notify the marketing team when a tweet that mentions your organization with a negative sentiment is posted.
- Extracting information from email attachments or business cards. After the info is extracted, you could update records in your CRM or send an email notification with the details.
- Send a final approval to a CEO or Membership Director when granting certain memberships.
- Syncing data between platforms, such as updating an Excel spreadsheet with CRM data.
How Can Power Automate Facilitate Association Networking?
Back to the example in our webinar, you can also use Power Automate for more complicated processes that involve querying data. That includes things like matching membership match requests with relevant profiles. Here is the logic of our membership match (MM) automation we used for the webinar.
- Kick off when a membership match request is submitted,
- “Read” the requested criteria, like requested area of expertise, requested role, requested international preference, etc.
- Find MM profiles with corresponding criteria.
- If the MM request shows the contact is looking to do some general networking with someone who has an expertise in technology, the automation would bring back an active MM profile of someone who has an expertise in technology who is also looking to do some general networking.
- If the MM request shows the contact is looking for a mentor who has an expertise in technology, the automation would bring back an active MM profile of someone who has an expertise in technology who is interested in being a mentor.
- Randomly select an active MM profile with the correct criteria.
- If the relationship of the contacts is an “equal” one (Ex: both people are looking to do some general networking), set the randomly selected profile on the request and send an email notification to both people alerting them of the new match.
- This will make the match appear in the ‘My Matches’ grid on the portal.
But How Did We Add the Approval Step?
- If the relationship is not equal (ex: the requestor is looking for a mentor), send the request through an approval step that requires the potential mentor to approve the request. The request is sent to the potential mentor’s inbox and can be configured to include relevant information.
- If the mentor approves the request, the contacts will be matched and both people will be notified of the new match and will appear on the ‘My Matches’ grid on the portal for both parties.
- If the mentor rejects the request, the automation will start over and the request will be sent back through the process to be matched with another potential mentor.
As a side note, you can also use an Approval Flow template offered in Power Automate for any sort of request. For example, perhaps one of your member types requires staff review before membership activation.
How Else Can My Association Utilize Microsoft Power Automate?
Someone can debunk me here, but the possibilities are seemingly endless.
Some associations offer interest groups or online communities. A flow could be created to analyze customer engagement behavior; what events do they attend, what is their job title and industry, what interests have they indicated in their profile?
Then, make suggestions via email or text message to the member in real time. Similarly, boost your event revenue by suggesting specific events that a member would be intrigued by.
We’ve also seen an uptick in associations who want to issue certificates virtually for attending a course or passing an exam. Easy peasy! We already have you covered in our Power Automate Custom Word Templates blog.
Since we’re on the topic of Power Automate, I should at least mention that there are hundreds of free integration possibilities you have with the platform. Connect apps like D365 CRM, Excel, LinkedIn, HubSpot, and more. There are so many ways that The Power Platform could be making day-to-day operations for your association staff easier.
One of the things our association partners count on Cobalt for is to help them see the best ways to take advantage of all the powerful components inside Dynamics 365 and The Power Platform. Association networking options are just a few of the possibilities we can dig into. Let’s connect for a quick introductory call soon to answer your questions and highlight efficiencies for your team!