Forum Discussion
Forms Pro - How can I see the variables selected for a specific invitation?
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.
- Megan_V_WalkerJan 29, 2020Iron Contributor
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.
- smolcykrJan 29, 2020Copper Contributor
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
- Megan_V_WalkerJan 29, 2020Iron Contributor
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!