survey Response Separate

[Anonymous]

Hello,  I have a flow that reads the survey entries from Microsoft Dynamics customer Voice. whenever a survey is submitted, the flow would send an email that the form is received. However, I want to get the answers to the survey into the body of the email going out. what is happening is that it is sending me a separate email for each response and I need them all in one email. Any ideas on how I could achieve this? 

[Jronash]

This usually means that you have your Send Email action inside of a loop, when it should be outside of the loop.  Can you post a screenshot of your flow?

[Anonymous]

@Jronash 

That is the case but it isn't letting me do it any other way.. see screenshots below: 

[Anonymous]

@Jronash I've changed the Schema in order to look at each question ID/  response Id separately but it is now showing blanks and still creating so many emails for the same entry..

{

    "type": "array",

    "items": {

        "type": "object",

        "properties": {

            "questionId1": {

                "type": "string"

            },

            "response1": {

                "type": "string"

            },

            "questionId2": {

                "type": "string"

            },

            "response2": {

                "type": "string"

            },

            "questionId3": {

                "type": "string"

            },

            "response3": {

                "type": "string"

            },

            "questionId4": {

                "type": "string"

            },

            "response4": {

                "type": "string"

            },

            "questionId5": {

                "type": "string"

            },

            "response5": {

                "type": "string"

            },

            "questionId6": {

                "type": "string"

            },

            "response6": {

                "type": "string"

            },

            "questionId7": {

                "type": "string"

            },

            "response7": {

                "type": "string"

            }

        }

    }

}

[Jronash]

I'm afraid I don't know enough about how your data is structured to tell you exactly how to fix this.  But I can tell you that the problem is that one (or more) of the values that you are using in your email is part of an array. If the data you are referencing is part of an array, Automate automatically puts your action inside of a loop.

Are you able to post the output of your Compose block?  That would help, but you'd need to be careful to strip out any personal or confidential information.

[Anonymous]

@Jronash you are correct, it is part of an array and I think I need to put the results of the array into variables. Do you have an idea of how to do that? 

See below the output:

[{"questionId":"raee14f6dcbc94c6aa109e2219c18483e","response":"Name"},{"questionId":"rf21783a1a0944ed18f092b80c4c08c97","response":"Yes"},{"questionId":"r693baef494b74b87a42ca44c157f399c","response":"No"},{"questionId":"r998b4f1e69554c30b5120b31218134dd","response":"Yes"},{"questionId":"r5af8a57cf5f34b3486307662edc76575","response":"Yes"},{"questionId":"rf7638d43e63642a7b8ce3d5a33254ee8","response":"Yes"},{"questionId":"rd2a2f7be84b04d16bf66e89cfebf97a1","response":"i accept the machine "}]

[Jronash · Accepted solution]

If you want all of those questionIDs and responses to display in your email, the easiest method is to use a Select action, and then a Create HTML Table action.

The first thing to change is to roll back the changes that you made to your Parse JSON schema.  The schema you posted will not work with the sample data that you posted, which is why you are getting blanks.  Set the schema back to what it was, or use your sample data to re-generate it

Next, add a select action and set the source to your Parse JSON action.  Add keys for questionId and response, and set the values to the dynamic data coming from your Parse JSON action.

Then create a Create HTML Table action and set the From field to the output from your Select action.

Finally, in your email, you can insert the table by using the output from the Create HTML Table action, which you can find in your dynamic content.  Be sure that you set your email to Code View before you do this, as the output from Create HTML Table will be in HTML code.

Here's how it would look:

[Jronash]

And this is what the email notification body would look like:

[amitprajapati]

Hello, I can see you are getting the GUID of the question in your email, you can get those question label from the Customer Voice Survey Question and there is field called "msfp_questiontext"

You can use below image to understand the entity structure of the Customer Voice in Dynamics 365:

[Anonymous]

@Jronash thanks a lot. this worked. is there a way to have the question IDs changed as well?

[Jronash]

Sure, you can change them in your Select box.  What do you want to change them to?

[Anonymous]

I would want the actual survey questions o come up like:

UserName: Dana Shuqair

Do you have access to the internet? YES

I am only getting the question IDs and If I add the text of the questions, it would duplicate it for each answer and I'd have over 100 different questions.

[Jronash]

How are you currently retrieving the actual survey questions? 

If you have the actual survey questions in your flow, it should be possible to link them with the responses.  However, this is more complex than what we've been doing up to this point.  It would help to see a screenshot of how you are getting the question data, and the output of the question data itself so I can see how it is organized.

[Anonymous]

Hi @Jronash .. thank you. below are the screenshot. I was able to get the questions easily when I was using MS Forms pro when i can't seem to get it to work on Customer Voice 😞

[Jronash]

Hi @Anonymous,

So it looks like you have customer variables and question answers connected to your flow, but not the questions themselves, is that right?

I haven't used customer voice before, so I'd refer to the post from @amitprajapati above.  From the diagram they posted, it looks like the question text should be in the msfp_question table.  Are you able to retrieve data from that table?

[Anonymous]

@Jronash that is correct, the questions are on that table as well but there isn' a way for me to retrieve them 😞

[Jronash]

@Anonymoustake a look at this thread.  https://powerusers.microsoft.com/t5/Building-Flows/Forms-Pro-connector-to-get-survey-questions/td-p/630778

Would something like that work for you for retrieving the questions?