cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Extracting all URL from Email body

Hi

 

I was trying to automate an sample task in the below step,

  1. Receive email from specific Sender and specific Subject line [Done]
  2. Extract all URL from the email body
  3. Create new excel file in OneDrive
  4. Update the extracted URL in the excel

I'm not sure whether pointer 2 is possible, but I believe "expression" feature can enable the same 

3 REPLIES 3
efialttes
Super User
Super User

Hi!

You can use 'Convert HTML to text' action block and then use WDL expressions

Depending on the body structure, you will need one combination of expressions or other.

Here you are an example

https://powerusers.microsoft.com/t5/Building-Flows/Using-split-to-extract-URL-from-email-body-text/t...

 

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Anonymous
Not applicable

Hi @efialttes 

 

Thanks for introducing me to WDL expression.

 

Does WDL expression support replace, find, looping, storing result in list variable ?

Hi!

Official documentation for WDL based expressions here. replace() is one of them:

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

 

If you are looking for loops, there are several action blocks: Apply to ech, Do Until, Select, Filter Array

You can combine loop-based action blocks and WDL based expressions

Hope this helps



Each time you click on any of our inspiring answers 'Thumb up' icon...
...an ewok scapes from the stormtroopers.

Be grateful, Thumbs up! Save the Galaxy for free!


Escribo sobre Power Automate en:
https://medium.com/anyone-can-automate/

Proud to be a Flownaut!



Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (3,672)