将标签的导出标签分配给了Office 365中的计划者的任务
尽管有多种在线解决方案可以将计划导出到Excel,但某些出口选项仍在未知领域。对于例如,我已经将几个现有标签编辑为定制名称,而不是计划下的每个任务。有什么办法可以将分配的标签导出任务?
我试图找到Power Automate中的选项,但徒劳无功。让我知道你的想法。谢谢 !
在这里您可以看到任务XYZ具有多个标签,例如DEV,测试和样本。如果我想将它们与任务的其他细节一起将其导出到Excel表中,那么最好的方法是什么?
While there are multiple solutions available online to export plan to an excel, some of the export options are still in uncharted area. For e.g. i have edited few of the existing Labels to a customized name and not every label is assigned to every task under a plan. Is there any way i can export the assigned labels taskwise ?
I tried to find options in power automate but in vain. Let me know your thoughts . Thanks !
Here you can see task xyz has multiple Labels like Dev, Testing and Sample. If i would like to export them too into an excel sheet along with other details of the task, what would be the best way ?
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(2)
标签的名称在计划详细信息实体中, categoryDescriptions 属性。您可以每个计划读取一次以获取所有名称,然后在每个任务上应用的categories字段指示哪些标签应用于特定任务。您可以使用“应用” categories字段中的属性名称直接从计划中的名称中查找值。
您也可以导出一个直接从计划者中脱颖而出的计划,如果您不需要自动解决方案,则无需编写代码(也包括标签)。
Names of the labels are in the Plan Details entity, CategoryDescriptions property. You can read this once per plan to get all the names, then appliedCategories field on each task will indicate which labels are applied to the specific task. You can use the name of the property in the appliedCategories field to directly look up the value in the name from the plan.
You could also export a plan to excel from Planner directly, without writing code (which includes labels as well), in case you don't need an automated solution.
这些标签确实存在于每个计划的任务中,但是您将讨厌这个标签,它们通过
AppliedCategories
对象进行,并且由类别本身的顺序表示。您可以将它们重命名为您喜欢的所有内容,但是这些名称在响应中没有被删除。
您需要管理自己的映射表中的名称或类似的内容来获得所需的东西。
要查看它的工作原理,请在随机位置中选择标签,然后运行
列出我的任务
操作,您将在那里看到它们。The tags do exist in each planned task but you're going to hate this, they come through in the
appliedCategories
object and they're represented by the order of the category itself.You can rename them all you like but those names aren't pulled through in the response.
You'll need to manage the names in your own mapping table or the like to get what you want.
To see it working, select labels in random positions and then run the
List my tasks
action and you'll see them there.