How to extract specific line from my multi-line text variable

[BenBallantine]

I've done a series of crop text actions to arrive at the below. The final step is to just retrieve line 1 only into it's own variable. So for the end result in this example is a variable with the value "Draft".

[momlo]

You can use the parse text action to find virtually any text in your text variable, even before you "clean" it with previous efforts.

In your example you could use this pattern to get the first line, check "regex" and "first occurrence only" in the parse text action:

.*\s\s

Alternatively you can split the text into list and then get first element on the list, but regex will do the job in one action 😉

if you past how the text variable looks before you clean it, we can see if you can get desired value without need to clean 🙂

[SkSaba]

Hello @BenBallantine  ,

Please let me know if you got a solution for it.

Thanks,

[Agnius]

As @momlo correctly pointed out, it can be done much more efficiently with a Parse text action using regular expressions.

But with the context that we have here, using Split text to split the text with a new line as the delimiter, would convert the text into a list of strings for each line. Then using Set variable to set some new variable as %TextList[0]% would result in the first line of the string.

-------------------------------------------------------------------------
If I have answered your question, please mark it as the preferred solution. If you like my response, please give it a Thumbs Up.

I also provide paid consultancy and development services using Power Automate. If you're interested, DM me and we can discuss it.

[prashanth_gr]

Hello @SkSaba @BenBallantine 

Use parse text and enter .*\s\s in text to find field and disable first occurrence only.

Then you can access the values in form of Matches[0], matches[1] and so on.