Dynamics Community Forum Thread Details

Filter Pane Applied, But How to Fetch Filtered Data in InventOnHandItem?

Hello Community,

I have added the Item Group (ItemGroupId) field to the filter pane on the InventOnHandItem form. Currently, the ItemGroupId field is visible in the filter pane dropdown, and I am displaying the Item Group using a display method in the form extension.

However, the issue is that when I select an Item Group (e.g., Audio) in the filter pane, the grid does not filter the items accordingly. My goal is to have the main grid on the form display only the items that belong to the selected Item Group.

To achieve this, I initially used a display method to show the ItemGroupId, but I now understand that this might not support filtering. I also tried adding the InventItemGroupItem table to the form query and used it as a data source, but the filtering still does not work as expected.

I would appreciate any guidance or best practice recommendations on how to properly filter the main grid based on the Item Group selected in the filter pane.

Thank you in advance for your support.

Best regards,

Roja C

Let me know if you'd like me to also write a version tailored for Microsoft forums or internal team emails.

Do you like this personality?