web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Not able to blank date...
Power Apps
Answered

Not able to blank date fields once a value has been entered

(0) ShareShare
ReportReport
Posted on by 41

As per the subject title, I have a SharePoint list, imported from an excel with a series of date fields. Creating a new record with dates and viewing a record with dates works as expected. However, if I attempt to edit a row, blank a date and select 'Save', the save does not actually commit, leaving the previous value on display. The current workaround is to use the 'Edit in Grid View' option to remove the value. If I change the date to another date the save does commit successfully.

 

Any help would be much appreciated! 

Categories:
I have the same question (0)
  • Spamrancher Profile Picture
    345 on at

    Hi there. How are you displaying your SharePoint list? Is it in a gallery or a form or something else? How are you writing the data from your canvas app back to SharePoint?

  • Stokiedez Profile Picture
    41 on at

    Hey @Spamrancher. I'm displaying it just in a list as shown in the attached. Sorry, I'm a relative newbie so not sure on your second question. I created the PowerApps form originally by double-clicking one of the records then selecting 'Customize in PowerApps'. It then created a base form with a set of fields automatically which I have customised.

    Capture.PNG
  • Spamrancher Profile Picture
    345 on at

    I'm going to have to bow out on this. I'm not familiar with creating an app directly from SharePoint and I can't recreate how you got started. Hopefully someone else has that knowledge.

  • Verified answer
    RandyHayes Profile Picture
    76,299 Super User 2024 Season 1 on at

    @Stokiedez 

    Go into the Advanced Settings of your App (File->Settings->Advanced Settings) and turn on the Formula-level error management option.  You cannot write blank values to a list without this option on.

     

    I hope this is helpful for you.

     

     

  • Stokiedez Profile Picture
    41 on at

    @RandyHayes Thanks, I'll give that a go - are there any negative effects I need to be mindful of by turning this on?

  • steve_hendy Profile Picture
    388 on at

    Of course this makes sense. MS are so dumb sometimes.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 329 Most Valuable Professional

#2
11manish Profile Picture

11manish 209 Super User 2026 Season 2

#3
Mohsin Ali Profile Picture

Mohsin Ali 179

Last 30 days Overall leaderboard