Updating a SharePoint list

[craigja]

Hi,

Has anybody manged to get the Update function working on a SharePoint list?  I have populated my list with a Primary Key but when I select the Update option in the SharePoint tool and select my Primary Key field, I get the error 'Bad request or unsupported method'  Im using version 2.4.1 of the SharePoint output tool

[mceleavey]

Hi @craigja ,

yes, but it can be fiddly. When updating you need to have the system generated ID field that is created on the list itself.

I tend to include all fields in the output when updating, and simply passing through the existing values for those fields you are not amending.

I hope this helps,

M.

[craigja]

When using the SharePoint connector (v2.4.1) it doesnt bring this field back, it brings back the title field but thats not unique in my list as I can have up to 5 rows with the same title 

[JTCairns]

 managed to work around this. 

On the SharePoint list I have a custom record ID field, this is generated in the Ayx workflow

The record ID column in SharePoint is indexed - this is very important

I use the custom Record ID field as the PK and not the native SP one

This has been working for me, hope it helps.