cancel
Showing results for 
Search instead for 
Did you mean: 

Function to produce blank value

Need to have a function, something like, Blank() to produce blank value.

Status: Completed

We've had a Blank() function for quite some time.  The ability to write blank/null values to databases was added with the experimental error handling feature which we will be turning on by default soon.  If there is anything more here that we haven't covered, please let me know.

Comments
Frequent Visitor

I have the same kind of situation. I need to set a value to null and still no way to do so even if the issue was reported a year ago.

 

Clearly not acceptable for such a basic feature.

 

Using the Blank() function doesn't even work because in the PowerApps way of thinking, a null value is not to be updated and is therefore skipped by the patch function.

 

My workaround so far is to create, when possible, a flow running a single SQL query to update the field to the correct value.

 

That kind of issues are really frustrating and are ruining my experience with the tool so far.

Regular Visitor

I would like to have a datepicker field blank on my edit form so the user doesn't inadvertently skip adding an actual date. Any idea when this might be possible?

Power Apps
Status changed to: Completed

We've had a Blank() function for quite some time.  The ability to write blank/null values to databases was added with the experimental error handling feature which we will be turning on by default soon.  If there is anything more here that we haven't covered, please let me know.