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

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Field not appearing in field picker when accessing a table via the Excel Add-in

(0) ShareShare
ReportReport
Posted on by 2,007

I have searched the Internet in an attempt to not have to post this, but none of the solutions I have seen have worked, so I am wondering if anyone has any other suggestions.

I have a custom table with two fields. Both fields are 64 bit integer fields. Originally, one field had a label and the other did not. The field with label appears in the field picker when we access the field via the Excel Add-in, the one that did not doesn't. After searching this forum, we added a label to the missing field as the post indicated this would resolve the issue. It didn't. 

I then followed the advice to run a full CIL build, clear caches, refresh AIF services and redeploy the AIFGDS service group. This also did not resolve the issue.

An examination of the properties of both fields show that apart from the initial state of not having a label, these two fields have identical properties. The only other difference is that the table has a field relationship defined for the field that appears and the one that is missing does not.

Does anyone have any other suggestions of how we can make the missing field appear?

*This post is locked for comments

I have the same question (0)
  • Brandt Fundak Profile Picture
    2,007 on at
    RE: Field not appearing in field picker when accessing a table via the Excel Add-in

    Martin,

    This was precisely the issue. The table is essentially a bridge between two other tables. Once I added the second table relationship, they were able to see the fields they were looking for.

    Thanks for the response.

  • Verified answer
    Martin Dráb Profile Picture
    236,204 Most Valuable Professional on at
    RE: Field not appearing in field picker when accessing a table via the Excel Add-in

    What does the field represent? Isn't it actually a reference to RecId of another field (and the missing relationship prevents AX from expanding the foreign key to the natural key of the referenced table)?

  • Otavio Anaga Profile Picture
    216 on at
    RE: Field not appearing in field picker when accessing a table via the Excel Add-in

    You can try to create an identical table to see if when you do all the steps from the start, the things works fine.

    When you cleaned the caches, did you deleted the .AUC e .KTI files? this is an important step when you have problems like this

    let me know if it worked!

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

Responsible AI policies

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

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Guy Terry Profile Picture

Guy Terry 2 Moderator

#1
Martin Dráb Profile Picture

Martin Dráb 2 Most Valuable Professional

#1
Community Member Profile Picture

Community Member 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans