its sending all the additional comments new ones and previous too I only want to send the latest add

[kiran kumar m1]

I have created a flow , whenever we change the additional comments it should send a mail to the caller mail with those additional comments , but whenever I update the additional comments , its sending all the additional comments new ones and previous too I only want to send the latest additional comments though mail, I am thinking of writing script but in email body I dont find any way to write script ? How can we achieve this ?

[Ankur Bawiskar]

@kiran kumar m1 

you can't get latest comments directly

you can do this

1) use lookup record action before Send Email and get the record from sys_journal_field which is latest for this record and comments field

2) then use Output of this in Send Email action by selecting the Value field from Lookup Record action

If my response helped please mark it correct and close the thread so that it benefits future readers.

[kiran kumar m1]

Hi @Ankur Bawiskar  I have tried this but its not picking the latest comment its picking the first comment that we have added , if we add a new comment its sending the notificaton with the first comment not the latest

[Ankur Bawiskar]

@kiran kumar m1 

did you add the correct sorting i.e. Z to A on created field

please share your screenshot of Lookup record

[kiran kumar m1]

[dgarad]

Can you generate the body using a script?