Send an email to list items that fit a condition

Hi @Andy.Emery 

From your screenshot, everything seems to be in order. 

1. Is there any condition set in the “Query a List” action?
   How many items are returned?
2. Is the variable “Number of days since last updated” coming from the “Find Interval btw dates”
3. Is there only 1 email address from the List column?
4. Perhaps you could add the “Item ID” and “Workflow Instance ID” to the email.
   Item ID → to verify no other items meet the condition (> 3 days)
   Workflow Instance ID → to verify no other instances (this is most unlikely)

PM me the export key for your workflow

Hi @Garrett 

I actually just fixed it.  I moved the run if true and send an email outside of the loop as per below and that was as simple as that, it now only emails me if the date is older than 3 days.

It seems to work ok for now but will test with more data shortly

Thanks for your response

Hi @Andy.Emery 

1. The “Run if True” will only run Zero or One time.
   If the last item fits the condition (> 3), then it runs ones.
   Else if the last item doesn’t fit the condition, then it doesn’t run
   I’m guessing that the last item fits the condition

You can verify this when you have 2 items which fits the condition

@Garrett  ah yes you are correct, just tested it with another row that had a date greater than 3 days and it only did it for the last row

@Andy.Emery 

The Run-If block has to be inside the Loop for Each block.

Also in your Query a List action, did you set any conditions?

Hi @Garrett 

Yes I have moved it back now, but still struggling.  No I have not set any conditions yet.  Im going to have a play with it now to see if I can work it out

Hi Ya, sorry its still only sending an email for the first item, I have checked and the actual data has 2 items that meet the condition as oer below

Its like its only looking at the first item.  I have added the log instance details and count items in list to help me troubleshoot, and it counts 4 items which is correct but it only captures the first company name? I would expect it to bring back all company names no?

Hi @Andy.Emery 

Here is my sample table

Here is the workflow

Result of Final Log

Pls check your PM for export of the Workflow