web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Automate
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?

 

Categories:
I have the same question (0)
  • v-yuazh-msft Profile Picture
    on at

    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

  • rory99 Profile Picture
    28 on at

    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

    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

    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

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 522 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 364 Moderator

#3
abm abm Profile Picture

abm abm 243 Most Valuable Professional

Last 30 days Overall leaderboard