从一个列表复制到另一个列表,但如果记录已存在则更新?
我们的客户在 Sharepoint 2010 上的一个站点内设置了 5 个列表副本,每个区域分支机构各一份。现在,一旦记录被标记为“,他们希望拥有一个包含所有记录的合并列表。正在评估”(简单的单选按钮字段)。
我继续在共享点设计器中创建了一个工作流程,当编辑记录并匹配状态条件时,该工作流程将记录从每个列表复制到合并列表。
现在的问题是任何进一步的编辑(只要状态保持不变)都将创建记录的另一个副本。假设用户添加了一个附件,我们最终会得到一条记录的多个副本。
所以,我的问题是:有没有办法根据 ID 或某个唯一值来更新工作流程中的现有记录(在另一个列表上)?
Our client has a setup with 5 copies of a list, one for each regional branch, inside a single site on Sharepoint 2010. Now, they'd like to have a single list with all the records consolidated, once the record is marked as "under evaluation" (simple radio button field).
I went ahead and created a workflow in sharepoint designer, that copies the record from each list to the consolidated one, when the record is edited and matches the status criteria.
Now the problem is that any further edits (as long as the status remains untouched), will create another copy of the record. Say, the user goes and adds an attachment, we end up with multiple copies of a single record.
So, my question: is there any way to update existing records (on another List) in a workflow, based on an ID or some unique value?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
我建议根本不使用列表,而是配置内容查询 Web 部件以在运行时根据过滤器从列表中提取数据。
i would suggest not using a list at all, but configure a Content Query web part to pull data from the lists at runtime, according to filter.