After countless hours trying to troubleshoot this issue, I've decided its time to reach out for support. I'm attempting to use the sharepoint list input tool in order to reach in a list. I'm able to see the list within my configuration but every time I run it I return the following error off the input tool:
SharePoint List Input (2) 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.
To make it even more odd, I can read in any other lists, including some that are much larger without issue. I've tried setting my version to 2007-2016 with the same results. Since everything else works without fail, I have to believe that there is something specific to the file or file structure that is causing this. Is there anything I should be looking for or a way to troubleshoot this deeper?
also if I download the file to excel format there is no issue with the workflow. Only when attempting to read in from sharepoint.