Skip to main content

Notifications

Field Service forum
Suggested answer

reduce Lookup Size

Posted on by 84

If a certain entity has many lookups, does this mean that the size of the data in this Entity will be very large?

if so, how can optimize the use of lookups in the entity

  • Be Elshayep Profile Picture
    Be Elshayep 84 on at
    RE: reduce Lookup Size

    Thank You all guys...

    I found that there is no way to do that.

    instead, if anybody facing the same problem, I advise him to consider using the connections instead of Lookups and see if that helps.

  • Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: reduce Lookup Size

    Hi Partner,

    As far as I know, there is no way.

    Maybe you can create a support ticket for professional assistance following the below procedure.

    Get Help + Support - Dynamics | Microsoft Docs

  • Mohamed GRAIB Profile Picture
    Mohamed GRAIB 2,498 Super User 2024 Season 2 on at
    RE: reduce Lookup Size

    I think that you cannot modify the size of the lookup field.

    I'm so curious to know if there are a solution fo this.

  • Be Elshayep Profile Picture
    Be Elshayep 84 on at
    RE: reduce Lookup Size

    Hi Leah Ju,

    Thank u for your response.

    but my concern is about the lookup size in database of the other table,

    what I understand is that the lookup is save as an object of {entityType:"", entityName:"" , Id:""}

    this could cost a lot of storage, So my question goes as Is there any way to reduce the lookup used storage?

  • Suggested answer
    Leah Ju Profile Picture
    Leah Ju Microsoft Employee on at
    RE: reduce Lookup Size

    Hi Partner,

    The lookup is not just one field on the entity, when a lookup field is created, it also creates a relationship between the entity that the lookup is created for and the entity that is being looked up to. 

    The lookup field will list records another entity through lookup view, so you can filter the lookup view if you don't want to retrieve all record of the other entities.

    Go to the views of the entity that is being looked up to, then find default lookup view:

    pastedimage1671587319198v1.png

    Add filter you want:

    pastedimage1671587560622v2.png

    https://www.forvis.com/article/2022/10/customize-lookup-views-in-microsoft-dynamics-365-crm 

  • Suggested answer
    Abdul Wahab Profile Picture
    Abdul Wahab 12,070 Super User 2024 Season 1 on at
    RE: reduce Lookup Size

    Hi Be Elshayep,

    I am also interested to know these details related to the storage. As per my very little knowledge, there is no way to optimize lookups. Perhaps you need to take the decision whether to use choice, choices or lookups even text columns (but you will have a garbage data issue with text). There are some relevant threads:

    1. https://learn.microsoft.com/en-us/power-platform/admin/capacity-storage.
    2. https://learn.microsoft.com/en-us/power-platform/admin/add-storage.
    3. https://learn.microsoft.com/en-us/power-platform/admin/add-storage
    4. learn.microsoft.com/.../add-storage
  • Suggested answer
    Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: reduce Lookup Size

    Hi Be Elshayep,

    I am also interested to know these details related to the storage. As per my very little knowledge, there is no way to optimize lookups. Perhaps you need to take the decision whether to use choice, choices or lookups even text columns (but you will have a garbage data issue with text). There are some relevant threads:

    1. https://learn.microsoft.com/en-us/power-platform/admin/capacity-storage.
    2. https://learn.microsoft.com/en-us/power-platform/admin/add-storage.
    3. https://learn.microsoft.com/en-us/power-platform/admin/add-storage
    4. learn.microsoft.com/.../add-storage

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

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,802 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,133 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,154

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans