admin管理员组

文章数量:1277292

Please, help. Power automate flow that is doing a few things, and at the end checks the Sharepoint list and if it finds an item, it should update the item. If it does not find it, it should create it.

So, first, when I know the item is NOT there in the list, Checking for an item, "Get Items" step returns an error

The API 'sharepointonline' returned an invalid response for workflow operation 'Get_items' of type 'OpenApiConnection'. Error details: 'The API operation 'GetItems' is missing required property 'body/value/0/Location'.'

Please, note the value/0/

The Get Items input is the following

{
    "host": {
        "connectionReferenceName": "shared_sharepointonline",
        "operationId": "GetItems"
    },
    "parameters": {
        "dataset": "https://<domain>.sharepoint/sites/<siteName>",
        "table": "7de34a0a-3343-dcdk-c9",
        "$filter": "Title eq '2450002'"
    }
}

If I use the same input in another dummy power automate flow, I get no error, and just an empty dataset is returned (as expected)

Then, as a step 2, I check my main flow, with the item, that I know is in the list, and the 1st step ("Get items") works fine, but then the "Update Item" step returns an error

The API 'sharepointonline' returned an invalid response for workflow operation 'Update_item' of type 'OpenApiConnection'. Error details: 'The API operation 'PatchItem' is missing required property 'body/Location'.'

Please, note the 'body/Location' with NO /0/ array index in it ... I don't know if it matters, but it caught my eye.

The "Update Item" step is like this

with "Address" field mapped to the field named "Location" in the SharePoint List.

Checking the list shows that item did get updated.

Power automate flow is being called automatically ('When Http Request is received') and this error messes up the response that is expected by downstream consumption.

本文标签：

版权声明：本文标题：Power automate errors when updating sharepoint list item, but item does get updated - Stack Overflow 内容由网友自发贡献，该文观点仅代表作者本人， 转载请联系作者并注明出处：http://www.betaflare.com/web/1741236265a2363067.html， 本站仅提供信息存储空间服务，不拥有所有权，不承担相关法律责任。如发现本站有涉嫌抄袭侵权/违法违规的内容，一经查实，本站将立刻删除。