Answered

how to patch created date and modified date

(0) Share

Report

Posted on by clare-sy

hi all,

I am using excel (onedrive for business) as my data source , and I want to record each item's created time and if it has been changed, also record its modified time ;

I use the patch function when the Editform1 's onsucess, here is my code:

If( EditForm1.Mode = FormMode.New, Patch(datasource,EditForm1.LastSubmit,{createdwhen: Now()}),
Patch(datesource,EditForm1.LastSubmit,{'modified when': Now()}))

but when i actually create a new record ,I hope the time is put in the createdwhen column, but it goes to the modified when column. I have tried several times , the results goes the same.

I think maybe the reason is because: once the editform1 has been submitted, its formmode has been changed to edit (not new) ?

I dont know and hope you guys can kindly help me, Thank you !

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Verified answer

mdevaney 29,991 Moderator on at

Like (1)

Report
Copy link

Link copied!
@clare-sy

Your theory is correct. Once the Form is submitted its no longer in New Mode. Put this code in the OnSuccess property of the Form instead. If the createdwhen column is blank, its a new record. If createdwhen is filled, then we are editing.

If( EditForm1.LastSubmit.createdwhen=Blank(), Patch(datasource,EditForm1.LastSubmit,{createdwhen: Now()}), Patch(datesource,EditForm1.LastSubmit,{'modified when': Now()}) )

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
clare-sy 35 on at

Like (0)

Report
Copy link

Link copied!

Your answer perfectly solves my question, thank you!
BTW, I am wondering if the editform1 has been submitted , what is its form mode? As far as I know, there is only 3 kinds status: view/edit/new.
Thank you！

Was this reply helpful? Yes No
clare-sy 35 on at

Like (0)

Report
Copy link

Link copied!

Your answer perfectly solves my question, thank you! BTW, I am wondering if the editform1 has been submitted , what is its form mode? As far as I know, there is only 3 kinds status: view/edit/new. Thank you！

Was this reply helpful? Yes No
mdevaney 29,991 Moderator on at

Like (0)

Report
Copy link

Link copied!

@clare-sy
If a form was submitted in New Mode it will be returned to Edit Mode upon successfully submitting.

Power Apps Documentation for Form Mode

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-form

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Was this reply helpful? Yes No
tasnimMo 2 on at

Like (0)

Report
Copy link

Link copied!

and if I you wanna update the modified by column how u do it ?

Was this reply helpful? Yes No