How to get the Alternate text of the Hyperlink Column

[WC-KSTILL]

Hi,

I am trying to send an email (v2) when an item is created or modified. The info in the email contains field columns etc.

What I can't figure out is the hyperlink column, the column called URL. When the email is sent it only gives the link of the URL and not the alternate text/friendly name. How can I also include that?

https://i.imgur.com/8CCGdGm.png

https://i.imgur.com/Bt9OMib.png

[abm · Accepted solution]

Hi @WC-KSTILL 

You need to use the SharePoint REST API. Below 'ListA' is my SharePoint list name and '101' is the identifier of the list record.

Above expression is as follows:

body('Send_an_HTTP_request_to_SharePoint')['d']['WebSite']['Description']

Here Website is my hyperlink column name.

SharePoint list

My test result is as follows:

Thanks

[WC-KSTILL]

@abm 

Hi, thank you so much for replying. I had a question.

When you say 101 is the identifier of the list record, how am I supposed to get the identifier of the item that was just recently added or modified?

This is my current flow

[WC-KSTILL]

I figured it out using your help!

This is my final code and it's working perfectly