Using Start Expressions with a Condition?

airind
New Member

I am doing an email template a scheduled event that runs daily.
I want to return a list of people who were added that day. It’s an absenteeism app, for reference, and I want to include a list of people who called in sick for a specific team.

Using the List function, I am able to return a list of people but they all show one on line separated by commas.

<<LIST(SELECT(Name of Table[Column], ([Condition Column] = “Value I want to filter on”)))>>

What I really want is each person to show on their own row. And ultimate goal is to have them show in a table, each person on their own row, next column being the type of absence, and the next the # of hours they missed.

Doing a bunch of reading and searching, it seems a start expression might solve for this? But I have been unsuccessful writing a formula for a start expression with a condition. It is only one table, and I could only find mention of reverse reference virtual column which doesn’t apply.

I have tried:

<<Start:[Column], [Column Condition] = “Value I want to filter on”>> <>

and

<<Start:(SELECT(Name of Table[Column], ([Column Condition] = “Value I want to filter on”)))>> <>

Both do not work.
Note I am also unclear where to put the “End” close so I have it in the same row like this:

Couple notes - YES I’m changing table name and column and such to the actual values, I just work for an organization where I can’t share our data publicly.
And I haven’t even touched absence type or hours because I wanted to get the team member piece working. I’ve learned the templates just don’t send if they’re not right, so I take it step by step so I know exactly where I broke it.

Any guidance you can give me would be great. If i can achieve this with another formula I’m all ears too.

0 6 836
6 REPLIES 6
Top Labels in this Space