Replacing hyperlink with text in email

[Peter_Kalu]

I’ve set up an action to start an email with predefined body. Within the body I have something like:

"Please find attached " & HYPERLINK([ReportURL], "the report “) & " showing the results of your review”.

My problem is that when the action is fired and gmail opens up, the text for the report URL doesn’t display. I just see the entire URL. How can I fix this to have a custom embeded clickable text that opens up the link?

Thank you!

[Lucinda_Mason]

I’ve used the following:

Another table and view and this link format works perfectly here. The only difference is ‘page=detail’ versus ‘page=form’ above. Though I tried that as well in the example above and it didn’t change anything.
<a href="https://www.appsheet.com/start/922dbed2-5196-4caa-9581-401fc815a472#appName=Requests-1778436&page=detail&row=<<[PR_NO]>>&table=All_Active_Private_Requests_Visible_to_User&view=All_Active_Private_Requests_Visible_to_User_detail&at=<<ENCODEURL(NOW())>>">Please click here to add your prayer for this request.</a>

The thread is here: Help with workflow link to app