Answered

Best way to convert URL to text link

(0) Share

Report

Posted on by trentq

Hi - could some please help me with the below:

I get items from a SharePoint list and parse each result to an array variable to add to a table, then email out which works great now.

I just want to include the 'Link to item' but as a Text link (i.e Click here to view) rather than the entire URL. What is the best way to do this?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (1)

v-bofeng-msft on at

Like (0)

Report

Hi @trentq :

The point is to write HTML. I’ve made a test for your reference:

1\My Flow

Reference expression:

<table><thead><tr><th>Title</th><th>Link</th></tr></thead><tbody>

Edit the message body in code view mode

The Result:

Best Regards,

Bof

Was this reply helpful? Yes No
trentq 35 on at

Like (0)

Report

Hi Bof - thank you for your reply. Could you help me understand the best place to put this into my current Flow. Do I need another 'Apply to each'?
Thanks

Was this reply helpful? Yes No
v-bofeng-msft on at

Like (0)

Report

Hi @trentq :

No you don't need to do this.

Please pay attention to the following points:

1\In my solution, TheTabe is a string instead of an array.

2\I use HTML to write 'TheTabe' directly, instead of using Create HTML table to convert array into HTML table.

Best Regards,

Bof

Was this reply helpful? Yes No
trentq 35 on at

Like (0)

Report

Thanks for the response, but I am lost - I'm not sure what to do next.

Was this reply helpful? Yes No
Verified answer

v-bofeng-msft on at

Like (1)

Report

Hi @trentq :

Don’t worry, you just need to follow my steps exactly

1\Step1:

In your ‘Initialize variable’ step, set ‘The Table’ to String and set it's value to:

<table><thead><tr><th>Person</th><th>Start</th><th>End</th><th>LeaveType</th><th>Approver</th><th>Link</th></tr></thead><tbody>

2\Step2:Replace 'Append to array variable' with 'Append to String variable2' and set it's value to:

<tr>

<td>{Name}</td>

<td>{Convertedtime}</td>

<td>{Convertedtime}</td>

<td>{LeaveType}</td>

<td>{SubmitToXXX}</td>

<td><a href="@{Linktoitem}" >Link to item</a></td>

</tr>

3\Step3:Add an other "Append to string variable" action outside the loop and set it's value to

</tbody></table>

4\Step4:Delete 'Create Html table'

5\Step5:Use variable "thetable" to replace OutPut of "Create Html table".

If you have questions about HTML I suggest you check this website:

https://www.w3schools.com/html/

Best Regards,

Bof

Was this reply helpful? Yes No
trentq 35 on at

Like (0)

Report

Thanks Bof - that has worked perfectly. Cheers!

Was this reply helpful? Yes No