cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
DogWithRedSocks
Regular Visitor

Remove date from lookup field in Model-Driven app

Hello,

 

I'm building a Model-Driven app for a customer with an underlying Dataverse database. The user is able to add a new record to a table using the main form. In this table, I've a lookup column that displays records of another table the user can select in the main form when adding a new entry.

 

My problem is that when the user is shown the selectable entries of the source table for the lookup column, a date is shown beneath the information:

 

date is shown alongside the selectable legal entitydate is shown alongside the selectable legal entity

 

Is it possible to remove the date and only show the name of the legal entity? Showing the date could lead to confusion. Is this possible?

1 ACCEPTED SOLUTION

Accepted Solutions
DogWithRedSocks
Regular Visitor

I just found the solution myself:

 

Since it's a lookup column (or field) and the information shown to you are based on a view (like a lot of things in Model-driven apps), you can edit this view.

So, for editing a view, you need to go to the table in which you store the information that should be 'looked up' in your main form of your other table. 

When you go to your lookup table and click on Views, there are several standard views, and one of them is a view for searches. Or lookup's. Click on this view and you will see that one the columns of this view is a column with a date and time. Just remove this column from the view, save it, publish it, and you're done.

It's so easy.

 

you can edit some properties of it.  

View solution in original post

1 REPLY 1
DogWithRedSocks
Regular Visitor

I just found the solution myself:

 

Since it's a lookup column (or field) and the information shown to you are based on a view (like a lot of things in Model-driven apps), you can edit this view.

So, for editing a view, you need to go to the table in which you store the information that should be 'looked up' in your main form of your other table. 

When you go to your lookup table and click on Views, there are several standard views, and one of them is a view for searches. Or lookup's. Click on this view and you will see that one the columns of this view is a column with a date and time. Just remove this column from the view, save it, publish it, and you're done.

It's so easy.

 

you can edit some properties of it.  

View solution in original post

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,604)