Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - General Discussion
Unanswered

Run a flow once

(0) ShareShare
ReportReport
Posted on by 28

Hi

 

I have created a flow which starts with “When items is created or modified” for a SharePoint list nad results in sending

A notification to a person which due date is past – using conditions. The flow works great but it runs over and over and as a  result the person that is overdue receives mails over and over whihout stops – until I disables the flow…

 

I would like to run this flow 1 TIME at a specific weekday and as I result send only 1 mail for the persons that their date is overdue

 

How do I accomplish that?

 

  • rory99 Profile Picture
    28 on at
    Re: Run a flow once

    Hi Alice

     

    TSorry for the late response but I do not understand this flow

    Wahich value am I suppsoed to put in the first "initialize varible" ?

     

    Thanks

  • v-yuazh-msft Profile Picture
    on at
    Re: Run a flow once

    Hi @rory99,

     

    If you use the trigger “When items is created or modified” in your flow, the flow would be triggered evert time an item is created or modified.

     

    Since you have added an "Apply to each" from all items from the list, the flow "Apply to each" would check for each item to see if the Condition is meet, if the Condition is meet for each item , the email notification would be send for each item in the list.

     

    If you just want to send only one email notification when there is an item in the list meet the Condition, you could refer to screenshot below to create the flow:

    Capture.PNG

    Capture.PNG

     

     

    Best regards,

    Alice

  • rory99 Profile Picture
    28 on at
    Re: Run a flow once

    Hi Alice 

     

    I have this flow set up:

     

     

    Capture.PNG

     

    The output from the "Add to Time" action is for exsample:

    2018-12-27T00:00:00.0000000

    Which is compared to the compose 2 action:

    formatDateTime(utcnow(),'yyyy-MM-ddT00:00:00.0000000')
     
    Then the condition is comapring the calculated time from the "Add Days" to output of Compose 2  - if ture it sends a notification - this is working well but  it send the notification over and over again and not just only when an item is created or modified...I would like it to send it only once to those people who uphold the condition and not over and over...
     
    Thanks
  • v-yuazh-msft Profile Picture
    on at
    Re: Run a flow once

    Hi @rory99,

     

    Could you please share a screenshot of the configuration of your flow?

    Could you please explain more details about your requirement?

    Do you want to run the flow only at specific weekday every week?

     

    If you want to run the  flow only at specific weekday every week, you should modify the trigger to "Recurrence", and set the frequency to every week.

     

    If you use the trigger “When items is created or modified”, the flow would be triggered evert time an item is created or modified.

     

    Please share more details so we would try to provide a proper workaround for you.

     

    Best regards,

    Alice

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Michael Gernaey – Community Spotlight

We are honored to recognize Michael Gernaey as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 566 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 516 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 492