cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

How to get the Alternate text of the Hyperlink Column

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User III
Super User III

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.

 

image.png

 

Above expression is as follows:

body('Send_an_HTTP_request_to_SharePoint')['d']['WebSite']['Description']
 
Here Website is my hyperlink column name.
 
 
SharePoint list
image.png
My test result is as follows:
 
image.png
 
Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

3 REPLIES 3
Highlighted
Super User III
Super User III

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.

 

image.png

 

Above expression is as follows:

body('Send_an_HTTP_request_to_SharePoint')['d']['WebSite']['Description']
 
Here Website is my hyperlink column name.
 
 
SharePoint list
image.png
My test result is as follows:
 
image.png
 
Thanks

 



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog

Power Automate Video Tutorials

View solution in original post

Highlighted

@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_0-1599228563383.png

 

Highlighted

I figured it out using your help!

 

This is my final code and it's working perfectly 

 

WC-KSTILL_0-1599233031991.png

 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Top Kudoed Authors
Users online (12,778)