Skip to main content

Notifications

Power Automate - Building Flows
Suggested answer

How to Notify on 'Last Date' Updates Without Duplicate Emails in Power Automate / Tabular model

Like (0) ShareShare
ReportReport
Posted on 28 Jan 2025 20:20:03 by 21

Hello, and thank you kindly if you can help. โ˜ฎ๐Ÿ•ŠโœŒ

I have a Power Automate process that is working well. The process queries a tabular model, retrieves a date from a date table, and stores it in a SharePoint list. Then, a second flow checks if this date is one day behind the current date. Since the data model is always a day behind, this indicates that the system is up to date.

Hereโ€™s how it works:

  • If the date is one day behind, an email is sent to indicate that the system is up to date.
  • If it isnโ€™t one day behind, an email is sent to indicate that the system is not up to date.

This process works as intended. However, Iโ€™ve been asked to address an additional scenario, and Iโ€™m unsure how to implement the logic.

The new requirement is:
If the system is initially marked as โ€œnot up to dateโ€ but later updates within the same day (e.g., the tabular model data refreshes), Iโ€™d like to send an email indicating the system is now up to date.

Key conditions:

  1. The email should only be sent if the system transitions from โ€œnot up to dateโ€ to โ€œup to date.โ€
  2. If the system remains โ€œnot up to date,โ€ no additional emails should be sent.

Is it possible to build this kind of logic in the Power Automate flow that i already have, or too complex? If so, how would you recommend structuring it?


My 2 flows that I have currently that work well are below:

FLOW 1:



FLOW 2

  • Suggested answer
    Nived_Nambiar Profile Picture
    Nived_Nambiar 17,110 on 30 Jan 2025 at 03:10:52
    How to Notify on 'Last Date' Updates Without Duplicate Emails in Power Automate / Tabular model
    Hi,
     
    It seems to be possible.
     
    for that what you can do is create a new flow which monitor for any changes in sharepoint - like when item is modfied
     
    Then you need to check whether the date value has been changes, if yes - fetch the previous value of date when it is in previous version (we need to use sharepoint api for this), then you can do both comparision - previous version date value with current date and current version of date with current date, then see whether it is system not update to system updated.
     
     

    Thanks & Regards,
    Nived N

    Stay connected:
    LinkedIn | YouTube | Blogs

    Was this answer helpful?
    If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
    Your feedback motivates me to keep contributing. Thank you!

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

Microsoft Kickstarter Eventsโ€ฆ

Register for Microsoft Kickstarter Eventsโ€ฆ

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the dailyโ€ฆ

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improvedโ€ฆ

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard
Loading started
Loading complete