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.
Important Note
If you do not have this integration enabled for your site, please contact your Account Manager.
Create a SharePoint List
Click Settings and select Site contents
Click + New and select List from the dropdown menu
Select Blank List
Type a Name for the list, and optionally, type a Description (if available)
Click Create
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
Navigate to the Power Automate website and sign in
Navigate to the Connectors tab in the left-hand menu
Search for the SharePoint connector
Click the when an item is created option
Add the Site Address, and the List Name will pre-populate. Once the List name is selected, the list columns will become available
Click + New Step
Choose an operation
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.
Click Save
Click Test (beaker icon)
Choose a Test Flow option
On the bottom right-hand panel, click Test
If the flow is successful, a green notification will pop up
