问题描述
我正在努力解决如何使用SharePoint Designer中创建的工作流基于列表发送电子邮件的解决方案.
I am struggling with the solution on how the send out emails based on the list using workflows created in SharePoint Designer.
我们正在公司内部使用SharePoint 365，我正在使用SharePoint Designer 2013.
We are using SharePoint 365 within the company, I am using SharePoint Designer 2013.
我已创建以下列表:
该列表包含大约300个项目，这些基本上是项目的状态，该列表将作为以上内容的概述.该列表每周更新一次(对于绿色项目)，对于项目中存在问题或截止日期的项目， 如果无法满足要求，则该项目可能会每天更新.项目名称在列表中重复出现，因为通常有几个人在同一个项目上工作，他们都报告了自己的状态.
The list contains around 300 items, these are basically the statuses of projects and this list is to serve as an overview to those above. The list is to be updated weekly (for green items), for items with issues on the project or the deadlines are not being met, the project may be updated daily. The project names are repeated within the list, as there are usually several people working on the same project, all of them reporting their status.
列:人员，角色，客户/项目，地区，上周完成的工作，下周的计划工作，注释/问题，状态，满意度调查问卷状态，风险和默认列:已修改，修改者.
我需要的是能够发送以下提醒:
欧洲中部时间每个星期二下午4点，向人们发送提醒(基于专栏)人)在过去五天内未编辑列表(他/她)的项目(问题是同一个人可能被分配到多个项目，因此他/她可以编辑以下内容的列表)当前一周中他或她的一项或多项，但不适用于 其他三个项目，因为该项目没有任何反应，那么系统就不应该发送提醒).
Every Tuesday at 4 pm CET, send out the reminder to people (based on the columnPerson) who have not edited the list(his/her) items in the past five days (the problem is that the same person may be assigned to several projects, so he/she may edit the list for one or two of his/her items the current week, but not for the other three as there is nothing happening on the project, then the system then should not send the reminder).
我试图创建当前日期"列，然后每天使用信息保留策略"对其进行更新，但是现在某种程度上它对我来说正常运行，我可能做错了事.
非常感谢您的帮助.
S.
推荐答案
如果我对您的理解正确，那么您需要通知列表中存在且在过去5天内没有更改任何项目的用户，对吗?如果是这样，您可以尝试以下算法:
If I understand you correctly you need to notify users that are present in the list and didn't change any item during last 5 days, right? If so you may try following algorithm:
1.遍历列表项(请参阅https://wonderlaura.com/2014/08/01/workflow-loop-through-multiple-sharepoint-items/或https://weblogs.asp.net/ricardoperes/looping-通过列表项在sharepoint-2013)
1. Loop through the list items (see https://wonderlaura.com/2014/08/01/workflow-loop-through-multiple-sharepoint-items/ or https://weblogs.asp.net/ricardoperes/looping-through-list-items-in-sharepoint-2013)
-对于每个项目，请检查人员"是否与修改人"相同，并且修改日期"大于5天.如果否，则将其放入字典(如果该字典中不存在该字典)(请参阅https://dev.office.com/sharepoint/docs/general-development/understanding-dictionary-actions-in-sharepoint-designer). 如果是，请从字典中找到该人并将其删除.
- For each item check if the Person is the same as Modified By and the Modified date greater that 5 days ago. If no, put the Person into Dictionary if it does not exist there (see https://dev.office.com/sharepoint/docs/general-development/understanding-dictionary-actions-in-sharepoint-designer). If yes, find and remove the Person from the dictionary.
2.循环浏览字典.向词典中的每个人发送通知.
2. Loop through the dictionary. For each person in the dictionary send notification.
希望有帮助
这篇关于通过SharePoint Designer工作流基于列表的每周提醒电子邮件的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！