Scenario Overview

This scenario is an enhancement of the Survey Response 1 article on sending Sales Literature. Again we are integrating with the Voice of the Customer solution.

The business requirement is that we send out product information to a customer who has filled in a survey. 
For this example a customer can choose any and all of the following:

  • Bluetooth Pen
  • Keyboard
  • Surface Pro 3
  • Surface Pro 4

When the Survey Response is received from the customer we will automatically process the response and send an email out to the customer containing pdf documents for all the selected products.

Voice of the Customer Survey 

North52 Decision Suite Solution

The North52 Decision Suite solution works like this:

  • A formula of type 'Process Genie' set up on the Survey Response entity  
  • A workflow is set up on the Survey Response entity, to be triggered on the creation of the survey response.
  • This workflow will invoke the N52 formula via a Process Genie step.
  • The Formula creates the email to be sent out to the customer.
  • Then it will query each of the Answer entities where they match the Question name.
  • For each answer it finds, it retrieves the correct Sales Literature based on the name
  • Then it will attach all Sales Literature Items to the newly created email.
  • Finally it will send the email out to the customer

N52 Formula

Workflow Setup

Template Email

Customer Email

North52 Decision Suite Steps

The following set of steps outline how to create this Formula:

  • Create the formula of type Process Genie on the Survey Response entity 
  • Copy in the formula below
  • Create a FetchXML query called FindSalesLitItemsName on this formula and copy in the Fetch XML code from below
  • Create a FetchXML query called GetSurveyResponseAnswers on this formula and copy in the Fetch XML code from below
  • Create a workflow on the Survey Response entity as shown above
  • Insert the formula short code into the Process Genie step
  • Click save and test


      SetVar('QuestionName', 'Select any products you would like to learn more about'),
       SetVar('TemplateID', FindTemplateId('Survey Response Multiple Product Info', '1033')),

      SetVar('EmailID', CreateEmailFromTemplate(GetVar('TemplateID'),
                  SetAttributePartyList('from', 'systemuser', [msdyn_surveyresponse.owninguser]), 
            SetAttributePartyList('to', 'contact', [msdyn_surveyresponse.msdyn_contact]),
                  SetAttribute('subject', 'North 52 Product Information'), 
            SetAttribute('description', StringFormat([email.description],




Fetch XML FindSalesLitItemsName

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" >
  <entity name="salesliteratureitem" >
    <attribute name="filename" />
    <attribute name="filetypecode" />
    <attribute name="mimetype" />
    <attribute name="documentbody" />
    <attribute name="modifiedon" />
    <attribute name="title" />
    <attribute name="salesliteratureitemid" />
    <order attribute="title" descending="false" />
    <filter type="and" >
      <condition attribute="salesliteratureid" operator="eq"
       uiname="Surface" uitype="salesliterature" value="{0}" />

Fetch XML GetSurveyResponseAnswers

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" >
  <entity name="msdyn_answer" >
    <attribute name="msdyn_name" />
    <attribute name="msdyn_answerindex" />
    <attribute name="msdyn_questionid" />
    <link-entity name="msdyn_questionresponse" from="msdyn_answerid"
       to="msdyn_answerid" link-type="inner" >
        <condition attribute="msdyn_surveyresponseid" operator="eq" value="{0}" />
      <link-entity name="msdyn_question" from="msdyn_questionid" to="msdyn_questionid" >
          <condition attribute="msdyn_name" operator="eq" value="{1}" />

Note 1 : Template Emails

You can pass additional information into the template by using the {0}, {1} parameters into template.

In this example, the subject line the Template is {0}. 
When this line of code executes into the Formula:
SetAttribute('subject', 'North 52 Product Information'),   

The {0} in the subject line will be replaced with the 'Bluetooth Pen - Product Information'

[email.subject] and [email.description]
If you want to replace multiple {0}, {1}, {2} values within the body or a subject bar of an email then you should use the StringFormat([email.description], 'value to be used') command.

Example: Hello {0}, How are you?

SetAttribute('description', StringFormat([email.description], 'John') = "Hello John, How are you?"
SetAttribute('description', 'John') = "John"

Without the StringFormat([email.description], 'John') N52 will simply set the email description to John. Using the StringFormat([email.description], 'John') command tells N52 that you want to merge ‘John’ into the existing data in the email body at the first parameter position {0}. 

Wizard - FindTemplateId

Please see below the wizard you can use to create the FindTemplateId() function call used in this formula. 

Note you will need to either type or paste in the following. 

Did you know?

Over 300 customers use North52!

Join over 300 organizations worldwide who trust North52 to drive their digital transformation into the future:

Serious Power without Code:  Easily build business rules, tests and data packages using our point-and-click editors. Even the most complex business rules are easily configured.

Build Fast:  We’ve built the North52 tools with our user’s productivity in mind – up to 10x faster than writing custom code.

Awesome Support:  We take pride in providing world class support to our customers and partners, ensuring you are successful with North52.

Future Proof:  We ensure your business rules and tests that you configure today, will continue to work with the ever changing Dynamics 365 platform.

Learn more about the North52 Decision Suite