How to clear a date field using patch on a CDS record?

(0) Share

Report

Posted on by KoJaPD

599

Dear,
I can set a datefield to the current datetime with:

Patch(MyTable, LookUp(MyTable, MyTableID=ThisItem.ID), {MyDateField: Now()})

But now I also want to be able to clear that field...

I have tried:

Patch(MyTable, LookUp(MyTable, MyTableID=ThisItem.ID), {MyDateField: Date(Blank(),Blank(),Blank())})

Patch(MyTable, LookUp(MyTable, MyTableID=ThisItem.ID), {MyDateField: Blank()})

But that doesn't work (it is executed without errors, but the date field of the record is not cleared)?

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

timl 36,634 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi @KoenJanssensPD

To patch a blank/null date, it's necessary to enable the "formula-level error management" setting. Once you enable that and reload your app, you should be able to patch the value Blank() to your date field.

Was this reply helpful? Yes No
KoJaPD 599 on at

Like (0)

Report
Copy link

Link copied!

@timl sorry, I should have mentioned that I have already enabled that...

Was this reply helpful? Yes No
Verified answer

timl 36,634 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

That's strange - I just tested it and it works for me. I assume that you did reload the app in the designer after applying the setting, in order for it to take effect?

Was this reply helpful? Yes No
KoJaPD 599 on at

Like (0)

Report
Copy link

Link copied!

OMG... 🙊
(why don't they have a notification to reload it after changing these settings...?)

Was this reply helpful? Yes No
timl 36,634 Super User 2025 Season 2 on at

Like (1)

Report
Copy link

Link copied!

Hi @KoenJanssensPD

I agree - unless you're very familiar with how settings work, it isn't obvious that you need to reload the app. I've added a post in the ideas forum here to suggest that they improve this, and to help prevent other app builders from experiencing the same problem.

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Apply-app-setting-changes-without-requiring-the-user-to-reload/idi-p/950426#M33825

Was this reply helpful? Yes No
mneff 2 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for this. I wrestled half a day trying to patch a date with blanks, no error, just no result. How is anyone supposed to figure something like this out if not for the wisdom of folks like you? Microsoft and Copilot absolutely worthless with anything I asked them about this.

Was this reply helpful? Yes No