问题描述
大家好，
我在这个问题上一直处于困境...我是SharePoint Designer的新手，所以请多多包涵.我正在尝试捕获批准工作流的人员和(后来)批准他们的人员，并使用SharePoint Designer在我的文档库中绘制信息...
I'm stuck on this issue...I'm new to SharePoint Designer so please bear with me. I'm trying to capture the person who approved the workflow and (later) when they approved it and plot the information in my document library using SharePoint Designer...
这是我的文档库中批准者的名称(以绿色显示)的位置:
Here is where the Approver's name should go (in green) in my document library:
我注意到文档具有唯一的 ID (在测试5 中， ID = 29 ).我想:
I noticed that the document has a unique ID (in Test 5 theID = 29). I would like to:
1)将当前商品 ID ( 29 )与具有以下内容的商品匹配:我的工作流程历史记录列表中的主要项目ID ( 29 )
1) Match the current item ID (29) to items that have aPrimary Item ID of 29 in my workflow history list,
2)由于我的工作流程历史记录列表中有很多行，其中主要项目ID" = 29，因此我希望对其进行进一步过滤，以仅捕获其中 E 排放类型 = 6 (此事件捕获谁批准了工作流程)，
2) As there are many lines in my workflow history list where Primary Item ID = 29, I'd like to further filter it to only capture rows whereEvent Type = 6 (this event captures who approved the workflow),
3)然后我要拉出"用户ID " (即Anna Tran)并将其绘制在批准者"我的文档库中的列. ***必须从具有最新"发生日期"的行中提取用户ID. 日期.
3) Then I want to pull the "User ID" (i.e., Anna Tran) and plot it in the "Approver" column in my Document Library. ***It HAS to pull the User ID from the row with the latest "Date Occurred" date.
下面的我的工作流程历史记录...红色框显示了一个与我想要的实例匹配的实例，但带有一个较早的发生日期".所以我不想捕获此信息.绿色框显示最新的发生日期".而且是我要拉的地方 来自...的信息
My workflow history below...the red box shows an instance which matches what I want but with an earlier "Date Occurred" and so I don't want to capture this info. The green box shows the latest "Date Occurred" and is where I want to pull the info from...
这可能吗?请让我知道！
Is this possible? Please let me know!
推荐答案
对于使用工作流任务批准人更新列表中批准人"列的请求，建议您在SharePoint Designer中创建批准工作流任务并按以下方式获取批准人:
For the request that update the "Approver" column in the list with the approver of workflow task, I suggest you create an approval workflow task in SharePoint Designer and get the approver as below:
首先，添加开始批准过程"操作，然后单击批准".
First, add "start approval process" action, then click "Approval".
在自定义"部分下单击更改单个任务的行为".然后添加设置工作流程变量"操作，如下所示:
Click "change the behavior of a single task" under Customization section. Then add "set workflow variable" action as below:
最后，使用以下变量更新批准人"列:ThisTaskApprover
Finally, update the "approver" column with this Variable: ThisTaskApprover
最诚挚的问候，
王race(Grace Wang)
Grace Wang
这篇关于如何从工作流历史记录列表中的字段过滤信息并将其从文档中拉出到文档库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！