Answered

How to differentiate created and modified trigger in MS Flow?

(0) Share

Report

Posted on by samtim

Hi All,

As everyone suggested, I check 'Created' eq 'Modified' to differentiate created and modified trigger, it is working only if the SP list item does not have an attachment. When the user adds an attachment to the list during item creation, created and modified time is not the same. 1-sec difference occurred Created:2020-08-05T22:43:45Z and Modified: 2020-08-05T22:43:46Z. Thoroughly checked many times. Now, How to differentiate created and modified trigger in MS Flow when there is an attachment in the SP list.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

Hi @samtim

You need to enable the version settings of your list.

Next in your flow you can get the version number to determine whether it create or modify. For create version number is 1.0

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report
Hi @samtim ,

You could check the if created is greater than the modified-10 second, if yes, that means the item is new created, if not, it means the item is modified.

addSeconds(items('Apply_to_each')?['Modified'],10)

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
samtim 8 on at

Like (0)

Report

HI @abm , Thanks for the response. It didnt work because version no become 2 when flow triggered first time

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi @samtim

That's because the attachment treats as a modified operation.

Could of options.

1. Treat version 2 as create but then you must always have an attachment when it creates the list record.

2. Check for version 1 then it's always create. so in this case no attachments.

3. Add few more seconds to created time and compare if its less than 10 seconds or so then create.

Thanks

Was this reply helpful? Yes No
v-alzhan-msft on at

Like (0)

Report

Hi @samtim ,

Have you take a try with my solution?

Best Regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No
MWAN001 23 on at

Like (0)

Report

Alice, it seems to work.
Pls help with two questions:

1. Why if created is greater than the modified-10 second, that means the item is new created?
2. addSeconds should be -10, instead of 10?

Was this reply helpful? Yes No