Using Webhooks for Posting SharePoint Items into MS Teams with Flows

In my previous post, you would have seen posting the items into Microsoft Teams Channels as conversations using Microsoft Flows. The respective channels will be chosen by selecting the Teams service in the flow configurations.

In this post, let us try to achieve similar kind of functionality, but with a little different approach. As we are all aware that Microsoft Teams will support incoming webhook requests, let us try configuring the webhook URLs.

Webhook:

What is webhook? The external system which posts messages whenever data is available using the endpoint APIs.

How the webhook will help in Microsoft Teams? Take for an example, you are using Teams as a collaboration platform. You need to post data from multiple systems to the team channels for better collaboration. The webhook URL can be generated for a channel and can be shared with other external systems. Whenever the external system has the data for posting, the data will be sent to the teams using the API generated.

Post SharePoint Items into MS Teams using MS Flows

Posting SharePoint Items as Conversations in Microsoft Teams

Here let us see how to push the items from SharePoint into the Microsoft Teams Channels as conversations using Microsoft Flows. #MicrosoftTeams #MicrosoftFlow

This is simple, straight forward and out of the box approach. Microsoft Flow eases our job with out of the box configuration.

Consider a business scenario, whenever an item is created in the SharePoint repository, it has to be pushed into Microsoft Team’s channel for discussions. The following steps will helps you in configuring the flow out of the box.

Note: Assuming, the connections for teams and SharePoint services are being available in the Microsoft Flow portal. If not already created, you will be prompted to provide the account details when configuring the SharePoint or the Microsoft Teams components in the below steps. You can provide different or the same account details. The accounts to the SharePoint or Microsoft teams can also be configured on the Microsoft Flows portal by navigating to the connections component.

Steps Involved:

• Create a list in the SharePoint site.
• Create a channel in the Microsoft teams.
• Login to the Microsoft flows.
• Select the SharePoint service à "when an item is created" template.
• Provide the site details and list details.
• Click on New Step à Add an action option.
• Search for Microsoft teams and select it.
• Select Post Message option.
• From the drop down select the Microsoft Teams ID, Channel ID, and Message to be posted.
• Here, message to be posted can be customized. Click on the message text box and select the SharePoint item field by adding dynamic content. (picture shown below)

• Save the flow.

Test the Flow:

• Login to the SharePoint site and navigate to the list.
• Create an Item à Provide some data and save it.
• Login to the Microsoft Teams and navigate to the channel provided in the configuration.
• You can see the item created in the SharePoint list, posted as a conversation in the Team’s channel.