cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jovalles
Helper II
Helper II

Calculated Field from Sharepoint to PowerApps doest show as i want

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")

 

powerapps support.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
v-xida-msft
Community Support
Community Support

Hi @Jovalles ,

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

 

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,

Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

19 REPLIES 19
EricLott
Resident Rockstar
Resident Rockstar

Try this:

 

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

 

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

Does not work.

 

It is a calculated field on sharepoitn just saying.

 

 

I just tried what @EricLott suggested on a calculated value of my own.  Make sure you are adding the formula to the Text property of the DataCardValue. 

 

Text(Value(Parent.Default),"[$-en-US]$###,###")

 

But here is the one that worked for me.

 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Spoiler
 

Look does not work for me:

 

 
 

powerapps2.PNG

EricLott
Resident Rockstar
Resident Rockstar

@Jovalles 

Can you show us the SharePoint entry that's being pulled as well as the calculated column formula? I can't think of any other reason why it would be pulling anything other than the entry value.

Yeap,

 

The formula is beetween to rows,

 

date in (row one) / date out (row two) / Dias disponibeles (row 3 calculated number)

 

Formula  =[date in]-[date out]

 

EricLott
Resident Rockstar
Resident Rockstar

Try this as your SharePoint formula:

https://support.office.com/en-us/article/datedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c

DATEDIF([date in],[date out],"D")

I did,

 

But same result 😞

Helpful resources

Announcements
PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

Top Solution Authors
Top Kudoed Authors
Users online (3,794)