cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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

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

 

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

 

Thank you @Hitay that worked!!

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
PP Bootcamp Carousel

Global Power Platform Bootcamp

Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.

secondImage

Power Platform Community Conference On Demand

Watch Nick Doelman's session from the 2020 Power Platform Community Conference on demand!

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Top Solution Authors
Users online (11,218)