Share
Report
2Hello, I am trying to create a flow that triggers when a value in the ‘Project Status’ column is anything but ‘Completed’ and the value in the ‘Due Date’ column is later than today’s date (i.e: is overdue). The date format in the ‘Due Date’ column is ‘dd/MM/yyyy’. And then from this I want an email to be sent to me with this information.
I have tried:
@triggerBody['RAID Status'] != 'Completed' && new Date(triggerBody['Due Date'].replace('-', '/')) > new Date()
@Anonymous(equals(triggerBody()?['RAID Status'], 'Completed’)), greater(formatDateTime(triggerBody()?['Due Date'], 'yyyy-MM-dd'), formatDateTime(utcNow(), 'yyyy-MM-dd'))
These are invalid expressions though and I’m not sure how to create a valid expression. If anyone can advise me on what to do that would be helpful. And once the valid expression is there I'm assuming I create an action for send an email with Outlook and then add the column names in the body of the email from the selector tool. Thank you
All responses (
Answers (
