
Announcements
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,:
And the current flow I am working on:
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