来自sharepoint列表的计划员任务，包括开始日期 [英] Planner tasks from sharepoint list, including start date
问题描述
大家好，
$
我希望有人聪明，可以帮助我：
Hi all,
I am hoping someone clever is on here, and can help me out:
我为离职员工创建了一个流程，当批准完成后，它会查找包含以下列的sharepoint列表：
I have created a flow for offboarding staff members, which when the approval has completed, it looks up a sharepoint list with the following columns:
标题，说明，天，最后一天。
Title, Description, Days, Last day.
我让流程查找任务，并为每个人创建一个计划员任务清单。
$
标题很好，目前描述，我并不关心，最后一天在任务中填充到截止日期，我正在尝试确定填写每个截止日期的截止日期通过减去"天"来减去来自"最后一天"的列每行的列。
$
当我在截止日期字段中创建公式时，我正在做
I have the flow looking up the tasks, and a 'for each' creating a planner task for each line in the sharepoint list.
Title is fine, Description at the moment, I am not concerned about, Last day populates to Due Date in the task, and I am trying to get a due date to populate in each by subtracting the "days" column from the "last day" column for each row.
When I go to create the formula in the due date field, I am doing
adddays([Due Date],但是当我再次点击动态信息时，从"列表的获取项目"不允许我选择了天列（它缺少了，只有2个选项）。
but when I go to click back on the dynamic info, from the 'get items of a list' does not allow me to select the days column (it is missing, and there are only 2 options).
我正在用gui做这一切，因为我不擅长做代码方面的事情，有什么我想念的吗？
我试过把'days'列整数和a字符串，并且都不起作用。所有剩余的字段都可以从动态内容中选择，除了我去做公式之外，在我输入"adddays（"是$ b）后我可以做的所有事情$ b从列表中选择最后一天的列，然后我输入一个逗号，然后返回动态列表，它不显示。
任何想法如何为了得到这个将不胜感激，也许它可以在代码中完成，或者可能有一个解决方法。
$
提前致谢。
I am doing all this with the gui, as I am not real good at doing the code side of things, is there something I am missing?
I have tried making the 'days' column an integer and a string, and neither work. all of the rest of thie fields are able to be selected from the dynamic content, apart from when i go to do the formula, all i can do after I enter the "adddays(" is
select the last day column from the list, then i enter a comma, and back to the dynamic list, it does not show.
Any ideas how to get round this would be appreciated, maybe it can be done in the code, or maybe there is a work around.
Thanks in advance.
推荐答案
你好bgcarter，
Hi bgcarter,
addDays函数最多需要三个参数，其中2个是强制性的，如下所示：
The addDays function expects up to three parameters which 2 are mandatory as below:
*原始日期
*添加天数（如果是负数则减去）
* number of days to add (or subtract if a negative number)
*格式
所以，你应该有这样的东西：
So, you should have something like this:
addDays（[lastDays]，[days]）
addDays([lastDays], [days])
在我为了说明这个而构建的演示中，我有两个变量。一个名为lastDay，另一个名为days。您需要使用这两个变量的表达式是：
In the demo I built to illustrate this I have two variables. One named lastDay and another named days. The expression you need to use these two variables is:
addDays（变量（'lastDay'），变量（'天'）
addDays(variables('lastDay'),variables('days')
查看下面的图片看到完整的流程：
See the picture below to see the full flow:
___________________________
___________________________
如果这回答了你的问题，请相应标记。如果这篇文章有用，请点击向上箭头投票为有用
回复我的回复
这篇关于来自sharepoint列表的计划员任务，包括开始日期的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
