AX / D365FO – GROUPBY ON LOOKUP
This tutorial explores a custom lookup in a Query statement in Dynamics AX/D365FO. By utilizing GroupBy within the statement, data can be grouped in a meaningful way for the dashboard. However, when changing the selected value in the list, the GroupBy function is lost. To remedy this, simply use sysTableLookup.parmUseLookupValue(false) in the code to solve the issue. The tutorial provides a code sample showcasing how to use the function.
The post referenced in this summary for additional information can be found at https://sheriffayed23.blogspot.com/2023/04/ax-d365fo-groupby-on-lookup.html.
Published on:
Learn more
Related posts
LookUp Function
In this post, we explore the functionality of the LookUp function. LookUp is a powerful function within Power Apps that can help you retrieve ...
Create A Lookup Table From Subtotals: Optimization In Power BI
In this tutorial, you'll discover a technique in Power BI that allows you to create a lookup table from subtotals using the query editor. This...
Auto-populate contact lookup as current portal login user on record create from power page or portal using form Associated Table Reference configuration no code
If you need to create a Dataverse record that contains a lookup to a contact, you'll be interested in this article. The post explains how to u...
Automatically Open Lookup Screen and Restrict value selection to assign lookup Field in Power Apps
This post is a video tutorial that demonstrates how to automatically open the lookup screen and restrict value selection to assign lookup fiel...
How to Lookup Multiple Values in Excel: Step-By-Step
If you're struggling to find multiple values that match several conditions in Microsoft Excel, this step-by-step tutorial will guide you on ho...
Filter child lookup by parent lookup value in Power Pages Form
Check out this informative video on how to filter child lookup by parent lookup value in Power Pages Form. The video covers the following: - ...
Adding a Filter for Lookup Columns made Easier with Advanced Lookup
We are already aware of the Advanced Lookup feature that is available on any lookup column that’s on a quick create form, edit form, or ...
FILTER LOOKUP IN DYNAMICS 365 BASED ON CONDITION IN JAVASCRIPT WITH ADDCUSTOMFILTER AND ADDPRESEARCH
Working with lookups in Dynamics 365 can provide you with many possibilities to filter the records displayed in the lookup. While you can use ...
Filter lookup values by another lookup value in Dynamics 365 or Dataverse Power Apps form
In Dynamics 365 or Dataverse Forms, you can choose what items to display and selectable for a lookup field depending on another lookup. For ex...