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.

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.

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

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

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

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.

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

Debajit Dutta
Business Solutions MVP