I am having a lot of trouble trying to figure out how to get my survey data from Survey monkey into an Excel sheet. I have the flow basically working, but only for the "Dynamic Content" that is listed when choosing what to match up (ID, Date Created, URL, IP Address, Time Spent, etc). I am not able at all to get my actual survey answers into the sheet. What am I doing wrong, or is this not possible? I cannot find any documentation on Using Survey Monkey and Flow, just that it is available to use.
This is a big project. Please help!
I'm investigating on this issue and will get back once I got any update.
It is true that the only available dynamic content you could get from the SurveyMonkey trigger are below ones:
It seem that you cannot get the response content of each question.
You could post this idea in the Flow Ideas forum, so it might be considered for future releases.
Thanks for the information.
My ultimate goal is to be able to get this data directly from survey monkey into a format that can be accessed by Power BI without me having to manually download and upload the data. An API can be created and used within Power BI to pull the data, although I do not know if this has the same limits on what it pulls or not, and creating is above my technical skills.
Any other ideas?
I am actually looking into Zapier; this tool allows you to do that, https://zapier.com/apps/surveymonkey
Hope this is useful for you, and if you made up with a different solution, let us know,
Read the announcement for more information!
Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.
We've updated and improved the layout and uploading format of the Power Automate Cookbook!
Fill out a quick form to claim your user group badge now!
The top training and networking event across the globe for Microsoft Business Applications