Variable value

[Alphadrag]

Hi all, shown in the below image is the variable value from the body of a retrieved email. I want to PAD to read the content of the 2nd last row, meaning like 531, such that if it contains "backup done", it will execute a certain task. How can I check that? Thank you all in advance for your help.

[VJR]

If your line number is constant then you can do it as per the post here.

https://powerusers.microsoft.com/t5/Power-Automate-Desktop/Variable-Text-pull-specific-line/m-p/1626...

[Alphadrag]

Hi, the line isnt always constant though

[VJR]

If you just want to find the string "backup done" anywhere in the string then you can do so using Parse Text action.

[Alphadrag]

There are many backup done inside the variable value. However, i only want the 2nd last line

[VJR]

If you always want the second last line then do the datatable.count and decrease the count.

Using the decreased variable apply the same solution as this.

[Alphadrag]

what do you mean by decreased variable? If you could, can you show me an example? thanks!

[Gidi]

Hi, you can also use math operation like %datatable.count-2% to set the row number. 

[Alphadrag]

How can i do something like this: %RetrievedEmails[0].Body.Count - 2%? This does not seem to work as it states that body does not have the variable count

[Alphadrag · Accepted solution]

Update:

I managed to retrieve the contents of the 2nd last row already.

Firstly, as @Gidi mentioned, I created a variable called RowCheck after splitting the text in the list and set it to BodyTextList.Count-2. This will always retrieve the 2nd last row of the body content of the email.

Next, based on the link @VJR provided, i created another variable called StatusCheck and set it to BodyTextList[RowCheck]. This will then retrieve the contents in that row for me.