Welcome to the Alteryx Knowledge Base
Knowledge Base / Designer / Sharepoint List Input tool "Error Encountered: Object reference not set to an instance of an ob...
Sharepoint List Input tool "Error Encountered: Object reference not set to an instance of an object"
Created/Edited -
Summary
Issue
Sharepoint List Input Tool is connecting to Sharepoint 2016. The dropdown list is successfully populated and a list is selected. When the workflow is executed, the following error occurs
Error encountered: Object reference not set to an instance of an object
Environment
- Alteryx Designer running as a Citrix desktop app
- 2021.4
- SharePoint
- 2016 (on-prem)
- SharePoint List Input Tool
Cause
Registry string value ‘UserEncryptionOnly’ has been applied which is causing the password to be stripped when moving off the tool's configuration pane, to the canvas. See article below for further details - User Encryption Only: New feature in 2020.3.8
Details
- Registry Key: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SRC\Alteryx
- Value Name: UserEncryptionOnly
- Value Data: true
Resolution
Add registry string DisableHideStripping and set the value to true.
- From Windows search, type Regedit (this will require Windows admin permissions)
- Navigate to Computer\HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SRC\Alteryx
- File > Export > Selected branch: HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\SRC\Alteryx to backup the branch
- Right Click on Alteryx > New string value > DisableHideStripping
- Double-click DisableHideStripping > Value data: true > OK
- Close Regedit
- Retest issue in Designer
Additional Information
Was this article helpful?