Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Get table buffer of records in the Display Method that is currently in the Grid after filter(s) is applied

(0) ShareShare
ReportReport
Posted on by 65

Hi all,

I need suggestions regarding this scenario that how can I solve it.

Let's say my table "Student" has four entries: 

NAME Age
A 2
B 3
C 7
D 6



Now when I apply filter to age column such that only students that have ages less than 4 are shown. ( in this example the rows will then be 2 )

So, what I want is to get the table buffer of Student in the display method that has only these two rows or generally speaking table rows after the filters have been applied.

Any help will be great.

Thanks.

  • ergun sahin Profile Picture
    8,816 Moderator on at
    RE: Get table buffer of records in the Display Method that is currently in the Grid after filter(s) is applied

    Write a simple select clause.

    while select student
        where student.Age < 4
        {
        }

    I don't understand exactly what you are trying to do.
    Let's break it up a little. The problem seems to have nothing to do with the display method. (Display method to show the processed data to the user.)
    I think your problem is about getting the data you want.
    If you can tell us what you are doing and at what point you have difficulties, we can help you more easily.

  • OsamaAG Profile Picture
    65 on at
    RE: Get table buffer of records in the Display Method that is currently in the Grid after filter(s) is applied

    No No I don't want to show the whole table in the single field. I just want the table buffer in the display method after the filters are applied.

  • ergun sahin Profile Picture
    8,816 Moderator on at
    RE: Get table buffer of records in the Display Method that is currently in the Grid after filter(s) is applied

    I don't get it, it's not possible to show a table in a single field.

    If the purpose is to show names with separators, it is of course possible (like A-B).

    Or you can write something like "A/2-B/3" in the new field, as long as the length isn't an issue.

  • OsamaAG Profile Picture
    65 on at
    RE: Get table buffer of records in the Display Method that is currently in the Grid after filter(s) is applied

    Thanks ergun sahin for reply.

    No I am not trying to create a lookup. I am trying to add a field in my grid through display method.

    In my scenario, I want the grid's rows in the display method after the filter is applied.

    I hope it clears a bit.

  • ergun sahin Profile Picture
    8,816 Moderator on at
    RE: Get table buffer of records in the Display Method that is currently in the Grid after filter(s) is applied

    If I'm not wrong, you want to create a lookup with a range

    If it is a custom form, it is no different from 2012, you can use the example below.

    docs.microsoft.com/.../how-to-add-a-lookup-form-to-a-control

    If you are going to write to system forms or a form in a different model, the code is still the same but the location is different (you need to use extension)

    msdynamics.nevoitech.com/.../

  • OsamaAG Profile Picture
    65 on at
    RE: Get table buffer of records in the Display Method that is currently in the Grid after filter(s) is applied

    In D365 I am trying to add a column to a grid in the form and for that using display method.

  • Ludwig Reinhard Profile Picture
    Microsoft Employee on at
    RE: Get table buffer of records in the Display Method that is currently in the Grid after filter(s) is applied

    Hi,

    Is this for a modification of a form/table/grid that you make in AX2012/D365 or for a PowerApp that you embed in D365?

    Would be great if you could provide some additional information.

    Many thanks,

    Ludwig

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,208 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,970 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans