Skip to main content

Is it possible to make the event notification email to be dynamic, based on data in Sharepoint list ?

For example:

The data in Sharepoint list column EmailText is the following:
Upload {DocumentName} document, and due date is {DueDate}.

 

{DocumentName} and {DueDate} are from another Sharepoint list, and I also have them in the workflow's Data Fields (Data field DocumentName contains DocumentA, Data Field DueDate contains 10/1/17).

 

I would like the event notification email to replace {DocumentName} and {DueDate} with the value in the Data Fields, for ex:

Upload DocumentA document, and due date is 10/1/17.

 

 {DocumentName}  and {DueDate} are just 2 examples, it can be any Data Field.

 

Is that possible ?

 

Thank you.

Hi,


 


Here's what I can think of.


 


1. Generate a SmartObject for that SharePoint list you are talking about


 


2. In your email event or client notification, you should be able to use the context browser to drag your SmartObject's read method into the email body.


 


3. Use the inline functions to replace the text you want. In your email body, you will likely need to embed a Replace inline function with another Replace inline function, which in turns calls your SmartObject's read method to get the value from your SharePoint list.


Thank you


Reply