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.
Solved! Go to Solution.
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:
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)
Please consider take a try with above solution, then check if the issue is solved.
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.
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.
But here is the one that worked for me.
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.
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]
Try this as your SharePoint formula:
DATEDIF([date in],[date out],"D")
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.