Power Automate: Error 400 - file locked for shared use

One of a number of issues you get when you are updating data between data connections connecting to the same file resource, is one connector locks out the other. The most common we see is when you grab data using the Excel Online data connector, and updating the SharePoint columns of the same file. If you are not comfortable working with the http request, there are some great ways to resolve this. For everyone else, here's a video to keep it simple. 04:15 - The Set Variable code you need to test if an error is returned is as follows: if(and(equals(outputs('Update_file_properties')?['body']?['status'],400),contains(outputs('Update_file_properties')?['body']?['message'],'locked')),true,false)