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

Control's Default and Actual Result are not Equal

 

I have a slider control (SldB) with the formula below in the SldB.Default property.  When I cut-and-paste the formula into a label, the result is 51, which is the correct value. Yet for some reason, SldB.Value equals 0. I have this same formula for four other sliders and they are working fine.

 

 

If(
   ChkB.Value=false,0,
    If(VarSldB<>0,VarSldB,
        If(LookUp(CollUOM,UOMConcat=DrpUOM.Selected.Value,Measure)="Weight",
            LookUp(CollAdditives,PtAandAdd=Concatenate(LookUp(CollPtAPrd,Product=CmbItmA.Selected.Product,Family),CmbItmB.Selected.Result),WtMixRec)*100,
            LookUp(CollAdditives,PtAandAdd=Concatenate(LookUp(CollPtAPrd,Product=CmbItmA.Selected.Product,Family),CmbItmB.Selected.Result),VolMixRec)*100
            )
        )
)
1 ACCEPTED SOLUTION

Accepted Solutions
AGS94
Level 8

Re: Control's Default and Actual Result are not Equal

 

Closing this. No idea why the issue initially occured, but once I closed and went back in, everything was fine.

 

FWIW, the datasource is Excel on OneDrive.

View solution in original post

1 REPLY 1
AGS94
Level 8

Re: Control's Default and Actual Result are not Equal

 

Closing this. No idea why the issue initially occured, but once I closed and went back in, everything was fine.

 

FWIW, the datasource is Excel on OneDrive.

View solution in original post

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

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

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,744)