Unanswered

Problems with decimal values format in Entity form

(0) Share

Report

Posted on by velardecrj

Hello,

I use a Entity Form, wich has a numeric field. When the value is a decimal number, I have problems with the format, because if I enter 1.2 , in dynamics 365, the field shows 12.

How can I solved this?

Categories:

Power Apps portals

I have the same question (0)

All responses (12)

Answers (0)

oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

Hi, can you try with "," instead of "." as decimal separator?

this could be an issue with the dataverse datatype formatting

Was this reply helpful? Yes No
ArchitectMadhan 1,584 on at

Like (0)

Report

Hi @velardecrj ,

Please let me know, what type of field you are trying to store the decimal number in Dynamics 365? Floating point number or Decimal number or whole number?

Was this reply helpful? Yes No
velardecrj 16 on at

Like (0)

Report

Hello:

I am triying to store Foating point number. But when a user enter a number in the form ( for example: 1.25), Dynamics is showing 125.

Please note that users that fill the form are 'unauthenticated' user, so in dynamics 365 the 'Created by' value is 'System user' .

Was this reply helpful? Yes No
ArchitectMadhan 1,584 on at

Like (0)

Report

Hi @velardecrj ,
Are you using Entity form in Dynamics 365 Portal? I understand that you are trying to store floating point number, but what is the Entity Field Data type?

Was this reply helpful? Yes No
velardecrj 16 on at

Like (0)

Report

Hello. The field data type is decimal number (with 2 decimals).

The problem is the format. In my entity form I have to enter 1,50 instead 1.50, in order to get the correct number. But users always use decimals with point number, so in Dynamics the field shows 150.

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (1)

Report

Thanks, so it's working using "," as separator, this looks like a data formatting issue.

Can you try navigating to Power Platform admin center (microsoft.com) --> select your environment --> Settings --> Business --> Regional Formatting:

the idea here is actually to get to the system settings --> any option above will get you there

on the top menu, select settings --> administration:

now click on System settings --> Formats:

select your local format, and then refresh the Portal cache

Was this reply helpful? Yes No
velardecrj 16 on at

Like (0)

Report

Hello Oliver, we have configured setttings that youy describe for our users (employees), but take into consideration that the form is filled for unauthenticated user, so, finally, the user/propietary is 'System user', wich not have this format configuration.

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

Hi, you probably did that in the user personal settings.

The steps above should apply to the system level.. have you tried that?

Was this reply helpful? Yes No
velardecrj 16 on at

Like (0)

Report

Hello: I have configured at the system level, but the problem persist. What other options could I try?

Was this reply helpful? Yes No
oliver.rodrigues 9,368 Most Valuable Professional on at

Like (0)

Report

Hi, can you add snapshots on how you got to that page? for some reason it doesn't seem to be the same page as I was showing you

Was this reply helpful? Yes No