community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

SharePoint List Output not extracting all the records from the view

Meteor

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

Alteryx
Alteryx

Hi @Manjari_T !

 

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

John Gonggrijp Dowe
Customer Support Engineer
Alteryx
Meteor

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

Alteryx
Alteryx

Hi @Manjari_T,

 

Could you send an email to support@alteryx.com with the following :

 

- Version of Alteryx

- Version of Sharepoint

- Configuration of the SP input tool

- Number of records read through

- sample data and workflow to reproduce

 

These will allow us to troubleshoot further.

 

Thank you in advance.

John Gonggrijp Dowe
Customer Support Engineer
Alteryx
Meteoroid

I am having the same issue.  It's missing data in two of the columns (Created By and Modified By) from the SharePoint List in the alteryx workflow so both columns are empty. 

 

In SharePoint site where you can view the list directly, the columns have values (the person's full name in last name, first name format) but they are a clickable link for sending IM text or calling their phone via Skype. 

 

Is there a workaround for this?  So alteryx will pull in the values correctly for those columns...

Labels