Updating Multiple Survey Feedback Using SP Designer Workflow - Part Two

In this article, you will learn how to update multiple survey feedbacks using SP Designer Workflow.

Multiple list items

 
Problem Statement - Create a SharePoint survey for training feedback and collect all the feedback of particular training with date and save them as one item to another SharePoint list (loop through training), and send an email notification to the trainer with an average rating and individual rating with suggestion
 
Survey (Training feedback) will get a response as below.
 
Suppose we will get 5 pieces of feedback for the training ECU Integrator Workshop,  and the trainer is Pramod,  and the training date is 8/11/2019 with 5 different ratings and suggestions.
 
The workflow will collect all the feedback of particular training name based on the unique value and store it on another list in HTML table format and trigger email to the trainer with all feedback including the aggregate rating.
 
This information will create in the loop through training as follows,
 
Updating Multiple Survey Feedback Using SP Designer Workflow
 
And the feedback will be sent to the trainer on triggered email date after 30 days from training, i.e., 9/10/2019.
 
Updating Multiple Survey Feedback Using SP Designer Workflow
To send the email, as shown in the above screenshot, we used Nintex workflow.
 
Updating Multiple Survey Feedback Using SP Designer Workflow
 
Step 1
 
Set Variableintrating with data type number to zero as shown below.
 
Updating Multiple Survey Feedback Using SP Designer Workflow
 
Step 2
 
PAUSE until use, so the workflow will pause until the Trigger Email On column and will collect all the feedback in EmailBody column in the meantime.
 
Updating Multiple Survey Feedback Using SP Designer Workflow
 
Step 3
 
Math Operation: As soon as current date matches with Trigger Email On column, the next stage will run; i.e., Math Operation
 
Here the sum of all rating values is divided by the total feedback given number, and the result will store in variable rating which was created in the first step.
 
Updating Multiple Survey Feedback Using SP Designer Workflow
 
Step 4
 
Send Email Notification: In this stage we will send an email to Trainer with content in Email Body Column,
 
Updating Multiple Survey Feedback Using SP Designer Workflow
 
Step 5 6 and 7 – Set Field Value
5 – Column Feedback Count to 0
6- Column Rating to 0
7 – Column Email Body to Empty
 
Step 8 - Stop the workflow
 
Output
 
Updating Multiple Survey Feedback Using SP Designer Workflow