decimal numbers are converted into integers when importing them into dataverse

(0) Share

Report

Posted on by Reini

Hey there,

my problem is, when I will import an Excel-File into Dataverse in Teams,

the decimal numbers in Excel become integers in Dataverse.

on the left Dataverse: on the right Excel:

I tried it with english format (changing the Settings in Excel to use a Point instead of a Comma) but it also didn`t work.

I also tried several Encodings like Windows 1252 and UTF-8, also with point and comma, nothing worked.

Also tried different settings in the Query Builder.

Is there any easy solution?

Thanks for your help.

Categories:

Microsoft Dataverse with Power Apps

QueryBuilder.PNG

I have the same question (0)

All responses (3)

Answers (0)

AhmedSalih

6,678 Moderator on at

Like (1)

Report

Hello, @Reini, Is your Dataverse Column a Decimal type column?

If my reply helped you, please give a 👍 , & if it solved your issue, please 👍 & Accept it as the Solution to help other community members find it more.

I am primarily available on weekdays from 6-10 PM CT and 5-10 PM CT on weekends.

Visit my Blog: www.powerplatformplace.com

Was this reply helpful? Yes No

Reini 3 on at

Like (0)

Report

Thanks for that hint, no my Dataverse Column is "Float".

I can`t change the datatype in my dataverse table if there is data in it, I also have problems to import the data with datatyp decimal, but I figured out a workaround:
If I transfer my data with power automate into dataverse, it will work.

Screenshot of the flow in the attachment, in this case with a sharepoint list, but also worked with dataverse.

Unfortunately, there is still no simple solution for a simple function like importing data in the correct data format..
Same Problems exists in Sharepoint.

Thanks for your help.

FlowPowerAutomate...

Was this reply helpful? Yes No
fritz77 6 on at

Like (0)

Report

I have the same problem importing excel table not only in Dataverse but also in Sharepoint list. I have the same behavior. I'm using Excel setting Italian local settings and Sharepoint site has the same setting.

Sharepoint/dataverse seems assuming English/us format (for ex. 1,900.00 instead 1.900,00), it find 1.900,00 and thinks "," like a thousands separator instead a decimal separator even if you correctly set regional setting.

Same problem if I use a .csv

Screenshot 2023-0...

Screenshot 2023-0...

Screenshot 2023-0...

Was this reply helpful? Yes No