Updating a SharePoint list

Question

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

JTCairns · Answer

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.

craigja · Answer

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

mceleavey · Answer

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.