Power Automate Tutorial - SharePoint

If you have not read the Power Automate Integration article, please read that first before beginning this tutorial. Once the Parse JavaScript Object Notation (JSON) Connector is set up, you can take the form data and integrate it into other back-end systems. This tutorial is focused on SharePoint integration and more specifically, the Create Item connector.

In this example, we have created a Vehicle Inspection report and want to capture the form data in a SharePoint list.

Create a SharePoint List

1. Click Settings and select Site contents
   
   
2. Click + New and select List from the drop-down menu
   
3. Select Blank List
   
4. Type a Name for the list, and optionally, type a Description (if available)
   
5. Click Create
   
   
6. When your list opens, you can click + Add column to add the columns which will collect your form data
   

Once you have created a SharePoint List and added some columns, you can go back and create the Flow

SharePoint Connector

1. Navigate to the Power Automate website and sign in
   
2. Navigate to the Connectors tab in the left-hand menu
   
3. Search for the SharePoint connector
   
4. Click the when an item is created option
   
5. Add the Site Address and the List Name will pre-populate. Once the List name is selected, the list columns will become available
   
6. Click + New Step
   
7. Choose an operation
   
8. Then it is just a matter of connecting the correct Form Element name and the Column name
   
   
   Note: The form fields will vary depending on the operation chosen.
9. Click Save
   
10. Click Test (beaker icon)
    
11. Choose a Test Flow option
    
12. On the bottom right-hand panel, click Test
    
13. If the flow runs successfully a green notification will pop up