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.
How to remove that additional 0? I tried finding some properties but I was unable to find.
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
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