cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
WC-KSTILL
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
abm
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 blogPower Automate Video Tutorials

View solution in original post

3 REPLIES 3
abm
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 blogPower Automate Video Tutorials

View solution in original post

@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

 

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
MPA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Users online (48,015)