Answered

Default date is Today() if new form else is ThisItem.Date

(1) Share

Report

Posted on by Amber_L

181

I have a sharepoint list and have created a powerapp with this list. One of the items in the form is a date. I did have the default for the date set as Today(). However, I have come across the issue where when a user edits the item, the date in the form is still todays date even if the date may be different in the original item. As an example, the image to the left shows the details of on of the items, notice the date is 18/09/19. When I press the edit button at the top, it opens the screen on the right hand side and that date has changed to the default value which is todays date. Then if I save the item, it changes the date. Is there a way to set the default to only be Today() if it is a new form but if it is an edit then it is ThisItem.DateofInteraction.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like
a
(4)

Report
Copy link

Link copied!
@Amber_L
Yes, there is a way. To show Today's date if the form is new mode and the saved date when the form is in edit mode put this code in the Default property of your DataCard for DateOfInteraction

If(your_form_name.Mode=New,Today(),ThisItem.DateOfInteraction);

---
Please click "Accept as Solution" if my response helped to solve your issue so that others may find it more quickly. If your thought the post was helpful please give it a "Thumbs Up."

Was this reply helpful? Yes No
Amber_L 181 on at

Like
a
(0)

Report
Copy link

Link copied!

That works perfect! Thank you

Was this reply helpful? Yes No
AraMS 3 on at

Like
a
(0)

Report
Copy link

Link copied!
This post was very helpful. I tried using the solution provided, however, there may have been an update and the logical test is no longer working with the current version of Power Apps. Instead, I used this:
If(your_form_name.Mode=FormMode.New,Today(),ThisItem.your_field_name)

Was this reply helpful? Yes No