Select the last item added from the list in Send email Automation

[Israel_Garza]

I am working on an automation with the purpose of sending an email to a person who took a training. The automation is triggered when I add a training type (this is a multiselect option field in my table). On the subject and message of the email, I would like to show the name and training type. However, whenever I add the training type on the message, it shows the entire list of training. I only want to show the one that person just recently took, in this case, it should be the last item of the list of trainings.

Can you please help with this? Any workaround?

[bruceconsulting]

Hi,
Your table should ideally contain a record for each training type a person took.  Your automation will then run off of the most recently created record.
A work-around would possibly be to create a new field that holds the last class a person took.  You can then use that field when a record is updated.  It would entail entering a training type into 2 fields, however.
I would strongly suggest you re-do your table to hold one record per training type.

Jody

[TheTimeSavingCo]

Try creating a formula field with this:

REGEX_EXTRACT(
  {Trainings},
  '[^,]*$'
)

This will output the latest multiselect option you've added to the field, and you can use this in your automation
Link to base