Answered

Date Changing When editing PowerApp

(0) Share

Report

Posted on by richard_k

Hello,

I created my first PowerApp to be used to allow my department to input some data that goes to a SharePoint list. In this PA I have a date field that autogenerates the date for 30 days past today's date.

default date for this datacard is set to

DateAdd(Now(),31,TimeUnit.Days)

This works great on creation but when editing from inside the PA the date goes 30 days ahead of the day of edit. Meaning if I created the record on 5/1 that date would be 6/1, great! But if I edit on 5/7 the date would change to 6/7, not great. I understand that it is because the formula I am using for the default date. But I am not sure what I could use to make it work better. An IF statement I imagine but I am a noob to this stuff. 🙂

My goal is when created to have the date field go to 30 days ahead BUT when editing the date does not change.

I hope this makes sense,

Thanks

Rich

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

Rajkumar_M 3,747 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @richard_k

In the DefaultDate property of the date picker control (or the Default property of the data card), use the following formula:

If(
YourFormName.Mode = FormMode.New,
DateAdd(Today(), 30, TimeUnit.Days),
Parent.Default
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.
richard_k 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the quick response. I added your suggestion and while it does retain the original date on editing in the PA when I do a "New" entry the date is 12/31/2001 instead of 6/24/24

I edited DefaultDate to
If(
DataCardValue5.DisplayMode = FormMode.New,
DateAdd(Today(), 30, TimeUnit.Days),
Parent.Default
)
Rajkumar_M 3,747 Moderator on at

Like
a
(1)

Report
Copy link

Link copied!
Make sure you are using the form's Mode property, not the DisplayMode of a control.

Use FormMode.New and FormMode.Edit to determine whether you are creating a new record or editing an existing one.

If(
YourFormName.Mode = FormMode.New,
DateAdd(Today(), 30, TimeUnit.Days),
Parent.Default
)

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.
richard_k 16 on at

Like
a
(0)

Report
Copy link

Link copied!

Ah, I thought I had to use the datacardvalue and ".mode" was not an option on displaymode. 🙂

That seems to have done it when I used my form name instead. Thank you!