Ive got a sharepoint list that uses a Person field. I use GET ITEMS to grab all the data, and a Create a HTML table with some of the fields, and i use the output of that in an email so i'm getting a table in the email with the fields.
HOWEVER the Person field is giving me lots of bits, and i just want the DisplayName and Email bits from it.

any ideas how i can grab just those two pieces for each row in the table for my email ?
the end result is to have the table in the email AND send the email to all the names in the Person Field in any of the rows.
your guidance would be appreciated.
Many thanks
Stephen