Unanswered

Create a Lookup View

(0) Share

Report

Posted on by Community Power Pla...

Greetings,

When I'm adding/editing a record (attribute) in an entity (table) and I need to do a search in the lookup field, it shows name and date, which isn't helpful. How do I add a custom Lookup View, so that when I am searching it shows what I want (name and province)?

Thanks,

Shane.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Verified answer

voinea 24 on at

Like (0)

Report

You need to edit the default "Lookup View" used by that entity within the "Views" section

Was this reply helpful? Yes No
Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @CShaneGoodman ,

You can go into the default Lookup View for the table and do a "Save As" to create a custom Lookup view and then utilize this one instead of the default with the columns you would like (the first two in the view will show in that lookup field). You can set this as the default view for that lookup field on the form.

Hope this helps. Please accept if answers your question or Like if helps in any way.

Thanks,

Drew

Was this reply helpful? Yes No
Community Power Pla... on at

Like (1)

Report

I was able to do a "save as", but it saved as a Public view type (instead of a Lookup view). I can still access it in the lookup field, but since its not a proper Lookup view, setting it as default doesn't change the default Lookup view.

It was a good suggestion, though.

Shane.

Was this reply helpful? Yes No
saurabh_jadhav 11 on at

Like (0)

Report

Hey, I have a field in my form of LookUp type in Power Pages.
How can I edit the view of that lookup?
Because, the LookUp View that pops up when I'm selecting any lookup record in the field is provided by platform itself.

In the 1st image attached, there are some of the marked columns that I want to remove from the view. How can I do it?

image.png

image.png

Was this reply helpful? Yes No
noorfar 52 on at

Like (0)

Report

Hello,, I'm trying to create a lookup view different than the default one but in Dataverse.. is it doable?

Was this reply helpful? Yes No
saurabh_jadhav 11 on at

Like (0)

Report

Hi @noorfar ,
What do you mean by "view" in Dataverse?

Was this reply helpful? Yes No
noorfar 52 on at

Like (1)

Report

Hey @saurabh_jadhav
table > data experiences> views > I want to create here another lookup view

this is a description for what I want to do
https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Create-a-lookup-view-and-use-non-primary-column/m-p/2098763#M28975

Was this reply helpful? Yes No