Calculated Field from Sharepoint to PowerApps doest show as i want

[Anonymous]

Hello,

Can you help me i have a calculated field from Sharepoint that shows as i add the image, i want that shows like a 3 not like a 3.0000000000 i did this and does not work.

Text(parent.default,"[$-en-US]$###,####.00")

[Anonymous]

So in PowerApps, what shows up as the value without the Text() function formatting it. Is it just 3.00000000?

I'm not sure why it went from 3.00000000 in your initial post and then 300,000,000,000 in your next post.

Tell me what the value in the textbox is when you just have this:

parent.default

[Pstork1]

Based on your screenshot you are located in a different locale that uses different seperators etc for numeric entries.  The text format we supplied will work if you are in an English speaking timezone where we use ',' as a thousands seperator and '.' as a decimal point.  It looks like your unformatted number uses '.' as the thousands seperator.  I suspect that's why its not working.  Switch the format string to one appropriate for your locale.

[Anonymous]

Look

In sharepoint looks good just 8

[Anonymous]

I tried with both , the same result 8.000000000 8,000000000

[Anonymous]

This is odd.. It may have something to do with regional formatting as @Pstork1  mentions, but outside of that, I'm pretty stumped..

[Anonymous]

@Anonymous 

Maybe try ignoring the calculated field and just use this in PowerApps for that textbox Text property:

DateDiff('date in','date out',Days)

---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

[Anonymous]

i think is in sharepoint i have the formula that you said, but in SP and in PowerApps looks like the same 8.00000000

[Anonymous]

So instead of

Text(parent.default,"[$-en-US]$###,####.00")

as your original thread used, use this:

Text(DateDiff('date in', 'date out', Days),"[$-en-US]#,####")

 And let us know what that gives..

[v-xida-msft · Accepted solution]

Hi @Anonymous ,

Could you please share a bit more about the formula you applied the "Calculated" field in your SP List?

Have you taken a try with the Round function to convert your Calculated field value?

Actually, it is an known issue with the Calculated field from SP List in an canvas app. When retrieving Calculated field value from SP list in canvas app, the value would be displayed as a Text value with 13 decimals. The user @Casey-Lee has faced similar issue with you, please check my response within the following thread:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Calculated-SharePoint-column-giving-13-decimals-when-imported/m-p/399672 

Please consider take a try to convert the calculated field value with Round function in your Display form, set the Text property of the "Dias de disfrute" Label to following:

Round(Value(ThisItem.'Dias de disfrute'), 0)

or

Round(Value(Parent.Default), 0)

Please consider take a try with above solution, then check if the issue is solved.

Best regards,

[Anonymous]

I was facing the same problem and I tried everything suggested in this post but couldn't make it work. However I found a way to fix it.

The thing is that the sharepoint calculated column returns a string with a "." representing the decimal value but powerapps uses "," as the decimal value. When you try to Value() or Round() it'll just remove the dot and give a very big number because it thinks that "3.00000" is 300000 and not 3.

The way I've found to fix it was to simply replace the dot with a comma before rounding it up, like this:

Round(Substitute(ThisItem.'Dias de disfrute'; "."; "," ); 0)

It worked like a charm for me.

Hope it helps someone.