This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
Configuration: My workflow begins by reading a SharePoint list, one column of which is "% Complete". (Select tool connected to output of SharePoint List Input shows % Complete as a FixedDecimal, size = 18.0). Every list item has a value for "% Complete" between 0 and 100; no empty values. The SharePoint column is defined as a number type, min = 0, max = 100, 0 decimal places. There are 103 list items. When I run the workflow, it reports 13 conversion errors "SharePoint List Input | % Complete: "0" has too many digits after the decimal and was truncated." (About half of the conversion errors cite "0", the other half cite "1".) 52 of the list items have a % Complete value of "0", but none of the list items have a % Complete value of 1.
Why does Alteryx think "0" has any digits after the decimal?
Why does Alteryx think any of the list items have a % Complete value of "1"?
Is there a way to see exactly which row (list item) Alteryx thinks has an error?
My suspicion is the source data from SharePoint carried some type of formatting throughout its lineage as a dataset. Do you happen to know where the data that populated the SharePoint list came from? Did it come from Excel? Those columns may have been formatted as a % for example.
Did you set the FixedDecimal size to = 18.0? Does it behave the same way when it is set to the default 19.6?
The SharePoint data I entered manually. However, your question prompted me to check and the SP column is set to show as a percentage, but the number of decimal places is set to 0. Unfortunately, my 14-day Alteryx trial license has expired, so I can't check how the FixedDecimal size is configured. We may be doing a 30-day trial later, so I'll have to come back to this at that time.
I noticed this thread never got resolved so i hope i can help.
I am receiving this same issue. I have two columns in sharepoint, one column is a user input field as a percent and the other field is a calculated column. When i read the data from sharepoint into Alteryx i receive this error and for example a 50% in column A and 50% in column B in sharepoint will show as 1 in column A and 1 in column B in alteryx. This is only happening with these two columns which are in sharepoint as "Show as percentage" other numbers in the sharepoint are read in correctly.