Simple "when modified" flow crashing

[LitHouse]

Hello,

I have created a really simple flow which worked for a long time and then suddenly crashed.

1. The idea is that once we finish some project, if there is a parcel to send back and if i consider it as worth to publish in our marketing channels i just mark those 2 fields:

2. After this, there should appear a task in another planner.
3. What actually happens is when i mark anything the flow launches itself for hundred of times:

4. The flow looks like this:

5. And as i said, it worked for a long time without any trouble. I can not understand what goes wrong in such a simple one. 

6. I think it must be something with the inputs, as the flow applies even to list items that i did not touch. For example, i modify item ID.104 and it applies for item ID.137...

{"headers":{"Transfer-Encoding":"chunked","Retry-After":"21600","Vary":"Origin,Accept-Encoding","X-SharePointHealthScore":"2","X-MS-SPConnector":"1","X-SP-SERVERSTATE":"ReadOnly=0","DATASERVICEVERSION":"3.0","SPClientServiceRequestDuration":"155","SPRequestGuid":"569f41ac-4fa5-49fe-90cf-4b060e50d5af","request-id":"569f41ac-4fa5-49fe-90cf-4b060e50d5af","MS-CV":"rEGfVqVP/kmQz0sGDlDVrw.0","Strict-Transport-Security":"max-age=31536000","X-FRAME-OPTIONS":"SAMEORIGIN","Content-Security-Policy":"frame-ancestors 'self' teams.microsoft.com *.teams.microsoft.com *.skype.com *.teams.microsoft.us local.teams.office.com *.powerapps.com *.yammer.com *.officeapps.live.com *.office.com *.stream.azure-test.net *.microsoftstream.com *.dynamics.com *.microsoft.com;","MicrosoftSharePointTeamServices":"16.0.0.22323","X-Content-Type-Options":"nosniff","X-MS-InvokeApp":"1; RequireReadOnly","Timing-Allow-Origin":"*","x-ms-apihub-cached-response":"true","x-ms-apihub-obo":"true","Cache-Control":"max-age=0, private","Date":"Mon, 11 Apr 2022 18:14:58 GMT","Location":"https://europe-002.azure-apim.net/apim/sharepointonline/c462d94ceb104a77add577d502f1e8a0/datasets/https%253A%252F%252Flithousepl.sharepoint.com%252Fsites%252FZlecenia30/tables/486e4a36-5962-4b87-9dfc-2663f4cf4644/onupdateditems?view=02a5683a-6726-4ff1-b57d-391b9db5bdf2&triggerstatecl=MTszOzQ4NmU0YTM2LTU5NjItNGI4Ny05ZGZjLTI2NjNmNGNmNDY0NDs2Mzc4NTI5NzY5ODEwMzAwMDA7NzI1MTM5NTU0&triggerstate=ZGF0ZXRpbWU9MjAyMi0wNC0xMVQxODoxNDo1M1o%3d","P3P":"CP=\"ALL IND DSP COR ADM CONo CUR CUSo IVAo IVDo PSA PSD TAI TELo OUR SAMo CNT COM INT NAV ONL PHY PRE PUR UNI\"","X-AspNet-Version":"4.0.30319","X-Powered-By":"ASP.NET","Content-Type":"application/json; charset=utf-8","Expires":"Sun, 27 Mar 2022 18:14:58 GMT","Last-Modified":"Mon, 11 Apr 2022 18:14:58 GMT","Content-Length":"14127"},"body":{"@odata.etag":"\"3391\"","ItemInternalId":"137","ID":137,"Klient":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":21,"Value":"ECHO"},"Klient#Id":21,"Nazwazlecenia":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":2,"Value":"PACKSHOT"},"Nazwazlecenia#Id":2,"Data":"2022-03-21","Lokalizacja":{"@odata.type":"#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference","Id":1,"Value":"MAŁE STUDIO"},"Lokalizacja#Id":1,"Szczeg_x00f3__x0142_ysesji":"https://lithousepl.sharepoint.com/:w:/s/Zlecenia30/EWxHuRnHHFBLngXIsF-_s3ABkbNPzDy8K01dxf2vtdTGJA?e=uePQNc","Deadline":"2022-03-28","Sp_x00f3__x017a_nione_x0020_dni":"14.0000000000000","Gotowe0":true,"Gotowe":true,"Paczkazwrotna":true,"Marketing":true,"{Identifier}":"Lists%252fZlecenia%252f137_.000","{IsFolder}":false,"{Thumbnail}":{"Large":null,"Medium":null,"Small":null},"{Link}":"https://lithousepl.sharepoint.com/sites/Zlecenia30/_layouts/15/listform.aspx?PageType=4&ListId=486e4a36%2D5962%2D4b87%2D9dfc%2D2663f4cf4644&ID=137&ContentTypeID=0x01000E9C813F464A5F4DBA100DE54EAE17430038F6290B207F69418E2233D39F198D27","{Name}":"","{FilenameWithExtension}":"(no title)","{Path}":"Lists/Zlecenia/","{FullPath}":"Lists/Zlecenia/137_.000","{HasAttachments}":false,"{VersionNumber}":"3391.0","{TriggerWindowStartToken}":"MTszOzQ4NmU0YTM2LTU5NjItNGI4Ny05ZGZjLTI2NjNmNGNmNDY0NDs2Mzc4NTI5NzYyMjAxMDAwMDA7NzI1MTM4NTE3","{TriggerWindowEndToken}":"MTszOzQ4NmU0YTM2LTU5NjItNGI4Ny05ZGZjLTI2NjNmNGNmNDY0NDs2Mzc4NTI5NzY5ODEwMzAwMDA7NzI1MTM5NTU0"}}

7. I am still new in power automate and this might be a stupid mistake but as I say, it worked for long time and i really can not find the reason behind crash as this flow is so simple, i have no idea what could go wrong.

Hope someone can help me and its a really easy one 🙂
Thanks

[ScottShearer]

@LitHouse 

Are you updating the SharePoint list in your Flow?

[LitHouse]

yes, as I tried to make the same flow from scratch with different planners, I updated SharePoint list.

[ScottShearer]

@LitHouse 

My question is if you are updating the list from within your Flow - that might explain why the Flow is executing 100 times.  You are using When an item is updated trigger.

[LitHouse]

Nah, the flow that You see on the screen is it.
1. When an item is created or modified
2. Condition If "Parcel" = true
3. Create a task in some planner

Totally 0 impact on the SharePoint list. I think there is something wrong with the inputs that it takes into the flow, as it says "

{"headers":{"Transfer-Encoding":"chunked","Retry-After":"21600",

"
This "chunked" is a signal for me that something is wrong over there, but as I say, I am newbie in power automate.

[ScottShearer]

@LitHouse 

Got it.

This looks like a simple Flow - have your tried recreating it? I have noticed things just get funky sometimes.....

[LitHouse]

Yes, recreated it from scratch many times with different planners. Right now i recreated it using another list and works without any issue:

This means this is an issue with the list. I do not know what exactly, but this list is really huge one as it is the cornerstone of our company.
Is it possible that the flow is getting crashed because the list is contains too much data?

Thanks
Szymon

[LitHouse · Accepted solution]

ehh, You were right @ScottShearer. There was one hidden "calculated data" column that was calculating itself once I changed anything in the list. So the flow was launching another flow and so on and on.

In order to avoid it I had to use the "Get changes to an item or file (properties only)" action. (https://powerautomate.microsoft.com/en-us/blog/run-a-flow-when-a-sharepoint-column-is-modified/)

After this another problem occurred, my "Adddays" function which was supposed to add deadline to the task created by the flow stopped to work as the triggerbody changed to "null" variable (or something like this). 
So, I have used the "compose" action and then rewrote Addays to "addDays(outputs('Compose'), +4,'MM-dd-yyyy')" action.

Now, my flow runs only when I change item from the exact, chosen column and it is adding then a task with a person assigned, a start date and a finish date.

Perhaps this could help anyone, really simple flow but very functional:

Problem solved !