Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

SharePoint Input Tool Error - The property or field has not been initialized

sjb
5 - Atom

I am trying to connect my workflow to a SharePoint input but get the below error:

 

Error: SharePoint List Input (4): Error encountered: The property or field has not been initialized. It has not been requested or the request has not been executed. It may need to be explicitly requested.

 

The view i am connecting to in SharePoint has 10 lookups fields called Supplier 1 to Supplier 10.

 

Initially I thought the problem was that I had too many lookups in the view so I changed the view to only show x4 of the lookup fields e.g. Supplier 1-4 and this worked fine no error. I decided to try and have two sharepoint inputs on the same list with two different views supplier 1-4 and supplier 5-8 however when I run the flow the first SharePoint input with suppliers 1-4 works fine but second input with supplier 5-8 gets the same error message as i originally received. 

 

If I change the second view to only show one lookup field it all works fine but this confuses me how I can have one sharepoint input with 4 lookups fields working fine but cant get a second to work.

 

Anyone else seen this issue and is aware of what the problem is as I dont really want to have multiple sharepoint inputs into a multiple join would prefer just one input. 

1 REPLY 1
gautiergodard
13 - Pulsar

@sjb 

Could you share a screenshot for how your SharePoint input tool is configured? I’m not aware of any limits to how many look up fields can be pulled into the tool however I do know that the results can vary depending on the SharePoint version you select within the SP input tool.

 

Could you try changing the Sharepoint version to 2010 or 2013 in the input tool to see if that works?

Labels
Top Solution Authors