How to extract hyperlink from email body using Power Automate and write to Excel?

(0) Share

Report

Posted on by zoey2025

Hi everyone,

I'm trying to use Power Automate to process incoming emails automatically. Each email contains an incident ID and a hyperlink that leads to the incident management website. I want to summarize these in an Excel table with two columns: one for the incident ID and one for the hyperlink.

Right now, I can extract the incident ID using Power Automate, but I can't figure out how to get the hyperlink from the email body. The link is embedded in a sentence like:

The following changes have been made to the 182364: Suspicious query incident:
Assignment group:
Click here to view the security incident: SJT00435 (this is a hyperlink)

Does anyone know how to extract this hyperlink using Power Automate? Or is there another way to achieve this?
Thanks in advance!

Categories:

General topics

I have the same question (3)

All responses (4)

Answers (0)

Suggested answer

MS.Ragavendar 6,334 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@萍周-16100549-0,

I could see the similar post in the past - https://community.powerplatform.com/forums/thread/details/?threadid=17f34939-bb9f-4dcc-a8e5-bf9280d48cbd

check does this help you in resolving your issue, if not revert back.

✅ Please click Accept as solution if my post helped you solve your issue and help others who will face the similar issue in future.

❤️ Please consider giving it a Like, If the approach was useful in other ways.

🏷️ Please tag me @MS.Ragavendar if you still have any queries related to the solution or issue persists.

Was this reply helpful? Yes No
zoey2025 15 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your response. However, it doesn’t seem to address the issue I’m facing.

Was this reply helpful? Yes No
chiaraalina 1,864 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi

Is it always the same format in the email body?

Then you can use something like this:

Compose - Incident ID (or similar):

substring(

triggerOutputs()?['body/body'],

add(indexOf(triggerOutputs()?['body/body'], 'to the '), 7),

sub(

indexOf(

substring(

triggerOutputs()?['body/body'],

add(indexOf(triggerOutputs()?['body/body'], 'to the '), 7),

20

),

':'

),

0

)

)

Compose - Link:

substring(

triggerOutputs()?['body/body'],

add(indexOf(triggerOutputs()?['body/body'], 'href="'), 6),

sub(

indexOf(

substring(

triggerOutputs()?['body/body'],

add(indexOf(triggerOutputs()?['body/body'], 'href="'), 6),

200

),

'"'

),

0

)

)

Let me know if it worked!

1 people found this reply helpful.

Was this reply helpful? Yes No
zoey2025 15 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much for your response. I tried your method today, and it worked perfectly!

Was this reply helpful? Yes No