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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / How can I get the drop...
Finance | Project Operations, Human Resources, ...
Answered

How can I get the dropdown for the dynamically added field in form

(2) ShareShare
ReportReport
Posted on by CU26060544-0 34
Hi,
 

Requirement:

In the ItemGroupId field, a dropdown should appear. When a particular item group is selected in the filter pane, the InventOnhandItem form should display the ItemGroupId along with all the item numbers that belong to the selected item group.

 

To achieve this, I have dragged and dropped the ItemGroupId field from the InventItemGroupItem table to the InventSum table by extending it. The field is now present in the filter pane, but the dropdown is not appearing for this field.

Categories:
Dynamics 365 Finance
I have the same question (0)
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 239,451 Most Valuable Professional on at
    Moved from Integration, Dataverse, and general topics forum to Finance | Project Operations, Human Resources, AX, GP, SL forum.
     
    For reference, this seems to be closely related to a previous thread, Additional column to improve filtering functionality on the On-Hand screen.
     
    If I understand it correctly, the title is wrong, because it's not about a dynamically added field. You said you actually extended the table.
     
    We could discuss how you added the field and what's wrong with your implementation, but actually, you shouldn't be adding a new field to InventSum at all. There are a several reasons:
    1. You shouldn't add fields to InventSum table if not necessary. It's a performance-critical table and you really don't want to slow things down there.
    2. You shouldn't duplicate data if not necessary.
    3. Creating a field doesn't populate it with data. You'd need to code to initialize the value for new records and update existing records.
    4. The whole thing isn't necessary - you can use a join to get data from InventItemGroupItem table.
    5. InventItemGroupItem table already has the correct relation to InventItemGroup table, so you don't have to develop it by yourself (which is what you failed to do).
  • Suggested answer
    CU26060544-0 Profile Picture
    CU26060544-0 34 on at
    Thanks, Martin. It's working. When I select a particular item group from the filter pane dropdown and click the Apply button, all the fields in the InventOnHandItem form should auto-fill.
     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the April Top 10 Community Leaders

These are the community rock stars!

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

#1
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 608

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 591 Super User 2026 Season 1

#3
CP04-islander Profile Picture

CP04-islander 430

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP
License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans