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,
And the feedback will be sent to the trainer on triggered email date after 30 days from training, i.e., 9/10/2019.
To send the email, as shown in the above screenshot, we used Nintex workflow.
Step 1
Set Variableintrating with data type number to zero as shown below.
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.
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.
Step 4
Send Email Notification: In this stage we will send an email to Trainer with content in Email Body Column,
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