SharePoint new item with different Created and Modified

(0) Share

Report

Posted on by SkiDK

1,016

Hi everyone,

I have SharePoint list where I use a PowerApps form to create or update items in the list. When I create a new item, a Power Automate flow will be triggered. In that flow is being checked whether the item is new or modified, by doing next:

Now I have noticed that when a new item is created, many times it counts as modified, and not as new because Created and Modified have a difference of a few seconds.

Example when a new item was created, I received next timestamps:

Created: 2020-10-06T20:51:54Z

Modified: 2020-10-06T20:51:59Z

-> Difference: 5 seconds

It should be the same. Someone knows why this is, or how to fix this? Can it have anything to do with the PowerApps form I use in SharePoint?

Help is very much appreciated. Thanks,

Ski

I have the same question (0)

All responses (4)

Answers (2)

Mira Ghaly 11,413 Moderator on at

Like (1)

Report

Re: SharePoint new item with different Created and Modified

@SkiDK
This comparison will not work you need to compare using the below expression instead
formatdatetime(createdon,'dd/MM/yyyy') is equal to formatdatetime(modifiedon,'dd/MM/yyyy')

Was this reply helpful? Yes No
Verified answer

SkiDK 1,016 on at

Like (0)

Report
Re: SharePoint new item with different Created and Modified

Hi @Mira_Ghaly
Thanks for your reply. In this case though, wouldn't I compare the days with each other? That window is a bit too wide. It can happen that someone wants to edit the item right after it was created.

I have a temporary solution now, where I convert both dates to Ticks which I substract to get the difference and divide it by 10000000 to get the difference in seconds. If it is lower than 10 seconds, I count it as New, if higher as Update.
(ticks(Created) - ticks(Modified)) / 10000000 < 10

But I don't want to mark it as solution yet, because it's rather a workaround than the solution. I really would like to know why this occurs.

Was this reply helpful? Yes No
Verified answer

Mira Ghaly 11,413 Moderator on at

Like (1)

Report

Re: SharePoint new item with different Created and Modified

@SkiDK
This solution you have suggested will work and makes sense.

Was this reply helpful? Yes No
mikeInTheCommun 13 on at

Like (0)

Report

Re: SharePoint new item with different Created and Modified

It is likely (if these times are a few seconds off) that you are creating the item via a Power App and you are patching some field (like a concatenation of the item ID with some other information like FY) right after the item is created.
If that is the case, you should run a flow only on item or file is modified, and use this check to see if the field you are concerned with has been changed (in my case, the FYID field):

Was this reply helpful? Yes No