This article shows you how to set up a Yammer group to collect feedback and ideas for continued improvement, and have one person in your organization notified immediately when a specific sentiment, such as positive or negative feedback is posted. This solution uses Azure Cognitive Services to analyze the posted messages, and uses Microsoft Flow to connect Yammer, Azure Cognitive Services, SharePoint Online and Outlook.
Once you have this integration set up with examples of positive and negative feedback, an email will be sent to a designated person whenever a negative message is posted so that a response can be posted quickly. You can easily modify the integration to send email to track other types of opinions.
This article has an associated flow package that is stored in the file DetectSentiment.zip.
Download the DetectSentiment.zip file from the Yammer technical community.
File | Description |
DetectSentiment.zip | Zip file containing a package for the flow that connects Yammer to Azure Cognitive Services. |
In this step, you create the Yammer group to post the messages to.
In a web browser, open https://www.yammer.com, and sign in with your organization account.
In Yammer, click + Create a group.
Click Create Group.
The newly created group is added in the left navigation.
In this step, you create a SharePoint list to store the sentiment data that Azure Cognitive Services uses to determine what is negative feedback.
Create a new list named SentimentAnalysis.
Create a Cognitive Service to perform sentiment analysis for the messsages posted in the Yammer group.
Enter a Name. For example: SentimentAnalysis
Select a Subscription.
Select a Location.
Select a Pricing tier For example: S0
Create a new Resource group.
Click the Create button.
A new Cognitive Services instance is created.
Select the Cognitive Service you just created. You will find it in the new Resource group.
In the RESOURCE MANAGEMENT section, click Keys.
Copy and save the NAME and KEY values, you will need them in subsequent steps.
In the RESOURCE MANAGEMENT section, click Keys.
Copy and save the NAME and KEY values, you will need them in subsequent steps.
Use the Yammer Sentiment flow zip file you downloaded in Step 1 and update it to work in your environment.
In a web browser, open https://flow.microsoft.com, and sign in with your work account.
Upload the package.
Enter the KEY you saved in a previous step for the Account Key.
Enter the Endpoint you saved in a previous step for the Site URL.
Use the previous steps as a guide to configure the remaining connections (shown in the red rectangles in the picture below). Refer to the screenshots below for all the connections to help you search for and locate the appropriate connections.
In the Group Id dropdown list, select the Yammer group you created earlier, then select the correct network.
Click the Create item node.
In the Site address dropdown list, select the SharePoint site where you created the SharePoint list.
In the List name dropdown list, select the Sharepoint SentimentAnalysis list you created.
Post message in Yammer discussion group to trigger the Yammmer Sentiment Analysis flow.
If you posted a negative message, an email is sent to the Inbox you configured.
Please note that it takes a few minutes for the flow to execute after the messages are posted to Yammer.
Thank you to Todd Baginski, Microsoft MVP, and Chris Bortlik for developing this integration.