
Dear all,
I am attempting to build a workflow based on a SP list that sends an email to the project manager 30 days before the contract of one of his staff expires. I am able to achieve that with the flow below.
Now, I have a "contract type" column in the list, which is a look up column from another list. I would like to send the reminder email for all the categories except for Hourly Contract and MEDICAL ESCORT, so if a contract is set as "hourly contract", nothing happens 30 days before its expiration.
Could you please let me know what am I doing wrong?
thanks 🙂

![]()