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
Solved! Go to Solution.
Hi @jujogar10
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"
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |