Answered

Extract href from email

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

Hi ,

I am struggeling to filter the href URL from the emailbody to send only this information to slack.

The trigger is if I receive a certain email than please get only the href URL and use only that variable and send it to slack

Categories:

General topics

All responses (9)

Answers (1)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Sundeep_Malik 6,501 on at

Like
a
(1)

Report
Copy link

Link copied!

@Anonymous
Can you share an example of data you are receiving in the email body and what output you require?
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@Sundeep_Malik
this is the output if I convert the email to HTML

Here the PM 2022-10-05 throws 500 errors [https://kb.confluence.com/display/tech/thissite]

and behind the 2022-10-05 throws 500 errors is the link behind in the brackets

I want the description and the href behind as value
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Any news? @Sundeep_Malik
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@Expiscornovus maybe you could help 🙂
Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous,

You could use an expression which splits on the '[https://' part of the body/body of your email.

Below is an example.

This setup only works for the first link it finds.

I have also included an indexOf to make sure there is actually such a link in the email.

if(equals(indexOf(triggerOutputs()?['body/body'], '[https://'), -1), 'Link not Found', concat('https://',split(split(triggerOutputs()?['body/body'], '[https://')[1], ']')[0]))
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the quick reply @Expiscornovus below you find the result and how the email looks in original
this is how the email looks
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
"body": "<html><head>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\"><meta name=\"Generator\" content=\"Microsoft Word 15 (filtered medium)\"><style>\r\n\r\n</style></head><body lang=\"DE\" link=\"#0563C1\" vlink=\"#954F72\" style=\"word-wrap:break-word\"><div class=\"WordSection1\"><p class=\"MsoNormal\">This test <a href=\"https://kb.confluence.com/\">URL</a></p><p class=\"MsoNormal\">
Verified answer

Expiscornovus 33,997 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Anonymous,

Sorry, I missed the part where you used the HTML to text.

In that case you need to use:

if(equals(indexOf(body('Html_to_text'), '[https://'), -1), 'Link not Found', concat('https://',split(split(body('Html_to_text'), '[https://')[1], ']')[0]))