cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AdamGill
Level 8

O365 PowerApps Web App shows all calculated Fields- Windows 10 PowerApps App does not?

My PowerApp has a lot of locally-calculated Fields (100+) with Slider selectors - it works perfectly when I play it through my Chrome Browser, from my company's O365 PowerApps Portal. Today I loaded the Windows 10 PowerApps App on my PC - and also on my Android phone: I was able to log in to my company's MSFT domain successfully on both devices and then played the same PowerApp - virtually none of the calculated Fields are displaying any content within the Windows 10 App - works on Android no problem. Is there a setting I might be missing or something? Thanks!

1 ACCEPTED SOLUTION

Accepted Solutions
AdamGill
Level 8

Re: O365 PowerApps Web App shows all calculated Fields- Windows 10 PowerApps App does not?

Thanks Paul - I don't know why I did not get a notification that you had replied. I think the experience with W10 App is "pot luck". I tried it again, today and the Slider values are updating - even though I have not made any changes.

 

However, the "Total" value is still not populating - which is strange, because it is a very, very simple formula - and it still works perfectly on the Web and Android/iOS.

 

Maybe I will advise the internal staff not to use the W10 App as it seems to have limitations.

 

Thanks again,

Adam

View solution in original post

12 REPLIES 12
KroonOfficeSol
Level 10

Re: O365 PowerApps Web App shows all calculated Fields- Windows 10 PowerApps App does not?

Maybe first try to make a new app with just one calculated field and try to load this on your device to see if this works.
AdamGill
Level 8

Re: O365 PowerApps Web App shows all calculated Fields- Windows 10 PowerApps App does not?

Thanks for the reply - not sure that would prove anything as it works on-line in 365, in works on Android - it just doesn't work on the core, designated Windows 10 App...

KroonOfficeSol
Level 10

Re: O365 PowerApps Web App shows all calculated Fields- Windows 10 PowerApps App does not?

It will tell you of it works in a new created app, gives you a small test app you could share with the community and you could try to do some testing yourself (I could think off storing the value off the slider in a variable and connect this to your label, just as a test).

Know that nobody can answer your question when you don 't say anything about how you connect your slider to the label. The question is to faque.

Maybe you could try to enable classic rendering in the advance settings off the app and set of it loads then.
AdamGill
Level 8

Re: O365 PowerApps Web App shows all calculated Fields- Windows 10 PowerApps App does not?

Thanks - I tried Classic Rendering - it did not help.

 

For more context:

 

1. At the top of the Form, I have a pre-defined SUM Numerical Field, based on multiple numerical values from within the Form layout - this does not populate on the Windows App version:

 

"$"&TextInput2_1+
TextInput2_2+
TextInput2_3+
TextInput2_4+
TextInput2_5+
TextInput2_6+
TextInput2_7+
TextInput2_8+
TextInput2_14+
TextInput2_15+
TextInput2_16+
TextInput2_17+
TextInput2_18+
TextInput2_19+
TextInput2_20+
TextInput2_21+
TextInput2_23+
TextInput2_24+
TextInput2_25+
TextInput2_27+
TextInput2_28+
TextInput2_29+
TextInput2_30+
TextInput2_31+
TextInput2_32+
TextInput2_33+
TextInput2_34+
TextInput2_35+
TextInput2_36+
TextInput2_38+
TextInput2_39+
TextInput2_40+
TextInput2_41+
TextInput2_42+
TextInput2_43+
TextInput2_44+
TextInput2_45+
TextInput2_46+
TextInput2_48+
TextInput2_49+
TextInput2_50+
TextInput2_51+
TextInput2_52+
TextInput2_53+
TextInput2_54+
TextInput2_55+
TextInput2_56+
TextInput2_57+
TextInput2_58+
TextInput2_59+
TextInput2_60+
TextInput2_61+
TextInput2_63+
TextInput2_64+
TextInput2_65+
TextInput2_66+
TextInput2_67+
TextInput2_68+
TextInput2_69+
TextInput2_70+
TextInput2_71+
TextInput2_72+
TextInput2_73+
TextInput2_74+
TextInput2_75+
TextInput2_76+
TextInput2_77+
TextInput2_78+
TextInput2_79+
TextInput2_80+
TextInput2_81+
TextInput2_82+
TextInput2_83+
TextInput2_84+
TextInput2_85+
TextInput2_86+
TextInput2_87+
TextInput2_88+
TextInput2_89+
TextInput2_90+
TextInput2_91+
TextInput2_92+
TextInput2_93+
TextInput2_94 +
TextInput2_95 +
TextInput2_96 +
TextInput2_97 +
TextInput2_98 +
TextInput2_99 +
TextInput2_100 +
TextInput2_101 +
TextInput2_102 +
TextInput2_103 +
TextInput2_104 +
TextInput2_105 &".00"

 

