If your goal is to set a specific format of your text then please check the following page: https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-text
i tried enter this formula to "Update" Text(DataCardValue13_1.Text, "[$-en]##.#####")
DataCardValue13_1 is text input with entered numbers
But i still receive rounded numbers 0.06 instead 0.0600
Sorry. I misunderstood the original question. Are you looking to have the value stored in SQL as formatted? If so then I would recommend keeping the value as it is in SQL and formatting it on the client instead. In your case, you can just format the value shown in PowerApps Form card (apply the text formatting on the TextInput control or Label control that displays it, not on card update). Wil lthis work?
Hi @Flashback ，
This is about SQL Server, not PowerApps.
Could you tell me this field's data type?
If it is float, system will only save valid float number by default.
I suggest you update your data type to this：
Then, 4 decimal places will be saved.
I tried all data types i think.
But this is app for balances.
And some balances weight on 4 decimal places and some on 5 decimal places.
If i use decimal type (18,5), so... if user enter 0.0500 (only 4 decimal places) in SQL will be add 5th place and in app i will see 0.05000
Hi @Flashback ,
This is about SQL Server's setting, regardless of PowerApps.
Since there are many "000" in your data is invalid, so if you want to retain them, you should be clearly whether you want to save 4 decimal places or 5 decimal places.
If you want to save 4 decimal places, please set type (18,4).
If you want to save 5 decimal places, please set type (18,5).
Check out the on demand sessions that are available now!
ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.
Features releasing from October 2020 through March 2021
Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!