Lot of Zeros

[dalacarelia_196]

Hello all know hows 

I have in my SP List created Weeknumbers and when i connect to the database it comes out a lot of zeros but the value in SP is text on that field , som my GUI solution is ThisItem.'V-nr'/10000000000000 but that sucks .

This is the vaue coming out from SP , any idea how to fix som its only 34 as value .

[rsaikrishna]

@dalacarelia_196 

Use Text function to format numbers in desired format.

Regards

Krishna Rachakonda

If this reply helped you to solve the issue, please mark the post as Accepted Solution. Marking this post as Accepted Solution, will help many other users to use this post to solve same or similar issue without re-posting the issue in the group. Saves a lot of time for everyone.

[eka24]

Consider this:

Text(Value(ThisItem.'V-nr''),"[$-en-US]#")

Or

Text(Value(ThisItem.'V-nr'),"[$-en-US]#")
Or
Text(ThisItem.'V-nr',"[$-en-US]#")

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[timl]

Hi @dalacarelia_196 

I suspect the reason why you're seeing this is because 'V-nr' is a calculated column. There are more details here.

https://powerusers.microsoft.com/t5/Building-Power-Apps/change-the-number-of-decimals-for-a-number/m...

If that's the case, there is no way to fix this from the SharePoint side. The only workaround is to use the formula that you're currently using, or the Text functions as the others have suggested. Another method would be to call the Round function like so.

Round(
      Value(ThisItem.'V-nr'),
      0
)

[dalacarelia_196]

Hello 
My result is not dot  between 34.0000000  maybee i have the answer in Sharepoint forums 

[dalacarelia_196]

Hello i been trying different ways and my reslut is missing the dot between 34.000000
maybe i have to look in sharpoint and my langague as Swede we are using commas in numbers not dot 

Thanks for the time you spending helping me .

[eka24]

Can you show a screenshot of how the figures are in the sharepoint?

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

[Anonymous]

1. I have the same issue. The Columns is calculated from others in the SharePoint. All other fields in the power apps is working, including currency values, but the calculated one comes with 11 more zeros. I tried Text function just like proposed but didn't work. Viewing the list at SharePoint the data is shown perfectly. I can't say if matters but here, in Brazil, the dot is used to identify millers and coma to decimals.

[timl]

@Anonymous  - did you try my suggestion above, which is to call the Round function?

[Anonymous · Accepted solution]

Hi @timl , Round function didn't work for me but I succesfully tryed another approuch:

Value on Sharepoint list
R$ 1.100,00

Value on PowerApps
1100.00000000000

Round function on Powerapps
Round(Value(ThisItem.MyField);2)
=110000000000000

My povisory solution:
Substitute(ThisItem.MyField;".";",")
=1100,00000000000
So, I can use something like
Text(Value(Substitute(ThisItem.MyField;".";",")); "[$-pt-BR]R$ ###.###,00")
wich results 

R$ 1.100,00.

Anyway, thanks for replying.