Forum Discussion
Forms Pro - How can I see the variables selected for a specific invitation?
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 https://docs.microsoft.com/en-us/forms-pro/developer/reference/entities/msfp_surveyresponse#BKMK_msfp_sourceresponseidentifier - when I try this I get an error
I look forward to your blog post on the subject!
I am also having the same problem. We don't have Dynamics. I am trying to build a Customer Satisfaction Survey that we will send with our Order Confirmations. If they click on the Survey Link, then they will see a personalized survey (using Survey Variables). That part works great. But I am stuck in the same spot as smolcykr. When I send the survey, I get nothing...Here's a screen shot.
Still can't get past retrieving the msfp_sourceresponseidentifier. This variable is not being past to my Get response details step. Everything works to that point. I see that variable in the Body returned from the "When a record is created" but not after that step.
Any help you guys can give would be greatly appreciated. You've been great with all the help so far!
Ok...I found where to go back to my Flow. I get the following error...
And here is the setup....
I thought I had this figured out but this is where I'm stuck now.
I truly appreciate all the help you 2 have provided!!!
smolcykr Thanks for the reply!
I'm testing this now and I'm getting an error. In the condition step, I assume the "Survey Name" is the Survey Name I am executing. Then in the Get Response Details I choose the Survey with the same name. Then I put in the expression you stated and I get the error.
Another question...How does this Flow get saved with the Survey? It seems that every time I go back to the Survey and make a tweak, I have to rebuild the flow. I have saved it and named it but doesn't seem to "stick". Megan_V_Walker
Jake_Brown - it looks like you need to tell it to Get the Record after the When a Record is created step.
Basically, you have to tell the flow what to do after a new record is created - in this case - Get the Record
Then tell the flow which survey to get by using the condition
THe fx in the Response ID field of the Get Response Details step is
@{int(triggerBody()?['msfp_sourceresponseidentifier'])}
I hope that helpsOk...getting closer.
I had to first choose PowerApps in order get access to the CDS. I know this still isn't correct since it err'd. But here is the flow at this point
It took a long time to go through the "When a record is created" step. But it was successful until I got down to the "Get Response details" where it returned a 400 error code.
We have M365 E3.
It doesn't allow me to select that connector. It's very frustrating as you can imagine.
smolcykr Jake_Brown - it is indeed the 'When a record is created', and that step has simply been renamed.
Jake_Brown - what plan do you have for Power Automate? Unless you are using a free license that comes with Office 365, if you are paying for a license, you likely have access. https://docs.microsoft.com/en-us/power-platform/admin/powerapps-flow-licensing-faq
Did you try and use that connector and it didn't work?
Thanks for the reply smolcykr
The problem I have is I don't have access to CDS. It shows as a "PREMIUM" item and I guess our subscription doesn't have that. I'm hoping there is an alternative.
Jake_Brown - my flow starts with "When a record is updated", the next step I have is "Get Record"
The next step I have is the condition - tell it what survey - then what to do with it
I hope that helpsMegan_V_Walker ... Thanks for the reply.
I actually read that post several times 🙂 but I still am not understanding this correctly. I don't really need an invitation flow. Whenever a customer places an order, our system sends out an Order Confirmation email. We are going to include the link to the Survey in the same email. It will basically have a Smiley Face, Unhappy Face and a "Meh" Face. If they click either the Smiley or Unhappy face, it will launch the survey (it's actually 2 different surveys so we can more easily distinguish between happy and unhappy customers). Having said that, where I thought I needed to pick up in your post was on the "New Survey Response Received" but that does NOT appear to be an option. Everything under the CDS has "PREMIUM" listed.
This is the reason I seem to be stuck. Any help you can give would be greatly appreciated!
The first step should be the Common Data Service connector, not the Microsoft Forms connector.
Try reading through this entire post and see if this helps:
https://meganvwalker.com/extracting-survey-variables-from-forms-pro-responses-without-access-to-cds/
