cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Mer-Petti
Helper I
Helper I

SharePoint Power App List - Date value doesn't update when "BLANK"ed

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

 

MerPetti_0-1646158762499.png

 

How do I get this field to accept "Blank" as a value and update the list?

 

1 ACCEPTED SOLUTION

Accepted Solutions
RandyHayes
Super User
Super User

@Mer-Petti 

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.

_____________________________________________________________________________________
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.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

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

View solution in original post

3 REPLIES 3
RandyHayes
Super User
Super User

@Mer-Petti 

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.

_____________________________________________________________________________________
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.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

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

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"

MerPetti_1-1646170117919.png

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: 

MerPetti_2-1646170356037.png

The error doesn't show at all. How do I eliminate that?

RandyHayes
Super User
Super User

@Mer-Petti 

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.

_____________________________________________________________________________________
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.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

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

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (4,209)