Scheduled Bot to Run Weekly and Send an Email for Each Row

[googlenoob62]

Trying to build a bot that is setup to run on a weekly schedule and should send an email for each row that matches the filtering condition. Running into issues when trying to set it up and when it does run it sends one email instead of an email for each row that matches the information. In the example below it should be sending two emails.

DB 

 Event

• IN(Table 1[Status], LIST('Complete')) = True

Process

• Filter Records (Branch on a Condition) 
  • Condition: IN(Table 1[Status], LIST('Complete'))

• Send Email

[jballester]

Hi, 

I think this definition can be helpful.

Send email when a row is updated to have a specific column value
Examples of sending an email from an automation

For future scenarios, when the table is updated, I think this example is good too
Send Email Through Workflow Only One Time 

[googlenoob62]

Those examples are only for triggers when an action occurs on a specific row. I need this to run on a schedule and send an email for each record that matches the filter criteria not when an action occurs. 

I created a slice instead of having to fight with the filtering for the Event to look like this:

 The Process looks like this now:

 When running this it is still sending one email with all the records names in the title and body instead it should be sending two separate emails with each customer name in the title and body

[jballester]

in conditions filter it wouldn't be easier

[Status]="Complete"

or

CONTAINS([Status], "Complete")

[Markus_Malessa · Accepted solution]

Your filter should just be

[Status] = "Complete"

Your email subject and email body should just be

<<[Customer]>>

Seems like the branch condition is redundant and should probably get eliminated.