I am trying to create a flow that will receive a webhook trigger from Wufoo forms and then create a sharepoint list entry from the form data. In wufoo I have enabled a webhook. In Flow I have added a Http Request trigger and have copied the url into the webhook section of Wufoo.
The data that is sent to Flow is of a content type x-www-url-formencoded and is given in a "body" object. I am lost on how to extract the data in the body into individual fields. Any ideas or suggestions?
Could you please share a screenshot of your flow's configuration?
Do you want to extract the data from the "body" into a SharePoint list item?
If you want to extract the data from the "body" object, please and see if the following article would help in your scenario:
I have made a test on my side and my flow's configuration as below:
Note: Type the above WDL expression within Expression tab.
More details about the Workflow Definition Language (WDL) in Microsoft Flow, please check the following article:
Thanks so much for your reply!
Here is a little bit of the background -
Goal: When a new Wufoo survey entry is submitted, create a Sharepoint List entry.
So far: I tried two routes.
Here is the setup I have been using to test the flow until I figure out how to separate the fields.
I found that if I put the whole body result from HTTP Request in the email it includes the whole package along with Key, Value pairs. This made me think that if I could extract it as some sort of array then I could identify the fields. I then found that I could use triggerFormDataValue('Name of Key here') to grab the value associate with the that particular key. There are about 20 key/value pairs so I was hoping to have some sort of function that could automatically grab the entire set of key/value pairs without needing to specify each individual one as I was also hoping to use this flow for other surveys which would use different key/value pairs.
Another option I was thinking is I could extract the ID of the survey entry using the FormDataValue piece from above and then use the custom connector to grab the entry for that survey. It seems like this would be a waste though since the data is already there, I just am struggling to format it correctly.
Yes. I did... sort of.
I ended up pulling the survey form id from the form encoded data and then submitted a new HTTP request to Wufoo to retrieve all the data I needed.
The issue was that the webhooks being sent from Wufoo are form encoded whereas the Wufoo API itself actually provides multiple methods of grabbing data.
Are you using Wufoo as well?
I'm happy to paste what I ended up doing. I'm just not at a spot currently where I can do so but am happy to either later today or tomorrow.
Thanks Nick. In my case, the webhooks are being received from MailChimp, which also sends the data as x-www-url-formencoded rather than in JSON. Your "triggerFormDataValue" idea is working for me though, and in my case it might be enough as I don't have so many individual items of data to parse out as you did. I just wondered if there was a way of decoding the whole shebang in one go!
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!