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 :
Finance | Project Operations, Human Resources, ...
Suggested Answer

Default Group by on grid datasource

(0) ShareShare
ReportReport
Posted on by 87

Hello,

I have a saved view on a form which by default is grouped on a certain column (Department). However, each time the user changes the department from a control on the same form, the query is executed again which then ungroups the column so then the user has to manually group it again. Any idea on how I can maintain the Group by even when the query datasource is executed again? Thank you.

pastedimage1659363034809v1.png

I have the same question (0)
  • Suggested answer
    huijij Profile Picture
    19,813 on at

    Hi,

    When you have made some changes you can see that the "standard view" has an asterisk "*" appended to it.This indicates that a change has been made and can be saved into the view again.If you refresh the form you will see that the sorting is still there.

  • Anthony90288 Profile Picture
    87 on at

    Hi Judy,

    Yes, I am fully aware about the asterisk that indicates a change has been made. My issue here is specifically maintaining the Grouping on a certain column when the user selects a value from a control which triggers the executequery of the datasource again and so the data is refreshed correctly but the column gets ungrouped.  Basically, I already have a saved view where the grid is grouped by Column A by default. I just want to maintain that grouping whenever the data is refreshed due to the user triggering the executequery method.

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 694

#2
André Arnaud de Calavon Profile Picture

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

#3
Subra Profile Picture

Subra 518

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans