web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Customer Service forum

Lookup field show me others values

(0) ShareShare
ReportReport
Posted on by 47

I have a field lookup to another entity, when a I search a value the lookup field shows me another values that may be fit but I want to just show me the value that I already put.
How I can do that? 

m103v2.PNG

Thanks!!

Categories:
I have the same question (0)
  • Suggested answer
    RaviKashyap Profile Picture
    55,410 Moderator on at

    Hi,

    Do you always want to show just this value for all records? Or there is any business logic to show this value on specifc conditions?

    Asking cause if you just want to display this value alays then the easiest way would be to create a new view which returns this value. And then use that view in the lookup filter view settings.

    Refer this video: www.youtube.com/watch

    Hope this helps.

  • neryhumberto Profile Picture
    47 on at

    Hi Ravi.!! How are you???

    Yes I just want to show the results that fits exactly with this value in the search, I already created a Lookup View but when I search this shows all the values that may fit or are similar.

    Thanks

  • RaviKashyap Profile Picture
    55,410 Moderator on at

    The view you have created, check that view if it is returning just this value or all..if all then you need to fix the view to return just this value.

  • neryhumberto Profile Picture
    47 on at

    Yes I tried created a view whith the field that I am looking for.

    I mean, when I search "M103" the lookup field shows me "M1034 and M103", but I dont want the value M1034

    I just want to see the M103 because is the value that fits exactly.

  • Suggested answer
    RaviKashyap Profile Picture
    55,410 Moderator on at

    You need to create a new view which returns that value only. Refer to the video I shared above.

  • neryhumberto Profile Picture
    47 on at

    What I am missing?

    a1041v1.PNG

    a1041v2.PNG

    a1041v3.PNG

  • Suggested answer
    RaviKashyap Profile Picture
    55,410 Moderator on at

    Within the View, you need to set a filter to only return your record. For this you need to click Edit Filter Criteria. There you select the record.

  • neryhumberto Profile Picture
    47 on at

    Yes, but the problem is I have to change this every time I do a search in the lookup field, I mean this works if I do just one search at the time but the value is chaning and I am going to search a lot of values and I want to show just the value that fit exactly.

    filter.PNG

    Thanks for the response

  • RaviKashyap Profile Picture
    55,410 Moderator on at

    Ohh sorry... this means the value will not be always same. It varies based on some business logic or condition.

    Can you share how do you identify which value to use?

  • neryhumberto Profile Picture
    47 on at

    This entity is used to register people in a event so  the lookup field is related to another entity with a key that identify the subscription plan, we have a lots of "uniques keys" like M103, M104, M105 ... .... so we dont have a business logic any unique key may be used any time.

    Thanks for you response.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Customer Service

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans