Showing only the latest comment

[Frank7]

Good morning

I have created a flow which is working fine but there is a detail I like to improve.

When a status change a mail is sent and it contains comment. I have discovered that always all comment are added but I would like to achieve that only the latest comment from MS Lists is added to the mail.

[Frank7]

None who could help here?

[AnthonyAmador]

Hi @Frank7 

I assumed that what you have in the item "Comments" is a string with all the comments, first you want to make sure that all the comments are separated by a character, (in my example I use "|"), then I use an expression to split and extract only the last part. 

last(split(variables('comments'),'|'))

This is the example. 

Hope this helps.

Best regards. 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Frank7]

Hi @AnthonyAmador , thank your for your feedback. I just came back from vacation and I will have a closer look asap

[Frank7]

Hi @AnthonyAmador you have helped me in this matter but now I have found out that it makes much more sense to add all comments to the mail. I have seen the option to add date/time and the and the one who added this comments to the mail to have a kind of a history but I am not able to find this again in the web. can you help me out?