How Can You Use Gravity Forms Along With Microsoft Power Automate To Support Your Business? What Are Some Powerful Ways To Leverage These Tools?

It used to be a challenge getting anonymous data from the web into SharePoint. Webhooks make this integration much easier.

What’s a webhook? SendGrid defines it as:

A webhook (also called a web callback or HTTP push API) is a way for an app to provide other applications with real-time information. A webhook delivers data to other applications as it happens, meaning you get data immediately

Connecting Gravity Forms with SharePoint Online

Wouldn’t it be great to connect Gravity Forms and SharePoint so you can act on forms submissions from your WordPress site? This blog post will cover the steps to make this happen and you can look at the video of this process, too.

Get a Gravity Forms / WordPress Trial

Go to https://www.gravityforms.com/demo/

Be sure to activate the webhooks add in the WordPress site.

We’ll use the multi page form sample – as you can see there are many other forms you can try.

Create a few entries – note – we aren’t using email confirmations.

Export the entries to a csv file

Open the csv and save it as an Excel file – one thing I missed in the video was inserting a table in the spreadsheet of the exported entries. This would make importing the spreadsheet a little bit easier.

Import the Excel file into SharePoint. Make sure you use IE 11!

You can watch the video or review this article from Microsoft – https://support.office.com/en-us/article/create-a-list-based-on-a-spreadsheet

Configure the Webhook TimeStamp 4:14 in video

1 – Go to https://webhook.site/ and copy the unique URL and paste it into the request URL below and select update settings

Create a form submission and go back to https://webhook.site/ to view the response.

You’ll see the key is not descriptive

Go back to the webhook page – this time next to “Request Body” change the option to “Select Fields” and provide a descriptive key.

Create another form entry and submit

You’ll see the data is much easier to understand – make sure you select the most recent submission (1)

Copy the entire JSON response to the clipboard (2)

Go to Power Automate

Create a new flow, automated, from blank. Then search http in the trigger. Video Timestamp 7:03

Paste the JSON response from earlier into the sample payload area.

Add a new step in your Flow  – Create a SharePoint list item

Populate the field values from the box on the right

Step 3 – Copy the URL of the http request

Step 4 – Go to https://urldecode.org/ and paste the URL you copied in step 3, then select decode

Step 5. Update the webhook URL in Gravity Forms with the decoded value from the previous step

Create another form entry

Verify flow created the new list item

Summary:

You can do many things with webhooks – this is an example to get you started