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?