I have created a report that sends an email at 8:00 in the morning of a task assigned to that person that is due on that day. As it stands right now if there are 10 tasks someone must do that day they will receive 10 different emails. How can I send all records in one email? I’m sure it has something to do with a start/end formula but I haven’t been able to figure out how to use it. I would love is someone could just tell me exactly how it should look. below is the body template for the email:
For doing that you would need to trigger the scheduled report from Users table. Then you could use the Start & End expression if you use the option “ForEachRowInTable”. Then the formula would be like…
<<Start: SELECT(Tasks[KeyColumn],[Assigned]=[_THISROW].[User])>>
Thank you @Aleksi . While testing things out last night I instead created a report for a Slice Past Due and chose “for Entire table”. My formula looks like this:
The problem is, it is sending a report even if there is nothing in the table. How can I make sure the report is only run when the Slice has something inside it? Thank you again.
I started off with a each row in table format first, then used a select formula (I don’t have a .user column) and the start formula worked but I still received an email for each row in the table (containing the multiple items from the start expression)…I am trying to avoid receiving multiple emails a day, but only receive 1 email with all task past due for an assignee. Please help me figure this out, as I am a teacher and my summer is running out for me to complete this app. I have been playing with count() options all day and I don’t think I understand them.
Put this expression in the event condition. Count(FILTER(“slice name”,[column name] > 0)) <> 0, or Count(FILTER(“Slice name”,ISNOTBLANK([Column name]))) <> 0