In my Power App I have an data attribute called "Actual End Date" that has a value in it. This date is erroneous for a particular record and I want to remove that value. So I open the Power App and remove the date for that field, effectively making it's value blank. It doesn't throw any error but does not update the field to be "Blank" and persists the old date on Save.
The properties for this field are set to Update = DataCardValue11.SelectedDate
How do I get this field to accept "Blank" as a value and update the list?
Solved! Go to Solution.
Turn the Formula-level error management feature on in your app settings. Otherwise you cannot write blank values.
I hope this is helpful for you.
Turn the Formula-level error management feature on in your app settings. Otherwise you cannot write blank values.
I hope this is helpful for you.
The Formula-level error management feature is listed as Experimental but I have done as instructed. I am able to omit the date from the Power App Form. However, that caused another problem. It generates an error message at the top of the form when that field is "Blank"
And I do not want my end user seeing this errors in the form because they can't do anything with it.
Also when I look with the error check in the application it doesn't show any errors related to dates:
The error doesn't show at all. How do I eliminate that?
The feature is listed as experimental and has been no for over 2 years. It's pretty much a feature at this point...and it is the ONLY way to blank a column.
The good news is that it exposes other "sins" in your app. This is what you are seeing. Somewhere you have a Value(<someText>) function that is most likely getting a blank for the text.
This should be changed to: IfError(Value(<someText>), 0)
That will remove the error produced.
User | Count |
---|---|
119 | |
86 | |
83 | |
74 | |
69 |
User | Count |
---|---|
215 | |
179 | |
140 | |
108 | |
83 |