Default date is overriding saved value in edit form

(0) Share

Report

Posted on by lesotho_kid

106

Hello,

We are using PowerApps to create data entry screens for a SQL Server database.

One of our fields in the db is a date field. I want this field to default to today - which works by setting Default = Today().

The problem is, if I have an actual value in the db (field name is RecordDate) - this default value overrides the actual db value.

How can I only set the default value to Today() if there is not already an existing value? Basically, any time user is adding a record the first time only.

Appreciate any assistance you can provide,

Dan

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

WarrenBelz 153,034 Most Valuable Professional on at

Like (3)

Report
Hi @lesotho_kid ,
In the DatePicker DefaultDate (I assume that is what you are using, try this)
If( Value(YourDatePickerName.SelectedDate)=0, Today(), Parent.Default )
or (probably safer) if you only want to set it on new records
If( YourFormName.Mode=FormMode.New, Today(), Parent.Default )

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
lesotho_kid 106 on at

Like (0)

Report

Thanks @WarrenBelz - that worked perfectly! Appreciate your help

Was this reply helpful? Yes No