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:
I have read all of the posts on the community that I can find, but nothing seems relevant. Any ideas?
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
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.
Hey @harvjul - the sharepoint output tool does have a behavior where write actions can error out without an error being thrown. As a result - there are situations where your entire sharepoint list can be emptied out if you fail on the first row. I'm glad that you managed to debug this by looking at the data types - that is the most common issue.
I've logged an idea on this here: https://community.alteryx.com/t5/Alteryx-Designer-Ideas/Explicit-error-warnings-on-Sharepoint-Write-...
it may be worth you adding your own personal experience to that thread to support the case for improving the error-handling on the Sharepoint Output tool.
A more detailed Knowledgebase article would be helpful, too. Something that describes how to handle the Sharepoint ID and whether it is required to calculate in the workflow before outputting, how to set up the List, how to better check each datatype.
Hi @harvjul how did you solve the issue precisely?
I'm facing a similar problem. To prevent data type mismatch, I use the input from SharePoint Input (list) control -> run formula -> select control to limit fields (only ID & the fields to be updated) -> SharePoint Output (list) control.
Currently using Alteryx 2023.1 with SharePoint connector 2.4.1
No error but no update happens, for string and choices columns. Strangely, update of a numeric field works. Any ideas?
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.
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.)
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.