Solved: Bot report mail for every row how to stop this - Page 2

jujogar10 · 09-14-2021 08:58 AM

I created a BOT, schedule event for an specifica hour every day.

If I cheched ForEachRowInTable It sends one mail for every row and I just need one report according to a template.

If I do not check ForEachRowInTable then I get the error that the Event and the task are not compatible.

Help with this

Aurelien

You need to set a “None” table to your process and event.
Untick “for each row” option in the Event.
And change your template in order to run on the whole table.

You may want to use an expression in your template like this:
<<Start:FILTER("YourTable", yourConditionExpression)>> <<[column1]>> <<[column2]>> <<End>>

If that’s not clear, please share screenshot of your bot configuration and template, that may help into guiding you on the right track.

For reference:
Section " Select Expression"

View solution in original post