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

[saurabh79]

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

Any help would be greatly appreciated.

Thanks

[grazitti_sapna]

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...

[saurabh79]

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]

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.

[Whenky · Accepted solution]

Generally this error comes when your output contains nulls.

[dawnh80]

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