cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
GABRIELV221
Helper I
Helper I

Populate a MS Word Tempalte with Hyperlinks

Hi folks!

 

I'm working to create a pdf (using Populate a MS Word Tempalte andConvert Word Document to PDF) with data from SharePoint lists.

The last field to populate is a link. But I just can populate as a text field, no as a Hyperlinks.

 

So, looks a litle bit ugly to share a PDF document with the hyperlinks as a text, without the capability to click and go to the item or file.

 

This is my SELECT step to create the array.

I was tryinh with Plain Text (Q7) and Rich Text (Q8) in the template, but are the same content.

 

Q7

URL: replace(replace(replace(items('Apply_to_each')?['{Link}'],'&lt;','<'),'&amp;','&'),'&gt;','>'

 

Q8

URL: concat('<a href="',replace(replace(replace(items('Apply_to_each')?['{Link}'],'&lt;','<'),'&amp;','&'),'&gt;','>'),'"</a>')

 

GABRIELV221_0-1668019006995.png

 

But in my files (Word and PDF) I just see as a text field...

 

WORD:

GABRIELV221_2-1668019309467.png

PDF:

GABRIELV221_1-1668019305345.png

 

I get the link and if I copy/paste can go to the item.

But I need get the hyperlink format.

 

Could you help me?

 

1 REPLY 1
GABRIELV221
Helper I
Helper I

🤔

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (3,718)