cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate III
Advocate III

Extract row number n from text

I used HTML to text conversion and then split function via compose.

 

Now I have 45 lines/rows.

 

I need to extract line 4 from the output.

 

How can I do this?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Community Support
Community Support

Hi @GrischkePro,

 

According to your description, I made a simple test on my side. To get line 4 from the output, I used functions skip and take in the Compose action:

take(skip(outputs('Compose'),3),1)

 

It returned the line 4 properly.

1.PNG

2.PNG

 

More details about the WDL function, please check it at here:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#s...

 

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Highlighted
Community Support
Community Support

Hi @GrischkePro,

 

According to your description, I made a simple test on my side. To get line 4 from the output, I used functions skip and take in the Compose action:

take(skip(outputs('Compose'),3),1)

 

It returned the line 4 properly.

1.PNG

2.PNG

 

More details about the WDL function, please check it at here:

https://docs.microsoft.com/en-us/azure/logic-apps/workflow-definition-language-functions-reference#s...

 

 

 

Best regards,

Mabel Mao

Community Support Team _ Mabel Mao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Highlighted

Thanks @v-yamao-msft

 

Before I saw your solution, I came up with mine, which also works. However, yours is much cleaner so I will definitely try it, but can you please show me your first split line?

 

 1.png

 

split(variables('emailTextVar'),outputs('breakCharacter'))

2.png

It's dirty, but it works Smiley Very Happy

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (13,474)