Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
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
17 - Castor

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
17 - Castor

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
Whenky
6 - Meteoroid

Generally this error comes when your output contains nulls.

dawnh80
8 - Asteroid

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

Labels