You’re offline. This is a read only version of the page.
24
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!
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,
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!
Hi @AK989 ,
I made a test with something similar to your sample:
So, if both URLs are included by [ ], you can use below expression:
Share
Report
All responses (
Answers (
split(split(outputs('Html_to_text')?['body'],'[')[2],']')[0]
Best regards,
Hi @AK989 ,
Text is preferred and I can copy to test it with. Please remember replace sensitive data with *.
Best regards,
Hi @AK989 ,
Could you please share a sample of the Email body, so we are able to test with it?
Best regards,
#1
Michael E. Gernaey
566
Super User 2025 Season 1
#2
David_MA
516
Super User 2025 Season 1
#3
stampcoin
492
