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 Platform Community / Forums / Power Automate / Power Automate Alerts ...
Power Automate
Unanswered

Power Automate Alerts from a SQL Database

(0) ShareShare
ReportReport
Posted on by 78

Hi there, 
Goal: I have various items related to an expiry date. I would like to send an email notification/alert evertime the expiry date in this case DEAL_END is within a month of current date from expiring. For example, in below screen shot the DEAL_END date is 23/04/3022. Thus if the flow runs it should send a notifcation that the deal wil expire in a month from now. 

 

Data entry: Via a Power App to a SQL DB.

Below screenshot with a extract of the data in the view I've written,:

Orvyn_0-1648039595747.png

 

And the current flow I am working on:

Orvyn_1-1648039631592.png

 

 

I keep running into a problem with the condition, I think it might have to do with the expression 

subtractFromTime(triggerBody()?['DEAL_END'],-30). 

Anyone done a similar flow before? 

Kindest Regards

 



Categories:
I have the same question (0)

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 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard