Power Platform Community Forum Thread Details

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

Categories:

Building Power Apps

Community site session details

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

Helpful resources

News and Announcements

Quick Links

Season of Sharing Community Challenge Winners!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to the June Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates