Edit form in sharepoint without changing the date

%3CLINGO-SUB%20id%3D%22lingo-sub-2245989%22%20slang%3D%22en-US%22%3EEdit%20form%20in%20sharepoint%20without%20changing%20the%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2245989%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20list%20in%20SharePoint%20and%20I%20want%20to%20edit%20the%20form%20without%20the%20date%20being%20changed%20to%20today's%20date%20because%20I've%20set%20the%20date%20to%20today's%20date.%20But%20if%20I%20update%20the%20form%20without%20changing%20the%20date%20it%20overrides%20to%20today's%20date.%20how%20do%20I%20put%20the%20date%20to%20static%20if%20I%20editing%20the%20form.%20Thank%20you.%20I%20would%20appreciate%20it%20if%20someone%20knows%20how%20to%20solve%20this%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2245989%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2246462%22%20slang%3D%22en-US%22%3ERe%3A%20Edit%20form%20in%20sharepoint%20without%20changing%20the%20date%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2246462%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1013202%22%20target%3D%22_blank%22%3E%40Shanis_Qistina%3C%2FA%3E%26nbsp%3Byou%20can't%20do%20this%2C%20the%20Modified%20column%20will%20ALWAYS%20change%20to%20the%20current%20date%2Ftime%20when%20any%20change%20is%20made%20to%20a%20column%20in%20the%20list%20or%20library.%20It%20has%20always%20been%20that%20way.%20The%20only%20thing%20you%20can%20do%20is%20to%20add%20a%20separate%20date%2Ftime%20column%20where%20%3CU%3Eyou%3C%2FU%3E%20add%20the%20date%20you%20want.%20Then%20you%20don't%20need%20to%20display%20the%20Modified%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi, 

I have a list in SharePoint and I want to edit the form without the date being changed to today's date because I've set the date to today's date. But if I update the form without changing the date it overrides to today's date. how do I put the date to static if I editing the form. Thank you. I would appreciate it if someone knows how to solve this :)

4 Replies

@Shanis_Qistina you can't do this, the Modified column will ALWAYS change to the current date/time when any change is made to a column in the list or library. It has always been that way. The only thing you can do is to add a separate date/time column where you add the date you want. Then you don't need to display the Modified column.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

 

Thank you so much for the reply Rob. But what if I used power apps to change the query? Can it be done?
No, any change to the list, however it's done, always updates the Modified column.
I see. Thanks Rob !