cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
giancarlodr
Frequent Visitor

Format decimal numbers (in the Card)

Hi

 

I have form with Card for edit record, and i have the field Price(type decimal), and in the option Advanced the type format is "TextFormat.Number"

 

When i saved the record not decimal example € 12,34, store 1234

 

Thank

 

 

2 REPLIES 2
v-yamao-msft
Community Support
Community Support

Hi Giancarlodr,
                      
What was the data source of your App? Was there a Currency column in your data source? After you submitted the record, did the data saved in the right format in your data source?

 

I created an App, and the data source was SharePoint Online list. In the list, I had a Currency column. When I submitted the record, the Currency was shown as “1234” in the App, but in the data source, the Currency was shown as “$1234”, just as what I formatted the column type.

 

If I misunderstand you, please feel free reply.

 

Best regards,
Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Anonymous
Not applicable

Hi!

 

In the really the problem isn't the "Currency symbol", but the decimal values after dot or comma... I'm experimenting the same problem here and finding a solution... In my database (SQL Server) I have a column created as "[decimal](18, 2)" what means that I can record number like "1500.15" or "1.33", but when I create a datacard with a input text with "Format = Number", the value registered in the database is just "1500,00" or "1,00"... the insert command auto generated by Power App Not include the decimal values...

 

I understand this behaviour as a bug... Has anyone already registered decimal values in the database using PowerApp?

 

Thanks.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,344)