I'm not sure if you want to see how to extract from the format you provided, or from hyperlinks in an email.
Below is how I would extract out the hyperlinks from an email. Example of the email is below:
The full flow is below. I'll go into each of the actions.
I've got the trigger pointing to my inbox.
I then use Html to text to convert the body of the email to plain text.
This gives me the following output for the hyperlinks.
I then use a Compose to split by new line. The expression is below:
split(outputs('Html_to_text')?['body'], decodeUriComponent('%0A'))
Next, I use a Filter array to filter out lines, so we only get the hyperlinks. I've used [http to filter the items as assume we could also have https links.
This gives us the following output.
And finally, I use a Select to get a JSON array of links with Name and URL. The expression I use for Name and URL respectively.
split(item(), ' [')[0]
split(replace(item(), ']', ''), ' [')[1]
The final output is:
[
{
"Name": "Google",
"URL": "http://google.com"
},
{
"Name": "Yahoo",
"URL": "http://yahoo.com"
},
{
"Name": "Bing",
"URL": "http://bing.com"
}
]
If that's not what you want, then let us know.
