cancel
Showing results for 
Search instead for 
Did you mean: 
arobins
Nintex Newbie

Query List and Format a Notification

Hello,

I'm looking for help on how to format a notification email. I have a parent list and child list, the child list could have any number of rows of information associated to the parent list. I have a workflow that query's the list but I'm having a problem getting the results to make sense on a notification email.

When the work flow is run the child list information (in this case there were two lines entered) the notification shows the information is this format:

Monitor Gate;Access control front door;; Type A Regular;Supervisor Regular;; 123 Street;778 Road; 

I need the notification email to show the information as it would in the list, like below. Basically the information in the list rows needs to stay together in order to make sense.

Monitor Gate; Type A Regular; 123 Street

Access control front door; Supervisor Regular; 778 Road

Any help is appreciated. The workflow is attached.

Thanks

Andrew

Labels: (2)
0 Kudos
Reply
2 Replies
lakshminarayana
Nintex Newbie

Re: Query List and Format a Notification

The 'Collection' variable will always returns all the 'Field' values at once. Instead 'Collection' variable use 'Single line of text' variables (for each field) inside email body using 'For each' action. This will read values one by one from the collection and send separate emails to user.

Your logic should be.

1.Query Child List.

2.For each item in collection

3.Query list and get all field values and store them in workflow variables.

3.Include all field values in email body.

0 Kudos
Reply
Automation Master
Automation Master

Re: Query List and Format a Notification

you might want to follow following threads

Send grouped notification based on list items 

 

Reply