Showing results for 
Search instead for 
Did you mean: 
Not applicable

Update blank/Null value to fields (Date, User, Choice field etc.) in SharePoint list / database

Scenario :  I have saved an item to the SharePoint list and later decided to remove data from some fields (Date field, User field etc).  Edit the item and delete the field value and Save it back to datasource (SharePoin list / SQL database)


Issue :  PowerApps does not update the field to empty / null value. The field value remains as such in list.


Solution : Enable the "Experimental features" as shown in below screenshot. This will resolve the issue and you will be able to update field value to null after that.


 Experimental Feature.png


Reference :

Frequent Visitor




I have changed the following in Card under Update..


"If(Value(DateValue7.SelectedDate ) = ""; "0" ;DateValue7.SelectedDate + Time(Value(HourValue7.Selected.Value); Value(MinuteValue7.Selected.Value); 0))"


Now an empty field is transferred to the database. I think this could also work for Sharepoint.


I did not find the experimental option under my settings.


Sorry for my English.


Greeting René

Super User
Super User

None of these answers worked for me and I really did not want to recreate the date columns in separate text columns.

I had to use this formula on the submit button:


SubmitForm(Form1); If(Or(IsBlankOrError(DataCardValue8.SelectedDate), IsBlankOrError(DataCardValue9.SelectedDate)), RecordsRetentionSetNullDates.Run(RecordsRetentionList.Selected.ID, IsBlank(DataCardValue8.SelectedDate), IsBlank(DataCardValue9.SelectedDate)), "");



And set up a corresponding flow to input those null values in the date fields.



Frequent Visitor

Just in case someone is dealing with this issue still, you only need to use the name of the column sharepoint assings to it, not the one powerapps reads, as an example


'Loan Equipment',
STATUS: {Value: "IN STOCK"},
'End User': "",
'User''s Manager': "",
'Date_x0020_of_x0020_Return': Blank(),
Comment: "",
Comments: "",
Correo: ""}


Powerapps finds these columns as "Date Loaned" and Date of return", you need to use the sharepoint column name, you can find it at the address bar once you are in the column settings in the list settings of your sharepoint list.


This is why it doesn't give you an empty registry in a date field in sharepoint.


I hope it helps someone 🙂

I created a Text Field in SharePoint to hold the values and use the Blank function like below


Do the same for People Picker Fields - Usually just store the email address in text field


I always try and use Text and Number fields and handle the complex data types within PowerApps controls then store simple text in SharePoint with an index that field - works well for me..  I am sure there are situations where that is not ideal... 

This is not correct. Powerapps will work with the SharePoint Display or Internal field name. One needs to be in single quotes (Display) , the other no quotes. The solution to this issue is in the original post. You have to turn on those features. One is no longer experimental as of this post (Delayed Load), the other is still experimental. Both have to be on to clear dates, and people fields. Check to see if you already have them on....

Frequent Visitor

It's been over 4 years since this issue started. Today 12/05/2022, I still cannot set a list item date field to Blank. 

Do we still have to turn the Experimental features on after all these years?

Helpful resources

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 (1,982)