SharePoint List Output not extracting all the records from the view

Hi All,

I am trying to extract a SharePoint list, When I use the SP list output I get data in which couple of columns are entirely null

When i compare them with the exported version of SharePoint list i.e. by manually clicking on the button "export to excel" I find values on those columns.

Why am I not getting the same data when extracted via Alteryx

Am I missing anything

Upload to alteryx.PNG

Sharepoint

Accepted answers

All comments

JohnGD

Hi @Manjari !

If you add a browse tool right after the SP input, can you see the same data as in your excel export ?

Thank you in advance,

John

Manjari

Hi @JohnGD,

I get the Same number of records and columns in the browse tool as that of the excel export, but data in the columns are missing

Aurovind

I am facing the same issue. Is there a workaround or fix ?

Aurovind

Root cause of this issue in my case was due to SharePoint List threshold limit error. People picker field has a limit of 12, after deleting couple of fields, the issue was fixed.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703