SharePoint "Number" field with number of decimals = Zero. will still show the number with decimals

[johnjohn-Peter]

I have this Column of type number and number of decimal = Zero:-

now using the SharePoint UI or using Power Apps, if I enter a number with decimals (6.5 for example) seems inside the SharePoint UI the number will get rounded (to 7), as follow:-

but inside Power Apps or SharePoint API (such as GetItems action inside power automate) will still show the original number with decimals (6.5), as follow:-

any advice how this work in sharepoint?

Second question, in general if i change the "number of decimal places" list inside the column type, from Zero to Automatic will this cause any data lose? i do not think so? Now, if i do so at least the SharePoint UI will be compatible with the API, Power Apps and Power Automate.

Thanks in advance for any help.

[#2 · Accepted solution]

@johnjohn-Peter this works as designed; you have set the number of decimals to 0 so however the number is being added to the list item it will always display with no decimal places even though the underlying number might have decimals.

You will not lose any data by changing the number of decimal places.

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)