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)

Verified answer

v-jefferni on at

Like (0)

Report

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 (0)

Report
will that be enough?

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

Like (0)

Report

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 on at

Like (1)

Report
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 (0)

Report

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 on at

Like (0)

Report

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