Lot of Zeros

(1) Share

Report

Posted on by dalacarelia_196

648

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 .

Categories:

Building Power Apps

I have the same question (0)

All responses (10)

Answers (1)

Sort by

rsaikrishna

3,703 Microsoft Employee on at

Like (3)

Report

Copy link

Link copied!

@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.

Was this reply helpful? Yes No

eka24 20,925 on at

Like (1)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
timl 36,813 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
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-p/674626

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 )

Was this reply helpful? Yes No
dalacarelia_196 648 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
dalacarelia_196 648 on at

Like (0)

Report
Copy link

Link copied!

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 .

Was this reply helpful? Yes No
eka24 20,925 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
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.

Was this reply helpful? Yes No
timl 36,813 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Community Power Pla... Microsoft Employee on at

Like (3)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
tomvanmaldergem 2 on at

Like (0)

Report
Copy link

Link copied!

Hello, I have read the solution to your issue. But do you already know what caused the problem? I have the same issue & want to fully understand it.

Was this reply helpful? Yes No