cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

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
Highlighted
Dual Super User III
Dual Super User III

Re: Extracting all URL from Email body

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!



Highlighted
Regular Visitor

Re: Extracting all URL from Email body

Hi @efialttes 

 

Thanks for introducing me to WDL expression.

 

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

Dual Super User III
Dual Super User III

Re: Extracting all URL from Email body

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
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

Join the new Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

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!

Users online (5,487)