Get last row in sharepoint list item description

[alexej1]

Hello

I'm trying to build a flow that extract the message id, who is in the last row from a sharepoint list item description.

This flow creates a list item out of an email. It puts the message id in the last row from the description box.

And in this flow, I want that when I add a comment in the issue list item, it extract the message id from the last row in the description box and reply to that email with the last comment I typed in the list item.

If you have any better ideas how I can this solve, I would appreciate it. I'm new in power automate 😊

Greetings

[abm]

Hi @alexej1 

Just before Reply to email(v3) add an action called Compose and do the below expression.

last(split(triggerBody()?['Description'], '#########'))

Then in your Reply to email(v3) step you can map the output of the Compose.

Thanks

[alexej1]

Hi abm

Thanks for your efforts. But the flow showing followed error:

[abm · Accepted solution]

Hi @alexej1 

Looks like comment is null. You need to check whether comment is null or not? Then add the compose and update under the Yes statement.