Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Lookup for Table IDs
Finance forum

Lookup for Table IDs

(0) ShareShare
ReportReport
Posted on by 20

Hello,

 I'm trying to create a lookup for all Tables from a custom field. I tried creating a SysTableLookup with the datasource being SysModelElement on the onLookup() event of the field on a form. Even without adding any range to the ElementType field on the table, the lookup does not show any data.

DefaultTableLookup.JPG

When I try to open Table Browser from the Application Explorer's System tables for SysModelElement, it shows no data. I tried going to the DAT company to see if it shows there, but it doesn't. 

Any ideas on how to look up Table IDs from a custom field in D365 F&O, please?

Thanks.

  • Charan Bhamidi Profile Picture
    20 on at
    RE: Lookup for Table IDs

    Thanks. I decided to use SqlDictionary table instead, since I only need tables and not all the other objects. SqlDictionary table still has the table and field information, so it works for now. Thanks again.

  • Verified answer
    Eugen Glasow Profile Picture
    6,357 on at
    RE: Lookup for Table IDs

    You are trying to use an obsolete API.

    community.dynamics.com/.../176773

    community.dynamics.com/.../new-metadata-api

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 293,209 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,923 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156 Moderator

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans