Post an MS Form response to MS Teams Channel using Cloud Flows

In this blog, we will learn how to quickly design a simple Cloud Flow to post a message in MS Teams Channel when a user submits a response using MS Form.

Step 1: Create an MS Form to get the responses from the targeted user.

Go to https://forms.office.com/ and click on New Form to create an MS Form.

Now, We will create MS Form that will take the Name, Age, Gender, Service ratting and comment which is optional as feedback.

Step 2: Create a Team and Channel to post the responses

Here, I am creating an Admin Team (Type — Private Team) that will be used by Management Team for organization.

Now, we will add the “Feedback Responses” channel to post responses in Admin Team.

Step 3: Create an Org Level Team that will be used by all team member to submit the responses (Optional — You can share the form via email or posted it on the website)

Now, we will add the MS Form tab in the newly created “Feedback Form” channel so that team members can submit responses directly from MS Teams.

After the channel is created, click on the + button on the top ribbon button to add a new channel tab.

Look for MS Form and click to select the type of channel tab.

Select Add existing form and choose your created Feedback form.

After clicking on the Save button, a new Form Tab will be added to the feedback from channel of your Org Level Teams

Check if Team, Channel and Form tab is visible from other users

Log in with another and open the Team. Here, I have another user who has access to the Project Name team and Org Team but doesn’t have access to Admin Team as it Private Team for Management. Below is a screenshot for the same:

Step 4: Create a Cloud Flow to post the response to the Private Teams channel

Login to the Power Automate portal and create an Automated Cloud Flow

Look for MS Form Trigger “When a new response is submitted” and click on Create to create Cloud Flow

Select the Form in Cloud Flow trigger

Add new step Get Response Data from MS Form Connect and select Response Id from triggering body

Now, add a new step from Teams Connector Post a message (v3) to post the response in Teams Channel

Configure the Team, Channel and Message (According to your requirement)

Testing

I have submitted the response from the MS Teams using another user:

After submitting the response we get the message in the Admin Teams:

Hope this helps!!!