Exercício: Guarde uma resposta do Microsoft Forms no SharePoint List.

Índice

1. Lab 08: Save a Microsoft Forms response to SharePoint List.
2. Microsoft 365 user interface
3. Lab Scenario
4. Objectives
5. Instructions
   1. Before you start
      1. Sign in to the lab environment
   2. Exercise 1: Create SharePoint document library
   3. Exercise 2: Create SharePoint document library

---

Lab 08: Save a Microsoft Forms response to SharePoint List.

Atenção: Os exercícios não estão escritos em português por norma todo o conteúdo criado pelo formador Ricardo Cabral é escrito em inglês utilizando a terminologia original.

Microsoft 365 user interface

Given the dynamic nature of Microsoft cloud tools, you might experience UI (User Interface) changes that occur after the development of this training content. As a result, the lab instructions and lab steps might not align correctly.

Cloud updates occur frequently, so you might encounter UI changes before this training content updates. If this occurs, adapt to the changes, and then work through them in the labs as needed.

Lab Scenario

In the previous lab you created a form in Microsoft Forms. Now you need to create a SharePoint List to store the form responses through an automated Power Automate flow.

Objectives

• Create a new SharePoint library to store form responses.
• Create an automated Power Automate flow to obtain responses from Microsoft Forms and save in the SharePoint library.

Instructions

Before you start

• You have to complete the previous exercise.
• You must have access to a Microsoft 365 account with SharePoint Online, Microsoft Forms and Power Automate.

Sign in to the lab environment

Use the credentials provider by the instructor.

Exercise 1: Create SharePoint document library

1. On the SharePoint site that you created in the first exercise, create a new SharePoint list to store the responses to the form created in the previous exercise.

2. The data type of the columns must be identical to the data type of the form questions.

Exercise 2: Create SharePoint document library

1. In Power Automate, search for Record form responses in SharePoint and select the template Record form responses in SharePoint.

   

2. Enable the necessary connectors and click the Continue button.

   

3. The template used does not have enough ability to automatically define which form and SharePoint to use. So the flow was to present that it has invalid paraments.

   

4. Change the flow trigger parameters with data from the form created in Microsoft Forms.

5. In the Get response details action, in the Form Id parameter, choose the name of the form. This action will process all the details of a received response.

6. A ação Create item vai guardar os dados da resposta processado na ação anteiror Get response details. Prencha os parametros

Properties	Action to be carried out
Website address	Choose SharePoint from the first exercise
List Name	Choose the SharePoint list created to store the responses
Other fields	Fill in according to the questions and answers you defined.

1. Change the flow name.

2. Save the flow.

3. Submit a new response in the form and check if it is stored in SharePoint.

4. Check the flow’s action history in Power Automate.

END OF LAB