Hi guys I am currently doing expanding my workflow. It sends reminders if a due date is approaching, stating how many days are left. Depending on 3 conditions,
Send emails when the column daysleft is 7,
daysleft is 3 to 0
daysleft is 0 or less.
This is my workflow. How it works is it query the list column and then, stores the results in a collection variable, then I use the for each loop to store the results in the collection into a variable. The set condition is to check whether the variable is = 7 days. If yes send the 7 days email. If no, send if variable is 3 to 0, the other is to send if >0 days.
It works perfectly, however now I want the email notifications to not be sent if the column, Issue Status is changed to Closed or Open. It will send if its in Progress. I think that I have to use Query List to obtain the text and store it in a collection variable, then use each loop, but I don't know how to do it.