Showing results for 
Search instead for 
Did you mean: 
Super User
Super User

Formula bar evaluations bug

Please see below images - when evaluating my variable conValidUntil in the formula bar, I get 'Invalid Date', but wrapping it in a Text function, there clearly is a date stored in that variable.

Minor annoyance except that I am trying to track down an issue in my App where data is not saving as expected and not being able to trust the formula bar evaluations makes this much harder than it ought to be.






Super User
Super User


I've noticed that too...usually issues with Dates.  I don't rely on it much, but when it is working it is helpful at times.

Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!

@RandyHayes thanks for the confirmation that you are seeing similar issues.

I've posted previously about bugs in the formula bar evaluator (especially in relation to logical-test results being evaluated incorrectly when Formula Level Error Management is turned on) and MS staff have said they will escalate and look into them, but clearly many months later this feature is still not reliable. I just find this frustrating as while I find it quick to build Apps in Power Apps, maintenance and tracking down bugs is a very slow and laborious process as the tools are just not there or can't be relied on.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (1,045)