search

SharePoint / sp-dev-docs

SharePoint & Viva Connections Developer Documentation
https://docs.microsoft.com/en-us/sharepoint/dev/
Creative Commons Attribution 4.0 International
1.24k stars 998 forks source link

ValidateUpdateListItem - suddenly stopped preventing loops #7527

Open damooji03 opened 2 years ago

damooji03 commented 2 years ago

Target SharePoint environment

SharePoint Online

What SharePoint development model, framework, SDK or API is this about?

SharePoint REST API

Developer environment

Windows

What browser(s) / client(s) have you tested

Additional environment details

Describe the bug / error

HTTP request action in flow used to update a SharePoint item using the ValidateUpdateListItem endpoint is causing the flow to loop. My team has many flows configured this way and have been running them for over a year with no issue, however recently (we think around 11/12/21) the flows started looping.

Steps to reproduce

  1. Create SharePoint list
  2. Create Power Automate flow > Automated cloud flow > When item is created or modified

Within the flow:

  1. Set the site and list name
  2. Add action 'Convert time zone'
  3. Add action 'Send an HTTP request to SharePoint'
  4. Select the same site address from step 1
  5. Method: Post
  6. Uri: _api/web/lists/getByTitle('')/items(@{triggerOutputs()?['body/ID']})/validateupdatelistitem()
  7. Headers: nothing but some people enter{ "Accept": "application/json;odata=verbose", "Content-Type": "application/json;odata=verbose" }
  8. body: { "formValues": [ { "FieldName": "Title", "FieldValue": "test@{triggerOutputs()?['body/ID']}" }, { "FieldName": "Editor", "FieldValue": "[{'Key':'@{triggerOutputs()?['body/Editor/Email']}'}]" }, { "FieldName": "Modified", "FieldValue": "@{body('Convert_time_zone')}" } ], "bNewDocumentUpdate": false }

Expected behavior

The REST call updates the item without triggering the flow. This has been working for over a year for 80+ flows we have, and suddenly we started getting floods of emails from users complaining about issues.

ghost commented 2 years ago

Thank you for reporting this issue. We will be triaging your incoming issue as soon as possible.

influential-eliot commented 10 months ago

Heya, this one is causing issues for two of my clients, just hoping that it is on the table soon.

But this is a document GIT, no? Is there a better place to raise this issue?

mblennegard commented 2 months ago

Seems like a duplicate to issue #7424

This is still very much an issue though.

influential-eliot commented 2 months ago

Yes, but I think that these issues are unfortunately for problems with the documents, that's the only reason that I mentioned it.

Seems like a duplicate to issue #7424

This is still very much an issue though.

(despite seemingly being the only public resource that we have to log such frustrations)

FWIW ... I think the issue is with whatever they have changed in how Power Automate is subscribing to List updates. Not a SharePoint issue per se.