web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Bug: Formula bar evalu...
Power Apps
Unanswered

Bug: Formula bar evaluates as true, logic evaluates as false

(1) ShareShare
ReportReport
Posted on by 2,914

Another of these, but one which I think shows the issue clearly and is easy to reproduce.

 

Take a look at the two images below - the display mode of the Save button should be disabled if there is no item selected in the combo, if something is selected, the button should be enabled.

Note that despite the exact same setup in the two images, the button in the first image is disabled and in the second it is enabled.

The only difference is that in the first image the Combo has recently been reset, but in the second, the Combo has had an entry selected and then removed.

In both case the formula bar is indicating the If condition returns true (although the labels beneath the button, which are based on the condition return true in the first case and false in the second).

In both cases, highlighting cboTechnician.SeletectedItems returns 'We didn't find any data' in the formula bar.

image.png

 

image.png

I suspect this is due to bugs in the way that either 'Nulls' or 'Errors' are returned for (in this case empty collections) but in some places are displayed as 'false'.

Whatever the cause it is very frustrating and resulting in much lost time trying to track down bugs in our Apps as a 'step-by-step' evaluation of each stage of a formula cannot be relied upon.

Categories:
  • GregLi Profile Picture
    Microsoft Employee on at

    Thanks for the bug report and I'm sorry that it was wasted your time.  I can reproduce the issue. 

     

    It only fails for me when the experimental error handling switch is enabled.   Turning that off is a workaround, but of course there are reasons to keep it on.  We are working on some major updates to error handling that should roll out in a few months.  

     

    Obviously the result view should agree with the formula evaluation in the app.  Result view is already somewhat error aware but apparently not enough.

     

    But your report has exposed another inconsistency: a Reset combo box returns a null (blank) table (IsBlank = true, IsEmpty = false), while a cleared combo box returns an empty table (IsBlank = false, IsEmpty = true).   

     

    Which leads to another inconsistency: First() returns an error if the table is empty, but oddly returns null if the table isn't there at all (null). 

     

    So, we have some things to discuss and rationalize.  🙂

  • PaulD1 Profile Picture
    2,914 on at

    Thanks for the swift response @GregLi - appreciate you taking this up with the team to resolve.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 397 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 354

#3
WarrenBelz Profile Picture

WarrenBelz 232 Most Valuable Professional

Last 30 days Overall leaderboard