I recently moved from a 2019 version of Alteryx to 2021.4.2.35356 and now my workflow will not update existing Sharepoint items. I can successfully append items to the existing list, but cannot change data in the items that are currently there. A big part of my workflow is to look compare items that are in Sharepoint and in a current version of an Excel file and then to change the status of the item to closed for ones that are not in both places. This worked perfectly in the 2019 version of Alteryx but is not working in the new version. For some detail, there are 3 Sharepoint output tools all of which perform different functions in the SP list, and I have hold until done tools inserted prior to the SP tool. Below are the troubleshooting steps I have taken previously:
None of the above updated the items in SP.
Did you ever get a resolution to this? I'm having the exact same issues as you and have went through the same troubleshooting steps. I keep thinking the new version of the connector is going to solve the issue, but it does not. Oddly, I was able to get the update to work on a test list with significantly less records. Both lists have the same exact settings as far as I can tell.