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

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

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

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.

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

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

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

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

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

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

You’ll see the key is not descriptive

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

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

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

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)

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

Go to Power Automate

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

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

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

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

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

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

Populate the field values from the box on the right

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

Step 3 – Copy the URL of the http request

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

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

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

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

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

Summary:

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