When we edit a row in a SharePoint List which has a PowerApps Form associated with it, the LookUp field displays 10 additional Zero after decimal.

enter image description here

How to remove that additional 0? I tried finding some properties but I was unable to find.


We could use Text function in Power Apps to convert any value and formats a number or date/time value to a string of text.

However it doesn't work for lookup column.

As a workaround, change the column type of the looked up to single line of text instead of number type.




Use ABS(ColumnName) As I have used the following for Label with Text Property If DropDown.Selected.Value=5 & price Per Unit is 1100 Then via Apply Abs(ThisItem.DropDown.Selected.Value * ThisItem.Price) It Gives results: 5500

For further Reference you can Use https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-numericals


Abs(ThisItem.DropDown.Selected.Value) ...Saved my Day Thanks

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.