cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
adam13hylo
Frequent Visitor

ValidateUpdateItem causes flow to trigger multiple times.

Hi all, 

 

Wondering if anyone can provide any help. 

 

Currently I have a very simple PowerAutomate flow that is triggered on item creation or modification. The flow is associated with a

very basic list containing just a title column for testing purposes. Using the 'validateUpdateListItem' endpoint along with the SharePoint HTTP action I am trying to update the title.

 

When testing this the list item is updated as expected, and the version does not increment, however the PowerAutomate flow is triggered again as if the list item has been modified.

 

When inspecting the body of the trigger when the flow is triggered I can see that the modified date is an hour behind that of the actual modification time, as an example:

 

 

ModifiedDate.png

 

Even when converting the date to UTC using a PowerAutomate expression in the body of the HTTP Post action I am finding that the flow is being triggered multiple times, as an example:

flowtriggers.png

 

Currently the HTTP Post Action is configured as so:

Endpoint
https://tenant.sharepoint.com/sites/sitecol/_api/web/GetList('/sites/sitecol/Lists/mylist')/items(ID...

Method
Post

Headers

 

 

 

{ "Accept": "application/json;odata=nometadata", "Content-Type": "application/json;odata=nometadata" }

 

 

 

Body

 

 

 

{"formValues":
	[
{ "FieldName": "Modified", "FieldValue": "2021-10-21 22:52:36" },
{"FieldName":"Editor", "FieldValue":"[{'Key':'username@tenant.onmicrosoft.com'}]"},
{"FieldName":"Title","FieldValue":"UpdatedTitle"}
	],
		"bNewDocumentUpdate":true
}

 

 

 

 

To format the modified date within the body of the HTTP request I am using the following expression:

 

 

 

@{convertFromUtc(triggerBody()?['Modified'], 'GMT Standard Time', 'yyyy-MM-dd HH:mm:ss')}

 

 

 

 

Appreciate if anyone can help me out with this as I am currently seeing this issue suddenly arise across multiple tenants. 

 

The flow in full is as below:

fullflow.png

 

1 REPLY 1
damooji
Frequent Visitor

I just posted about this here, having same if not similar issue. Basically, had created many flows since last year using the validateupdatelistitem endpoint...all were working perfectly fine until recently, they started to loop. As Pstork1 mentioned in a reply to my post, can only assume MS pushed some update that changed how this works.  Quite unfortunate and sucks, my team has been getting emails from customers, and poor customers have been getting constant email notifications caused by the loops. I couldn't find anything else on this and sounds like for now, only option to use another work around...

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Power Automate Designer Feedback_carousel.jpg

Help make Flow Design easier

Are you new to designing flows? What is your biggest struggle with Power Automate Designer? Help us make it more user friendly!

Top Solution Authors
Top Kudoed Authors
Users online (1,292)