Loading...

AX / D365FO – GROUPBY ON LOOKUP

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
Sherif Fayed
Sherif Fayed

Share post:

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 ...

1 year ago

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...

2 months ago

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...

7 months ago

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...

1 year ago

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...

1 year ago

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: - ...

1 year ago

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 ...

1 year ago

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 ...

1 year ago

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...

1 year ago
Stay up to date with latest Microsoft Dynamics 365 and Power Platform news!
* Yes, I agree to the privacy policy