How to stop navigation from Lookup columns in Model Driven Apps grid

The feature that I am going to discuss in the blog has been there for sometime. But strangely I find many experienced consultants not aware of this feature. Hence decided to pen this down.

But what is the requirement here? If you are working in Power Platform or Dynamics 365 products, you must be working with Grids in Model driven apps. Below is the Contacts grid.

Remove hyperlink from lookup columns in Model driven apps grid

The “Company Name” field is the Parent account for the contact. In our Model driven apps grid, every Lookup column by default is a hyperlink which when clicked navigates to the corresponding parent record.

The client didn’t want that. The client only wanted the Primary attribute of the table as hyperlink. All other columns should be standard. But how do I do that?

Unknow to many, Microsoft now has the Power Apps Read-Only Grid control which has the capability to do that.

Include your table in DataVerse solution and then switch to classic view. And navigate to the Controls tab.

Remove hyperlink from lookup columns in Model driven apps grid

Click on “Add Control” and then add the required control.

Remove hyperlink from lookup columns in Model driven apps grid

In the configuration area of the control, let’s focus on the Navigation types allowed.

Remove hyperlink from lookup columns in Model driven apps grid

Click on Edit. You have two options – All and Primary Only.

Remove hyperlink from lookup columns in Model driven apps grid

Set to Primary Only. The final step is to make sure that it is visible on the required platform Web/ Phone/ Tablet.

Make sure to publish your customizations.

Let’s come back and refresh the contacts grid. As you can see, the Company Name field is no longer a hyperlink.

Remove hyperlink from lookup columns in Model driven apps grid

Hope this helped! You will also like the below posts.

Debajit Dutta
Business Solutions MVP