01-29-2020 12:13 PM
01-29-2020 12:13 PM
Thank you in adavance for your help!
My situation is this - I have created a stakeholder survey in Forms Pro. I want to be able to use this one form to collect responses from multiple stakeholder groups - and different vendors. I'd like to use the one survey - send multiple invitations (employing the variables) - and view an export of all responses. So far so good on this part. I've successfully created the survey and sent 3 different emails using the variables. The only problem is - when I view the results I have no idea which version of the survey they are replying to.
I have the following variables:
Is there a way for me to see all the response results from the examples above in one table WITH the associated variables?
01-29-2020 12:39 PM
01-29-2020 12:41 PM
@Megan_V_Walker - thank you for your response.
I am using Forms Pro. I do not have access to Dynamics 365. But if you tell me this is a must have in order to view results the way I want to - then I will do all I can to get access.
01-29-2020 12:48 PM - edited 01-29-2020 12:49 PM
@smolcykr - no not needed, just two different ways of then being able to see the variables.
Within Forms Pro, when you see the list of responses, you can double click to open one up. You then have a tab for the Responses, and a tab for the personalised data, which is the variables you have passed through when creating and sending out the survey invitation. That is the only place you will be able to access it from Forms Pro.
01-29-2020 01:08 PM
Thank you - I now see the second tab with the personalized - so that's good!
But I am super disappointed to learn that I am unable to export the responses and the personalizations.
With this not available to me - I'm struggling to see why I should use Pro instead just regular forms.
Thank you again
01-29-2020 01:11 PM
@smolcykr - I actually have a couple of other ideas for you. Do you use SharePoint, or do you just want to get an excel download of the data? Either way, you could use Power Automate to create a flow that triggers on a new survey response. In the flow, you can use a compose step to get the variables, then a parse JSON step to extract the values. A step can then be added to add everything to an excel file, or a SharePoint list.
In fact, I think I will write this as my next blog post: https://meganvwalker.com/microsoft-forms-pro/ - I see a need for it!
01-30-2020 05:48 AM
Thank you again - sounds like there is still hope.
I did try to creat a flow after watching one of your videos on YouTube.
However, I get stuck at the Get Details step - in your videos you have an expression that includes msfp_sourceresponseidentifier - when I try this I get an error
I look forward to your blog post on the subject!