通过电子邮件发送SharePoint列表项更改以包括更改 [英] Email on SharePoint List Item Change to include changes

问题描述

美好的一天！

我有一个工作流程，该工作流程从创建列表项开始，并在列表项发生更改时发送电子邮件...我想在电子邮件中包含所做的更改...即请求的金额，未批准到批准，状态等...

I have a workflow that starts when a list item is created and sends an email when a list item changes... I would like to include in an email the changes that were made... i.e. amount requested, not approved to approved, status, etc....

可以在没有任何后端编程的情况下完成此操作吗?在编码方面，我有点不确定.

Can this be done without any back end programming? I am a little unsure of myself when it comes to coding.

预先感谢您的帮助！

M

推荐答案

我会考虑两种方法:

I would consider two approaches:

如果字段数量有限，则可以添加成对的"字段.您列出的列.例如状态/先前状态，金额/先前金额.在您的工作流程中，电子邮件中应包含当前状态="状态以前的状态"； =上一个 地位.然后更新以前的状态以等于当前状态.金额等内容相同.(通过在内容类型中排除列来隐藏列.)

If there are a limited number of fields, you could add "paired" columns to you list. For example Status/Previous Status, Amount/Previous Amount. In you workflow email include "Current Status =" Status "Previous Status" = Previous Status. Then update the Previous Status to equal the current status. Same for amount etc. (Hide the columns by excluding them in your content type.)

如果您不想使您的列表混乱，则可以创建以前的版本"列表.要做的工作还多一些，但是如果需求发生变化，您将可以访问所有字段. (可悲的是，我不认为有一种OOB方式可以访问以前的版本 在SPD工作流程中).要创建以前的版本列表，请将原始版本另存为模板，然后使用它来创建新的自定义列表.在新列表中，再增加一列以引用原始列表.类似于OriginalID.然后在您的工作流程中:

If you don't want to clutter your list you can create a "Previous Version" list. It is a little more work but you will have access to all the fields if requirements change. (Sadly I don't think that there is an OOB way to access previous versions in a SPD workflow). To create the previous version list save the original as a template then use it to create a new custom list. In the new list add one more column to reference the original list. Something like OriginalID. Then in you workflow:

检查是否存在以前的版本

Check to see if a previous version exists

如果是这样:检索电子邮件的先前值，删除先前的记录，将当前记录复制到您的先前版本"，列表中，使用复制的列表项中的记录ID更新您创建的记录.

If it does: retrieve previous values for your email, delete the previous record, copy the current record to your "previous version" list, update the record you created with the record ID from the list item you copied.

如果没有退出:决定是否要发送有关新项目的电子邮件，请将当前记录复制到您的以前的版本"中.列表中，使用复制的列表项中的记录ID更新您创建的记录.

If it doesn't exit: decide if you want an email for new items, copy the current record to your "previous version" list, update the record you created with the record ID from the list item you copied.

设置更改项目时自动启动工作流程".

有关更多详细信息，请参考以下有关SharePoint中特定字段发生更改时如何发送电子邮件的文章，以供您参考:

http://officepowerups.com/2013/07/09/send-email-when-specific-field-changes-in-sharepoint/

For more detailed information, refer to the following article about how to send email if a specific field changes in SharePoint for your reference:

http:// officepowerups.com/2013/07/09/send-email-when-specific-field-changes-in-sharepoint/

这篇关于通过电子邮件发送SharePoint列表项更改以包括更改的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！