cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

If Statement evaluates to '0' when in form mode [1], but works in modes [0,2]

Hi All

I have an IF statement to estimate the value of a hotel booing, so the end user doesn't have to do it.

"If hotel name this, then corp rate * duration = £Gross"

It's nested in another IF (if form mode new do this, else get parent.dafult - see attached screenshot)

But it's not working as expected

 

If I isolate just this part of the formula, it returns the correct amount when the form mode 0 or 2
But returns '0' when in form mode 1?

 

If(ComboBox1.Selected.Result = "Jurys Inn",Duration*84,
If(ComboBox1.Selected.Result = "Future Inns",Duration*80,
If(ComboBox1.Selected.Result = "The Inn at Woodhall Spa",Duration*81))),

Why would form mode [1] stop the formula from evaluating correctly?

 

Thanks all
Vicky

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: If Statement evaluates to '0' when in form mode [1], but works in modes [0,2]

Very weird, but when I transfered those IF statements to a new label they worked fine

So my formula now reads
"If hotel name this, then 'label8' * duration = £Gross"

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Re: If Statement evaluates to '0' when in form mode [1], but works in modes [0,2]

Very weird, but when I transfered those IF statements to a new label they worked fine

So my formula now reads
"If hotel name this, then 'label8' * duration = £Gross"

View solution in original post

Helpful resources

Announcements
thirdimage

Power Apps Super User Class of 2020

Check it out!

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

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (5,748)