Power Automate+ SharePoint列表 - 撰写/获取项目操作错误

发布于 2025-01-31 06:02:19 字数 1761 浏览 3 评论 0原文

我目前正在努力争取几乎相同的流程: https://powerusers.microsoft.com/t5/building-flows/find-lowest-number-number-in-list-number-in-list-in-list-column-and-and-us---- -to-sort-intems/td-p/777718

我的流量在最后一个获取item 操作中失败,并带有以下错误:

Error
Action 'Get_item' failed

Unable to process template language expressions in action 'Get_item' inputs at line '0' and column '0': 'The template language expression 'outputs('Get_items_2')?['body/value'][outputs('Compose')]['ID']' cannot be evaluated because property '{
  "value": [
    {
      "@odata.etag": "\"4\"",
      "ItemInternalId": "3",
      "ID": 3,
      "Title": "Name Surname",
      "Counter": 11.0, [...]

大部分属性信息中的大部分必须被编辑

[...] cannot be selected. Please see https://aka.ms/logicexpressions for usage details.'.

我的流程:

“在此处输入图像说明”

“

sstatic.net/0t5ge.png“ rel =“ nofollow noreferrer 要提取此ID(在这种情况下,其等于3)作为获取物品的ID,我已经完成了。没有任何错误,我只是无法通过最后一行。

任何建议都非常感谢!

I am currently struggling with a flow almost identical to this one: https://powerusers.microsoft.com/t5/Building-Flows/Find-Lowest-number-in-list-column-and-use-to-sort-items/td-p/777718

My flow fails at the last Get Item operation with following error:

Error
Action 'Get_item' failed

Unable to process template language expressions in action 'Get_item' inputs at line '0' and column '0': 'The template language expression 'outputs('Get_items_2')?['body/value'][outputs('Compose')]['ID']' cannot be evaluated because property '{
  "value": [
    {
      "@odata.etag": "\"4\"",
      "ItemInternalId": "3",
      "ID": 3,
      "Title": "Name Surname",
      "Counter": 11.0, [...]

most of this part of the property info had to be redacted

[...] cannot be selected. Please see https://aka.ms/logicexpressions for usage details.'.

My flow:

enter image description here

enter image description here

enter image description here

enter image description here

Basically I need to extract this ID (in this case its equal 3) as ID for Get Item and I'm done. I just can't get passed this last line without any errors.

Any advice highly appreciated!

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(1

呆橘 2025-02-07 06:02:19

我希望这会有所帮助。使用此列表...

“

...使用此非常基本概念和表达...

“

...它产生了预期的结果。

底线,我认为您不需要组成操作,只需查询获取项目使用以下表达式设置结果

first(body('Get_items')?['value'])['id']

...想要从获取项目调用中的1个记录,以上似乎是实现所需目标的最简单方法。

您可能需要执行一些错误检查是否获得项目却没有返回。

I hope this helps. Using this list ...

List

... with this VERY basic concept and expression ...

Flow

... it produces the expected result.

Result

Bottom line, I don't think you need the Compose action, simply query the Get items result set using the following expression ...

first(body('Get_items')?['value'])['id']

Given you only want 1 record back from the Get items call, the above seems to be the easiest way to achieve what you want.

You may need to perform some error checking if Get items returns nothing though.

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文