A business has configured a Screen Flow embedded on an Account Lightning Record Page. The Flow displays a Data Table with each Account's related Contacts, showing key record information at a glance. The business wants the Contact Names in the Data Table to be clickable so users can navigate directly to the Contact record.
Out of the box, the standard Screen Flow Data Table component does not support clickable Name fields. As a workaround, you can create a formula field on the object which uses the HYPERLINK function to build a URL that can be directly accessed from the Data Table. As a best practice, be sure to build and test Flows in a Sandbox before deploying to a Production environment.
Create a new Formula field on the object whose records will be displayed in the Data Table - in this example, we are displaying related Contacts on an Account's record page, so the Formula field will be added to the Contact object. The Formula field should be of type Text, and the formula uses the HYPERLINK function to display the First and Last Name of the Contact, while linking to the record Id.
HYPERLINK("/" & Id, FirstName & " " & LastName, '_self')
This formula builds a relative URL to the Contact record using its Id, and displays the Contact's full name as the clickable link text.
To obtain the collection of Contacts to display, configure a Get Records element to find all Contacts where the AccountId equals the current record's Id.
In the Flow, navigate to the Data Table component on the Screen element and add the new formula field as a column - you can modify the label to display a user-friendly name, such as Contact Name, instead of the underlying Formula field name. For example, if the Formula field is called Link to Contact, the Data Table column can instead display Contact Name.
Save and Debug the Flow, and confirm that the Contact Name column displays a clickable hyperlink. When the Flow is activated and embedded on an Account page, it should return results similar to the screenshot below.
Written by: Zack Terry | Forum Ambassador
Zack Terry is a Senior Solution Architect at Fast Slow Motion, which aims to be a blessing to business leaders by helping them implement and maximize their use of the Salesforce platform. At the time of writing, Zack has worked in the Salesforce ecosystem for nearly a decade, holds 24 Salesforce Credentials, and has achieved the rank of "All-Star Ranger" on Trailhead. Zack serves as a Trailblazer Community Forum Ambassador, and regularly participates in the community.
Submissions reflect only the opinions of the user who made available the Submission and not the opinions of Salesforce, regardless of whether the user is affiliated with Salesforce, and may contain or constitute products, services, information, data, content and other materials made available by or on behalf of third parties ("Third Party Materials"). Salesforce neither controls nor endorses, nor is Salesforce responsible for, any Third Party Materials, including their accuracy, validity, timeliness, completeness, reliability, integrity, quality, legality, usefulness or safety, or any applicable intellectual property rights. Any Submissions made available through any message board or forum in response to posted questions, or that otherwise purports to answer any questions, including any questions about Salesforce or Programs, are made available for your general knowledge only and should never be relied upon as answers to your specific questions (even if an answer is marked as a "best" answer or with any similar qualifications). You should always contact Salesforce support for answers to your specific questions. Salesforce has no control over Submissions, and is not responsible for any use or misuse (including any distribution) by any third party of Submissions.
If you have questions, tap into the wisdom of our entire Trailblazer Community here: https://trailhead.salesforce.com/trailblazer-community/feed
002471439

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.