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

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

Sharepoint

Accepted answers

Whenky

Generally this error comes when your output contains nulls.

All comments

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-connector/td-p/136310/

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.

Whenky

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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703