2. Within the Form, I have (105) Sliders which feed the TextInput Numeric Values I have explained above - they were created to take a numerical value from the Silder and display them as a currency value in the TextInput Field  - some of these show the correct values, but many show no value at all:

 

"$"&If(Slider1.Value=1,"1517",Slider1.Value=2,"2925",Slider1.Value=3,"6740",0)&".00"

 

 

KroonOfficeSol
Level 10

Re: O365 PowerApps Web App shows all calculated Fields- Windows 10 PowerApps App does not?

You can do what you do. First the boxes are text and you don't get the text by the .Text attribute. Also you want to have numbers and not text so you have to convert them by the Value() formula before you can add them together.

 

So do this:

Sum(Value(TextInput2_2.Text),Value(TextInput2_3.text),etc.)

Surround this by a text() formula like:

Text(Sum(),"[$-en-US]#.#0")

 Or do this to get the same you have, but I would take the first.

"$" & Text(Sum()) & ".00"


For the textboxes.text you do like this:

Text(
   Switch(Slider1.Value, 
           1,1517
          ,2,2925
          ,3,6740
     ), "[$-en-US]#,###.#0", "$-en-US")

And rename your boxes to a better name like V1, V2, V3, etc.

 

Hope this helps.

 

Paul

KroonOfficeSol
Level 10

Re: O365 PowerApps Web App shows all calculated Fields- Windows 10 PowerApps App does not?

@AdamGill,

 

Oh forgot to mention you should first reference one of your 'value' textboxes in another label and see if it returns indead a value. So one testlabel.text with:

Value(V1.Text) // this should return a value, else the formatting off you textbox problaly is not allowed
AdamGill
Level 8

Re: O365 PowerApps Web App shows all calculated Fields- Windows 10 PowerApps App does not?

Thanks - I will try to understand your instructions. However, all of my formula's already work - the point is that they are sometimes not displaying in the Windows 10 PowerApps App - they work/display perfectly on the web portal and on Android. I don't see how updating (105) formulas - that already work - to other formulas that probably work equally well - will make a difference.

 

But I will test a few.

 

Thanks!

AdamGill
Level 8

Re: O365 PowerApps Web App shows all calculated Fields- Windows 10 PowerApps App does not?

Thanks for looking into this for me. I could not understand your instructions - but I also think that it would not resolve my issue. As you can see on the screenshot - taken using the Windows 10 App for PowerApps - only some calculations are displayed when the Slider is in use - but most are not:

example1.png

Given they all use the exact same formula and parameters, I do not know how to fix this. Everything displays perfectly on the O365 PowerApps web Portal - and on the Android App!

 

Thanks again for your attention on this - very much appreciated!

KroonOfficeSol
Level 10

Re: O365 PowerApps Web App shows all calculated Fields- Windows 10 PowerApps App does not?

2018-10-18 16_58_26-Window.png

 

Made a small Sample app and it works fine in the Windows 10 WebApp.

 

Wonder if you did set the default, min and max for you're sliders and in the switch use all off the values?

 

Attached I put in the Sample file, so you can take a look at the formula's.

 

btw, I would move away from the W10 webapp. You can make an app like experience when using chrome. See video how to do this:
Learn PowerApps | 11 | Windows 10 Chrome browser App

 

Succes.

 

Paul

 

 

 

Helpful resources

Announcements
Better Together’ Contest Finalists Announced!

'Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Join THE global Microsoft Power Platform event series

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

thirdimage

Microsoft Business Applications Virtual Launch

Join us for the Microsoft Business Applications Virtual Launch Event on Thursday, April 2, 2020, at 8:00 AM PST.

thirdimage

Community Summit North America

Innovate, Collaborate, Grow - The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors
Users online (8,958)