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

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Sending an email ONCE ...
Power Automate
Unanswered

Sending an email ONCE if two values of sharepoint are compared after trigger "when an existing item is modified"

(0) ShareShare
ReportReport
Posted on by 8

Hello guys,

my problem is that I need a flow which can send me an email only once if the item is modified in the sharepoint list.

 

As Example: I have two columns with numeric values. the names are "stored" and "reorder level".

 

If the number  of "stored" is getting less then the "reorder level" my flow can send an email as i wished.

my biggest problem is that the flow is sending me again an email after a second change of the item.

I only want it to run one time after getting less then the reorder level.

If the "stored" value of the item is getting modified bigger then the "reorder level" and getting less than the reorder level after a new change it can send once more the email.

 

I hope I could express my problem and hope to find a solution for this problem.

Thank you in advance 🙂

Categories:
I have the same question (0)
  • paleicester Profile Picture
    33 on at

    Create a boolean column, say 'notified', default to False. 
    Then perhaps this psuedo code helps:

    Trigger when item modified 
    If notified == False and stored < reorder level
         Send email - "stock level low"

         notified = True 
    ElIf notified == True and stored > reorder level
        Send email - "stock level restored"   (not in your requirements but may be useful)

        notified = False

  • Nived_Nambiar Profile Picture
    18,136 Super User 2026 Season 1 on at

    Hi @karaYusuf 

     

    bit confused by below statement 

    If the "stored" value of the item is getting modified bigger then the "reorder level" and getting less than the reorder level after a new change it can send once more the email.

     

    So you want the flow to send an email once more?

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • karaYusuf Profile Picture
    8 on at

    Thats exactly the logic I needed. 

    I already tried something like initialize variable and set it true and false in power automate, but I m sure that I did it wrong. I m an amateur in power automate so I just do not know how to implement something like this.

  • karaYusuf Profile Picture
    8 on at

    Yes, I need something like the logic in message 2 from paleicester implemented in power automate.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 58

#2
David_MA Profile Picture

David_MA 53 Super User 2026 Season 1

#3
Expiscornovus Profile Picture

Expiscornovus 36 Most Valuable Professional

Last 30 days Overall leaderboard