web
You’re offline. This is a read only version of the page.
close
Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Enable Lookup for Cust...
Finance | Project Operations, Human Resources, ...
Unanswered

Enable Lookup for Custom Dimensions in Excel Add-in

(1) ShareShare
ReportReport
Posted on by CU19031442-0 84

I am trying to enable custom dimensions as fields in the Excel add-in for D365FO. When I check the lookup for these custom dimensions, the lookup is showing all dimension values together instead of filtering them for each specific custom dimension.

 

Has anyone faced this issue before? Is there a way to configure the lookup so that it shows filtered values for each custom dimension?

Categories:
Microsoft Dynamics AX
I have the same question (0)
  • Adis Profile Picture
    Adis 5,445 Super User 2025 Season 2 on at
    Enable Lookup for Custom Dimensions in Excel Add-in
    Hi,
     
    Sorry, I couldnt find the proper entity. Can you tell me the name\label entity data source in your excel- addin?
    Is it a custom entity or a standard one?
     
     
     
     

    Kind regards, Adis

     

    If this helped, please mark it as "Verified" for others facing the same issue

    Keep in mind that it is possible to mark more than one answer as verified

  • CU19031442-0 Profile Picture
    CU19031442-0 84 on at
    Enable Lookup for Custom Dimensions in Excel Add-in
    Hi @Adis Thank you for response
     
    Answering your question
     
    DimAttributeFinancialTagEntity  entity exposes all DimensionFinancialTag values regardless of which custom dimension we are trying to populate, which is why we are seeing all values together in the lookup.
  • Adis Profile Picture
    Adis 5,445 Super User 2025 Season 2 on at
    Enable Lookup for Custom Dimensions in Excel Add-in
    Hi,
     
    Could you show us the entity you are using in your excel add in as well as the field and the result ("showing all dimension values together").
     

    Kind regards, Adis

     

    If this helped, please mark it as "Verified" for others facing the same issue

    Keep in mind that it is possible to mark more than one answer as verified

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

News and Announcements

Dynamics 365 Community Calls Return
Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft
Responsible AI policies for the Community

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Andrés Arias – Community Spotlight

We are honored to recognize Andrés Arias as our Community Spotlight honoree for…

Congratulations to the August Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Sohaib Cheema Profile Picture

Sohaib Cheema 775 User Group Leader

#2
Martin Dráb Profile Picture

Martin Dráb 634 Most Valuable Professional

#3
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 622 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans