Values not appearing on android or ios

[CassimCoovadia]

Hi

I have an app with a form viewer. The form contains calculated values. The values often contain a number with many decimal digits. I have formatted it to only display 2 decimal digits, using the formula:

Text(Value(Parent.Default),"#.##")

When using the app in web form on windows the values are displayed correctly. However, when you open the application on android or ios the values are just blank and does not appear. When you remove the text format and leave just as Parent.Default it works just fine.

[iAm_ManCat]

Have you tried using Round instead? converting text to number then back to text can sometimes go a bit funny on mobiles

Round(Value(Parent.Default),2)

[cha_cha]

Hello @CassimCoovadia 

Please try:

Text(Value(Parent.Default),"#.00")

[CassimCoovadia]

Hi 

I tried this it still doesnt work. 

I know believe it's an issue caused by reading calculated values from a sharepoint list. 

I created this thread to explain that:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Calculated-sharepoint-value-not-appearing/m-...

Thank you

[CassimCoovadia]

Hi @iAm_ManCat 

I tried this, when I use the Round formula. If you open the app in web form it works fine (So does using text and value) but if you open the app on a mobile device the value appears as 0.

I know believe it's an issue caused by reading calculated values from a sharepoint list. 

I created this thread to explain that:

https://powerusers.microsoft.com/t5/Building-Power-Apps/Calculated-sharepoint-value-not-appearing/m-...

Thank you

[iAm_ManCat]

Why not replicate the calculation in Power Apps?

Use the datacard default values to recreate the formula like:

(NB: this code won't work, its just pseudocode for what you should be trying to do with yours)

TotalKG1.Text:

Datacard_JobWeight.Default / CountRows(Filter(MaterialsList, Title = Datacard_Title.Default))

and other similar codes for the labels that replicate the calculated value, that way the calculations for the values are done in Power Apps, and you can replicate them as you know what the calculated fields in SharePoint are.

[CassimCoovadia]

That would work. But the problem is sharepoint runs about 50 calculations. It would need to be done for each one

[CassimCoovadia]

@iAm_ManCat 

If I leave the formula as Parent.Default the vales are shown accurately. However, they are displayed with 10 decimal places. If I try and use a formula to neaten it, it disappears.

[iAm_ManCat]

The fact that you mentioned it works with Parent.Default, means that it is likely a conversion issue.

If you return it to parent.default, then hide the label, can you insert another label that references the original label and use Round that way?

Round(Value(OriginalLabelName.Text),2)