Get last row in sharepoint list item description

(0) Share

Report

Posted on by 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

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
alexej1 13 on at

Like (0)

Report

Hi abm

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

Was this reply helpful? Yes No
Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

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.

Was this reply helpful? Yes No