Formula for date/time when value is updated/inserted in sharepoint.

Like (0) Share

Report

Posted on 18 Nov 2021 17:35:22 by Community Power Pla...

Hello,

I am trying to figure out a formula to getting a timestamp when a row is updated/inserted.

I have it currently triggered by a column total if it updates; however, I forgot that there will be times were values may change and the total might stay the same and if that's the case then the date wont be able to update due to the total value not changing.

Also, when the date value is populated, it is giving me wrong dates such as "1/20/1900 12:00 AM"

Thanks,

Jvang

Categories:

General Questions

test.PNG

TestLabPA.PNG

test3.PNG

All responses (6)

Answers (1)

Community Power Pla... on 18 Nov 2021 at 19:35:55

Like (0)

Report

Re: Formula for date/time when value is updated/inserted in sharepoint.

@StalinPonnusamy,

Oh I see, thank you so much. Very much appreciated.

Thanks,

Jvang

test.PNG
StalinPonnusamy Super User 2024 Season 1 on 18 Nov 2021 at 19:23:10

Like (1)

Report

Re: Formula for date/time when value is updated/inserted in sharepoint.

I assume you are talking about Sharepoint customized form. If yes then we have a "Modified" column
Community Power Pla... on 18 Nov 2021 at 19:16:06

Like (0)

Report

Re: Formula for date/time when value is updated/inserted in sharepoint.

@StalinPonnusamy,

My apologies for the confusion, would that option be possible in sharepoint.
I haven't put the data in a powerapps yet, I'm trying to get the columns to function correctly before I put it into an app form for inventory.

Thanks,

Jvang
Verified answer

StalinPonnusamy Super User 2024 Season 1 on 18 Nov 2021 at 19:08:34

Like (1)

Report
Re: Formula for date/time when value is updated/inserted in sharepoint.

Hi @Anonymous

Looking at your screenshot, you have a "Modified" column before "Modified By". To add this field to the form

Select the Form
Click Edit on the right panel
Click "Add field"
Select/search modified

Since this is a system field, user can't be updated
Community Power Pla... on 18 Nov 2021 at 18:59:36

Like (0)

Report

Re: Formula for date/time when value is updated/inserted in sharepoint.

Hello @StalinPonnusamy,
I looked at that in the edit view but didn't see one with a date/time column, so I tried creating one.
Maybe it's just could be me and I am missing it.

Thanks,

Jvang

test.PNG
StalinPonnusamy Super User 2024 Season 1 on 18 Nov 2021 at 18:27:04

Like (0)

Report
Re: Formula for date/time when value is updated/inserted in sharepoint.

Hi @Anonymous

My simple thought. SharePoint already has a field called "Modified". Any reason why you are not using it?

Created
Modified
Created By
Modified By

Thanks,
Stalin - Learn To Illuminate