Email Notification status column and date column

[Whaley83]

Hi,

Hope someone can help. I am trying to create a flow for email notification with multiple conditions. The outcome would be an email will be sent out to responsible person based on Status column and target date column. If the status column is not closed(Open, Submitted, Working, etc) and it is already equal to or pass Target date, an email will be sent out reminding the person of the action item.

I have created a flow but it sent an email to all even if the item was already closed or far from the target date.

Thank you in advance for any suggestion.

[David_MA]

Can you show your flow and how you have the actions configured? One of the conditions is probably not configured correctly. If you have a choice column that you are using in a condition, be sure to use the value option in the dynamic content. For example, if you have a column named Status, there will also be one named Status Value in the dynamic content. You would want to use that in your condition.

[Whaley83]

Hi David,

I was able to figure out for the other flow I have except for this flow below. This flow is for those item that past target date for more than 30 days and is still not in closed status. Unfortunately, it sends email to all responsible person regardless of the status. It only recognize the date.

This is my flow.

For Get past time 6

For substring 6

For Get items status Open:

For Get Items Status Working:

For Get Items Status Submitted:

For Get Items 14:

Then Apply to each is just send an email.

I have change the Get items 14 to le, ge, gt and lt but still does not recognize the status. 

Appreciate any help/advise.

Thanks,

William