Some data not read from Sharepoint

[Grzegorz]

Hello guys,

very kindly ask you to look at my strange issue with Sharepoint Input List which I noticed today. I really need your support.

It’s all about wrongly getting data from SharePoint list. Please have a look at screenshots below.

One column – PSA.  We have ‘0’ value everywhere once it should have percentage data.

Please notice that this is what we have just after the first tool (Sharepoint Input List) so I am not making any format changes for this column.

This is how it looks in the source so on Sharepoint list page:

Settings of this column on SP:

Do you have any idea why is it happening?

I also checked it on other random columns.

Please have a look below.

This is how the data looks on source so sharepoint list page :

This i show look the settings for these column on SP (they are exactly the same):

These are the results in Alteryx:

Two similar columns with the same setup. CPM is not working, AIB – working.

Any thoughts?

If you think anyone else could be supportive in this case, please forward this message.

What’s extremely strange is that this feature (reading data from Sharepoint) used to work totally fine some time ago. Don't know what's going on.

I changed my laptop in the meantime but still using the same Alteryx version.

[suby]

Hello,

Try recreating your SharePoint list connector again and one possible issue could be check your Data type on the Select tool for that particular column.

Thanks