Intermittent 503/502 Error in SharePoint Create Item Action

%3CLINGO-SUB%20id%3D%22lingo-sub-366745%22%20slang%3D%22en-US%22%3EIntermittent%20503%2F502%20Error%20in%20SharePoint%20Create%20Item%20Action%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-366745%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20flow%20that%20reads%20items%20from%20a%20custom%20connector.%20Then%20an%20Apply%20to%20Each%20creates%20items%20in%20a%20list%20in%20SharePoint.%20This%20flow%20runs%20nightly.%20There%20are%20about%203300%20items%20created%20successfully.%20The%20flow%20has%20completed%20successfully%2014%20out%20of%2016%20days.%20On%20the%206th%20and%2011th%20run%2C%20the%20flow%20shows%20failed%20with%20this%20error%20message.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%7B%20%22error%22%3A%20%7B%20%22code%22%3A%20502%2C%20%22source%22%3A%20%22flow-apim-msmanaged-na-eastus2-01.azure-apim.net%22%2C%20%22clientRequestId%22%3A%20%22807d7b6c-35ac-4be0-ad14-6f151ef6944a%22%2C%20%22message%22%3A%20%22The%20response%20is%20not%20in%20a%20JSON%20format.%22%2C%20%22innerError%22%3A%20%22%5Cr%5Cn%5Cr%5Cn%5Cr%5Cn%3C%2FP%3E%3CH2%20id%3D%22toc-hId-1678937029%22%20id%3D%22toc-hId-1791600983%22%3EService%20Unavailable%3C%2FH2%3E%3CP%3E%5Cr%5Cn%3C%2FP%3E%3CHR%20%2F%3E%3CP%3EHTTP%20Error%20503.%20The%20service%20is%20unavailable.%3C%2FP%3E%3CP%3E%5Cr%5Cn%5Cr%5Cn%22%20%7D%20%7D%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20both%20instances%20of%20the%20%22failed%22%20flow%2C%20this%20error%20occurs%20only%20once.%20The%20flow%20has%20run%20since%20the%20error%20so%20I'm%20unsure%20if%20the%20Create%20action%20completed%20successfully%20and%20only%20the%20response%20failed.%20Is%20there%20a%20fix%20for%20this%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-366745%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-370261%22%20slang%3D%22en-US%22%3ERe%3A%20Intermittent%20503%2F502%20Error%20in%20SharePoint%20Create%20Item%20Action%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-370261%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F5328%22%20target%3D%22_blank%22%3E%40Robert%20Martin%3C%2FA%3E%26nbsp%3BI%20am%20facing%20the%20same%20issue...in%20a%20flow%20that%20deletes%20and%20recreates%20a%20large%20amount%20of%20items...no%20solution%20found%20yet....it%20is%20very%20random%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Deleted
Not applicable

I have a flow that reads items from a custom connector. Then an Apply to Each creates items in a list in SharePoint. This flow runs nightly. There are about 3300 items created successfully. The flow has completed successfully 14 out of 16 days. On the 6th and 11th run, the flow shows failed with this error message.

 

{ "error": { "code": 502, "source": "flow-apim-msmanaged-na-eastus2-01.azure-apim.net", "clientRequestId": "807d7b6c-35ac-4be0-ad14-6f151ef6944a", "message": "The response is not in a JSON format.", "innerError": "\r\n\r\n\r\n

Service Unavailable

\r\n


HTTP Error 503. The service is unavailable.

\r\n\r\n" } }

 

 

In both instances of the "failed" flow, this error occurs only once. The flow has run since the error so I'm unsure if the Create action completed successfully and only the response failed. Is there a fix for this?

1 Reply
Highlighted

@Deleted I am facing the same issue...in a flow that deletes and recreates a large amount of items...no solution found yet....it is very random