cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Flow: Existing item is modified triggers when a new item is created in Sharepoint list

 

How do I resolve this?

 

I have two flows and both are being triggered when a new item is created. Flow issue.png

33 REPLIES 33
Highlighted

hello

 

@Alamsince the initial post was written some things have changed from Microsoft Flow.

I did follow what is written at the post like in the picture below

 

 

Flow condition.png

 

 i have two flows:

  • one for the new items with name "TEST - NEW"
  • one for the edited items with name "TEST - EDIT"

 

my problem is that when I create a new item then it also kicks in the Edit flow with name "TEST-EDIT".

 

any idea of what I am doing wrong?

 

thank you

 

Highlighted

Hi @kouliscon 

 

that trigger does not work properly, because Created and Modified date are Always different by a few seconds. 

I can recommend to you to Format those Dates, so you only have date, Hours and minutes left, no seconds. 

After that you can compare Created and Modified date. Like this:

 

image.png

 

Here are the formulas:

 

Compose : 

formatDateTime(triggerBody()?['Created'],'dd/MM/yyyyTHH:mm')
 
Compose 2:
formatDateTime(triggerBody()?['Modified'],'dd/MM/yyyyTHH:mm')
 
Write these formulas into the Expression section, not directly into the Inputs field.
 
Best,
Hilal

 

Highlighted

Thank you @Hitay that worked!!

Highlighted

There's an easier way to get ONLY WHEN MODIFIED.

 

Select the trigger: When an item is created or modified.

Click on the ...

Click Settings

jonathanmweaver_0-1595535298688.png

 

Scroll down to Trigger Conditions

Click + Add

Enter this: @not(equals(triggerBody()?['Created'],triggerBody()?['Modified']))

Click Done

jonathanmweaver_1-1595535642984.png

 

I hope this helps somebody at some point in the future. 🙂

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Users online (11,289)