Output excel file is disturbed post using SharePoint Input Data Tool.

Question

I added a SharePoint tools to an existing workflow. The only change I did was change the file input/output to SharePoint input/output – I did edit some of the data transformation tasks in between. However, the formatting of my SharePoint output has changed, see comparison below; left is the output using SharePoint tools, whereas right is using the original file input/output tasks. This could cause issues while uploading the output.

Could someone help, how the formatting can be kept unchanged. Attached is the sample of excel file before and after using Share point tool.

SharePoint output file.png

OTrieger · Answer

@Harshvardhan1991 
look carefully at the 2 files, they are not the same. The one at the left side has a green mark next to the number, that is indicating that the number is actually text, a string type and not numeric type. You need to ensure that the data type is numeric as right now it is writing out string, text and not numbers. So on the right side excel rounding them up while on the left side it regarding it as a string.

Something changed along the workflow, as the data type changed to string while before it was numeric.

Gaurav_Dhama_ · Answer

If you are referencing to the number with so many decimal places, just round it to 2 digits in the formula tool, or change its type in select tool to fixed decimal 19.2. This will retain only two decimal places.