cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GrischkePro
Level: Powered On

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 Team
Community Support Team

Re: Extract row number n from text

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 Team
Community Support Team

Re: Extract row number n from text

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

GrischkePro
Level: Powered On

Re: Extract row number n from text

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
firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Solution Authors
Top Kudoed Authors
Users online (6,026)