Do you use Alteryx in a language other than English? If so, we want to hear from you! Please help us improve the international experience of our products by participating in this 5 minute survey.

We are updating the requirements for Community registration. As of 7/21/21 all users will be required to register a phone number with their My Alteryx accounts. If you have already registered, you will be prompted on your next login to add your phone number.

Alteryx Designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Object reference not set to an instance of an object: Sharepoint list Output Tool

saurabh79
7 - Meteor

Hi guys, I am battling an error message which i cannot seem to find any answers to. So basically what my workflow does is read a SharePoint list. It also reads an excel file. Any row that is in the excel file but is not on the SharePoint list is then  appended to the SharePoint list using the "append existing" function of the SharePoint List Output tool. However, i keep getting the error "Object reference not set to an instance of an object" in my SharePoint List output tool when trying to append. I have attached a screenshot of where the error occurs.

Designer version:2019.2.5

SharePoint Version: 2010

Untitled.png

 

Any help would be greatly appreciated.

Thanks

5 REPLIES 5
grazitti_sapna
15 - Aurora
15 - Aurora

Hi @saurabh79,

 

Did you try changing the list or object in sharepoint, there might be a possibility of bug as I can see several posts with same issue. Here is the link to one of the post-https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Error-with-SharePoint-List-Input-conne...

Sapna Gupta
saurabh79
7 - Meteor

Thank you. I have had a look as well before posting and they seem to be talking about the SharePoint list input tool while mine is happening to the output tool.  

grazitti_sapna
15 - Aurora
15 - Aurora

Try selecting a test list if you have in sharepoint and then try to output it also try refreshing the list as I can see there is a refresh button, I guess this error is due to if the output tool is not able to find that object/list in sharepoint or is a bug.

Sapna Gupta
WhenCutEsh
6 - Meteoroid

Generally this error comes when your output contains nulls.

dawnh80
7 - Meteor

When I received this error I switched from SharePoint 2013 to 2007 in the drop down and it worked. 

Labels