Hi,
I am currently creating a sharepoint list that tracks employee on-boarding. I already created a flow that creates folders for every employee in a document library, and adds all attached files in those folders. The folders are named after the employees themselves.
I am currently creating a seperate flow that tracks if the names of the employees are changed (due to a spelling error for example).
With the ID and a custom expression, I manged to initialize the variable 'Old Name' using data from the previous version in sharepoint list. Than I use an if condition to check if the column variable 'Medenwerker' has been altered (aka the employee's name). If so, I use a Send HTTP request to try and replace the old folder name with the new folder:
Most of the flow seems to work fine, but during the final step with the HTTP request, the flow takes an unusually long (like 12 minutes) to load before giving up. It keeps saying that "X retries occured". Most of the time it has 2 retries with a "BadGateway" status, and I cant figure out why this happens.
So how can I fix this issue? Maybe this isn't even the best way of going about things (ideally, it tracks other kinds of changes like removed attachments as well), so suggestions are very welcome!
Sincerely,
Jelmer
This generally happens when you are trying to access a resource which is already locked by another user/flow/or current flow. You need to find a way to release the resource, before your HTTP request, refer the blog post below this might help...
How to clear annoying Excel file locks in Power Automate – CleverWorkarounds