Power Automate Tutorial - SharePoint

Prev Next

If you have not read the Power Automate Integration article, please read that first before beginning this tutorial. Once the Parse 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 contentsSettings menu, Site Contents.

  2. Click + New and select List from the drop-down menu New menu, list.

  3. Select Blank List Blank list template.

  4. Type a Name for the list, and optionally, type a Description (if available) Name and Description fields.

  5. Click CreateCreate button.

  6. When your list opens, you can click + Add column to add the columns which will collect your form data Add column button.

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 Power Automate website, sign in button.

  2. Navigate to the Connectors tab in the left-hand menu Left-hand menu, connectors tab.

  3. Search for the SharePoint connector Connectors search box, SharePoint tile.

  4. Click the when an item is created option SharePoint, 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 Site address and list name text boxes.

  6. Click + New Step Add new step button.

  7. Choose an operation Choose an operation.

  8. Then it is just a matter of connecting the correct Form Element name and the Column nameConnect the form element to the column name.

    Note: The form fields will vary depending on the operation chosen.

  9. Click Save Save button.

  10. Click Test (beaker icon) Flow test button (beaker icon).

  11. Choose a Test Flow option Test flow options.

  12. On the bottom right-hand panel, click Test Bottom right-hand panel, test button.

  13. If the flow runs successfully a green notification will pop up Successful test notification.