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

 

Hitay
Frequent Visitor

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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Users online (30,327)