I am trying to build a workflow that outputs to a Sharepoint List. I can read the Sharepoint List into input without any issues. There are no error codes on the output. I have tried: * Checking all of the data types for a match * Including an ID field, and then excluding an ID field, ensuring that my new ID field starts numbering out of range of the previous so +1000 * Trying all of the different Output Options on the Sharepoint Tool * Creating a New Sharepoint List from Excel output in Alteryx first so that the formats will match * Outputting only 2 columns, 1 text and 1 numeric for ease of testing * Outputting the text column as “Title” and then also trying with renaming “Title” as the Text column actual name that was renamed in Sharepoint and outputting that * Checking permissions on the site I have read all of the posts on the community that I can find, but nothing seems relevant. Any ideas?

Not really unfortunately: we have migrated Alteryx gallery version and upgraded clients to Windows 11, so it's very difficult so far to troubleshoot and identify the culprit - once I'll be able to focus few hours on resolving this, will post an update.

@geordie986 Were you able to figure this out? I'm having the same issues you are having. I don't receive any errors but no updates are being made to the SP list.

Sharepoint Output - updating a Sharepoint List, no errors but no output

harvjul

I am trying to build a workflow that outputs to a Sharepoint List. I can read the Sharepoint List into input without any issues.

There are no error codes on the output.

I have tried:

Checking all of the data types for a match
Including an ID field, and then excluding an ID field, ensuring that my new ID field starts numbering out of range of the previous so +1000
Trying all of the different Output Options on the Sharepoint Tool
Creating a New Sharepoint List from Excel output in Alteryx first so that the formats will match
Outputting only 2 columns, 1 text and 1 numeric for ease of testing
Outputting the text column as “Title” and then also trying with renaming “Title” as the Text column actual name that was renamed in Sharepoint and outputting that
Checking permissions on the site

I have read all of the posts on the community that I can find, but nothing seems relevant. Any ideas?

Output

Sharepoint

Accepted answers

All comments

TrevorS

Hello @harvjul

Can you please include a copy of your workflow, and also include some of the following information to better troubleshoot the issue.

Are you getting any messages from Alteryx when the workflow finishes?

Are you using a Sharepoint Output tool for the output?

What version of Alteryx are you using?

Once you provide the workflow and some more information the Community can help troubleshoot further.
Thanks!
TrevorS

harvjul

After a lot of trial and error, I got the Sharepoint write to work. Data Types seemed to be the reason for most of the issues.

harvjul

Better documentation would be very helpful around the fields that are autocreated and the fields that you can and cannot push out to the list.

Each time I've run into this it has been that a user has inserted a bad character forcing a wrong datatype. Once I find the culprit and fix, everything runs smoothly again (albeit very, very slowly and with the deprecated List Connector Tool, as the User Group permissions required by the new Sharepoint Connector are too wide sweeping for our IT team to agree.)

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703