Microsoft Dynamics 365 | Integration, Dataverse...

Sort columns on subgrid/views

(0) Share

Report

Posted on by Jerome Vicente

Hi, when sorting a subgrid ID by ascending then Name by ascending, I get this column:

+----------+-----------+
| Name | ID |
+----------+-----------+
| R1 | --- |
+----------+--------- --+
| R2 | --- |
+----------+-----------+
| R3 | --- |
+----------+-----------+
| R4 | 1 |
+----------+-----------+
| R5 | 2 |
+----------+-----------+
| R6 | 3 |
+----------+-----------+

I want to display on CRM this view instead:

+----------+-----------+
| Name | ID |
+----------+-----------+
| R4 | 1 |
+----------+-----------+
| R5 | 2 |
+----------+-----------+
| R6 | 3 |
+----------+-----------+
| R1 | --- |
+----------+-----------+
| R2 | --- |
+----------+-----------+
| R3 | --- |
+----------+-----------+

Is there any way to achieve this?

Thank you in advance

All responses (6)

Answers (0)

Suggested answer

LuHao 40,872 on at

Like (0)

Report

RE: Sort columns on subgrid/views

Hi Jerome,

When the records of the view are sorted by a column, the null value is always the smallest, that is, in ascending order, then the null value is always the first. This is by design and cannot be changed.

So to achieve this requirement, we have to fill the null value with 0. However, the value of the ID field is unique and cannot be repeated.

For this, we also need to create a custom field and use it to replace the ID field sorting. The value of this custom field is the same as the ID, the only difference is that it uses 0 instead of null. The calculated field can meet this requirement.

Here, I use the Account entity as an example.

Account has the Account Number field, I created a calculated field exactly like it.

Then, add the new field as a column to the view, and sort the view in ascending order by the new field.
Jerome Vicente 40 on at

Like (0)

Report

RE: Sort columns on subgrid/views

Hi Adrian,

Thank you for the answer but unfortunately, all records must be displayed as required.

Thanks,

Jerome
Suggested answer

Adrian Begovich 21,009 Super User 2024 Season 2 on at

Like (0)

Report

RE: Sort columns on subgrid/views

Hi Jerome Vicente,

There is no way to change the sort order so that it displays as desired. However, you can modify the filter criteria of the view to remove records with empty ID values.

+----------+-----------+
| Name | ID |
+----------+-----------+
| R4 | 1 |
+----------+-----------+
| R5 | 2 |
+----------+-----------+
| R6 | 3 |
+----------+-----------+
Community Member Microsoft Employee on at

Like (0)

Report

RE: Sort columns on subgrid/views

I believe that when you are sorting id ascending or any number field blanks will appear first followed by fields with information entered.
Jerome Vicente 40 on at

Like (0)

Report

RE: Sort columns on subgrid

Hi Andrew,

That is exactly what I did and both are in ascending order.

Thanks,

Jerome
a33ik 84,323 Most Valuable Professional on at

Like (1)

Report

RE: Sort columns on subgrid

Hello,

Set Sorting on the view by ID and then by Name. Do you have any issues with it?

Sort columns on subgrid/views

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Tips for Writing Effective Suggested Answers

Leaderboard

Featured topics

Product updates

Sort columns on subgrid/views

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Tips for Writing Effective Suggested Answers

Subscribe to

Leaderboard

Featured topics

Product updates