Power Automate With MS Forms, SharePoint And Teams

Introduction

 

This article is about integrating Power Automate with Microsoft Form, SharePoint, and Teams. We’ll create a Microsoft Form and submit responses to SharePoint, then create an Adaptive Card in Teams using Power Automate.

 

Create Microsoft Forms

 

First, you need to login here and create a New Quiz under My forms section. Provide the title of your quiz forms and start creating form by adding new fields.

 

 

Below is the "SharePoint Questionnaire" form that I’ve created for this article.

 

 

The second step is to create a SharePoint list for storing the responses from SharePoint Questionnaire quiz forms. I’ve created the new list "SharePoint Quiz" and added the columns which we’ve in MS forms. Below is the SharePoint list which looks like:

 

In the third step, we are going to create Power Automate. you need to login to https://flow.microsoft.com/ using your tenant account. Select "6 Templates to simplify common classroom tasks" template from Featured template collections.

 

 

You can see there are many readily available templates. We need to select "Notify me and store the responses when a student completes a quiz" from seeing when assignments are ready section.

 

 

Click on the "Add" button and you can see all the connections will be used in this Power automate.

 

Click on the "Continue" button to create the Power Automate and our flow is ready with a pre-defined template.

 

 

In the first section of flow, we need to select the Microsoft Forms in Form id dropdown that we created earlier. In my case, it is the "SharePoint Questionnaire".

 

 

In the next section, the user will be notified about the new quiz response along with all the details. You can configure the Subject and Body of the email as per your requirements. Also, you can add the dynamic contents from quiz forms in the email body. Here is what I’ve configured for this article.

 

 

Now, we’re going to store quiz forms responses to the SharePoint list. There will an action called "Create item". Select your SharePoint site and list from the dropdown. You need to select the dynamic contents from quiz forms and align it with SharePoint list columns.

 

 

Now, we are going to create Adaptive Cards in MS Teams. For this, add an action below the create an item and select "Post your own adaptive card as the Flow bot to a user (preview)" action from Microsoft Teams.

 

 

There will be a two-section that we need to provide information to create Adaptive Cards. One is Recipient and the other is Message. In Recipient, need to provide the email address of flow author and in Message, need to pass Adaptive Card JSON.

 

To get the JSON of Adaptive Card, log in to here and click on the Designer menu from the top bar. Design your Adaptive Card as per your requirements. Below is the sample of Adaptive Card design where you need to provide SharePoint site URL reference on the View button. The card contents will be coming dynamically from the SharePoint list.

 

Copy card JSON and paste it to the "Message".

 

 

Here is how the Adaptive Cards section look:

 

 

Now, its time to Save the flow, run, and test it. For testing the flow, fill the SharePoint Questionnaire quiz form, and submit it.

 

 

You can see that the quiz form response is submitted to the SharePoint list.

 

 

The user will get notified that the new quiz response is submitted along with all the details.

 

 

Finally, the Adaptive Card will be sent to the user on MS Teams.

 

 

Hope you enjoyed this article and are able to implement it as per your business requirements. Happy Learning!