Exctract http link from email and attach it to a certain word in Excel

(0) Share

Report

Posted on by AK989

Hello everyone,

I would really appreciate some help now.

I have 2 autogenerated links in my email (it differed from email to email, only the compony name is the same in the link).

I need to extract the second link and attach it to a certain word in online Excel in Sharepoint.

I have tried first(split(slice(outputs('Html_to_text')?['body'], indexOf(outputs('Html_to_text')?['body'], 'http://')), ' ')) but it returns random letters as a value.

Thank you very much for your help!

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AK989 ,

Could you please share a sample of the Email body, so we are able to test with it?

Best regards,

Was this reply helpful? Yes No
AK989 24 on at

Like
a
(0)

Report
Copy link

Link copied!
will that be enough?

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AK989 ,

Text is preferred and I can copy to test it with. Please remember replace sensitive data with *.

Best regards,

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @AK989 ,

I made a test with something similar to your sample:

So, if both URLs are included by [ ], you can use below expression:

split(split(outputs('Html_to_text')?['body'],'[')[2],']')[0]

Best regards,

Was this reply helpful? Yes No
AK989 24 on at

Like
a
(0)

Report
Copy link

Link copied!

Omg, you are a magician, it worked.Thank you for your understanding, as the data I am automating is a bit sensitive. The last question please. Can I attach this link to a certain word in online Excel. One more time thank you a million!

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @AK989 ,

It seems simple. But without the details of your excel, I'm not sure. You'd better post a new case with detailed scenario so more users in the forum will see it and help.

Best regards,

Was this reply helpful? Yes No