{"id":21195,"date":"2019-11-26T10:23:45","date_gmt":"2019-11-26T10:23:45","guid":{"rendered":"https:\/\/www.inogic.com\/blog\/?p=21195"},"modified":"2022-06-14T14:46:56","modified_gmt":"2022-06-14T09:16:56","slug":"how-to-add-hyperlink-to-data-table-column-in-powerapps","status":"publish","type":"post","link":"https:\/\/www.inogic.com\/blog\/2019\/11\/how-to-add-hyperlink-to-data-table-column-in-powerapps\/","title":{"rendered":"How to Add Hyperlink to Data Table Column in PowerApps"},"content":{"rendered":"

Introduction<\/strong><\/h2>\n

PowerApps lets you create, customize and run mobile apps with very less code. Microsoft released new experience for user in PowerApps which are more user friendly and improves user experiences.<\/p>\n

In today\u2019s blog we will explore more on hyperlink property in Data Table control for PowerApps.<\/p>\n

Now, let\u2019s consider a scenario where users want to open related record in PowerApps. In the following example, we will illustrate how to open contact records related to account in different form.<\/p>\n

Please follow the below steps to implement the above scenario in PowerApps<\/strong><\/p>\n

1<\/strong>. Create a new canvas app in PowerApps. Click on this link<\/a> for information on how to create canvas app.<\/p>\n

2<\/strong>. Add a List screen (BrowseGallery1) and set the Account<\/strong> data set to it, as shown in below screenshot:<\/p>\n

\"How<\/p>\n

3<\/strong>. Then add DataTable on DetailScreen form as shown in below screenshot:<\/p>\n

\"How<\/p>\n

4<\/strong>. Next, add a formula on Datatable to filter datatable and retrieve contact records related to account as shown below:<\/p>\n

Formula<\/strong> – Filter(Contacts,GUID(‘Company Name’)= BrowseGallery1.Selected.Account)<\/em><\/strong><\/p>\n

\"How<\/p>\n

This formula will display Contact records related to Account.<\/p>\n

5<\/strong>. Now to make field as hyperlink<\/strong>, we need change the \u2018Is hyperlink\u2019<\/strong> property of the column to true, as shown in below screenshot. This will make the field clickable.<\/p>\n

\"How<\/p>\n

6<\/strong>. Add formula in column to navigate to next screen when the hyperlink field is clicked. Formula : Navigate(EditForm4,ScreenTransition.Cover,{ ID: DataTable1.Selected } )<\/em><\/strong><\/p>\n

\"How<\/p>\n

7<\/strong>. Now add another new form screen to open Contact record when clicked on the hyperlink field.<\/p>\n

\"How<\/p>\n

8<\/strong>. Add data source as Contact to show contact records. Set formula on Item as shown in below screenshot:<\/p>\n

Formula: DataTable1.Selected<\/strong><\/p>\n

\"How<\/p>\n

9<\/strong>. Now run the app on your mobile device. Click on the arrow highlighted in below screenshot and you will be redirected to next form where you can see related contacts of the selected account.<\/p>\n

\"\"<\/p>\n

Note:<\/em><\/strong> In case of multiple contact records scroll bar will be automatically displayed on the right side of the table as shown in above screenshot.\u00a0 <\/em><\/strong><\/p><\/blockquote>\n

10<\/strong>. Click on Hyperlink field (i.e Full Name)<\/strong> to open the contact record.<\/p>\n

\"How<\/p>\n

Conclusion<\/strong><\/h2>\n

\u00a0<\/strong>Thus, as illustrated above, we can easily add hyperlink to the Data Table column in PowerApps.<\/p>\n

One Pic = 1000 words! Analyze data 90% faster with visualization apps!<\/div><\/div><\/h2>\n

Get optimum visualization of Dynamics 365 CRM data with –<\/em>
\nKanban Board<\/a> <\/strong>\u2013 Visualize Dynamics 365 CRM data in Kanban view by categorizing entity records in lanes and rows as per their status, priority, etc.<\/em>
\nMap My Relationships<\/a><\/strong> \u2013 Map My Relationships \u2013 Visualize connections and relationships between Dynamics 365 CRM entities or related records in a Mind Map view.<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

Introduction PowerApps lets you create, customize and run mobile apps with very less code. Microsoft released new experience for user in PowerApps which are more user friendly and improves user experiences. In today\u2019s blog we will explore more on hyperlink property in Data Table control for PowerApps. Now, let\u2019s consider a scenario where users want\u2026 Read More »<\/a><\/span><\/p>\n","protected":false},"author":13,"featured_media":21205,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[16,38],"tags":[1170],"class_list":["post-21195","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-dynamics-365","category-microsoft-powerapps","tag-microsoft-powerapps"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/21195","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/comments?post=21195"}],"version-history":[{"count":0,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/posts\/21195\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media\/21205"}],"wp:attachment":[{"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/media?parent=21195"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/categories?post=21195"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.inogic.com\/blog\/wp-json\/wp\/v2\/tags?post=21195"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}