That was going to be my next question - what are the app settings and do any impact this.
Great sleuth work!!
As you discovered, enabling the "Formula-level error management" Experimental feature was the fix - for all my column types.
As this is an experimental setting, I really hope PowerApps makes this a core feature in the future. A little unsettling seeing the disclosure that this feature could break or be removed at anytime. I would hate to lose this functionality. But for now, I will take it as a win.
@gh1 You're most welcome - happy to help!
I share your concerns about relying on an experimental feature for this capability. That concern motivated me to pindown what can and can't be done without it. Part of my writeup was accepted as solution here - https://powerusers.microsoft.com/t5/General-Discussion/Clear-DateField-and-Lookup-Column-value/m-p/2... - and I plan to rework my posts in related threads in the coming days so that each thread has all of the information in a single message for reference.
All that to say, if the functionality were to be lost for any reason, we should expect to be able to fall back to the workaround. It may be more complex, but it isn't bending the platform to accomplish these updates. Fingers crossed!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand