List comprehension then output to text?

[twain]

I’m trying to figure out how to send each user on a sports team an SMS summary of what periods they’re in and what jersey colors they are assigned.

The data looks like this:

I want the SMS to say:
“Hello Ann, your colors for today are
1 - Blue
2 - Blue
3 - Red”

I know I can use backend workflows to do a separate message for each player. But what I’m super stuck on is how to generate the “period - color” loop into text. In python this would be a simple list comprehension…but I’ve got no idea how to do this in Bubble.

If I can avoid using plugins that would be great – I’m a new Bubble user so I’d prefer to remain on the main track if I can.

I’m guessing it’s some combination of setting a state variable, and outputting lists to text, but I’m getting wrapped around the axle – thank you in advance.