Check our Case Studies for examples of how we've helped various companies realise the benefits of Customer Engagement...
Setting A View's Default Sort Order Using More Than 2 Columns
One limitation of views in Dynamics 365 for Customer Engagement has always been that you can only set a maximum of 2 columns in the default sort order for a system view:
With the new solutions module in PowerApps, this is no longer a limitation.
Go to https://powerapps.microsoft.com/ and sign in using your normal Office 365 credentials.
Alternatively, click on the app selector (commonly known as the ‘waffle’ and pick the PowerApps option:
Make sure you are in the correct environment:
I’m just using the Default Solution here, but you could create your own or use an existing one.
Open the solution and find the entity you want to create a view for using the filter and search box. I’m doing a view for Accounts:
Open the entity by clicking on it:
Select ‘Views’ and ‘Add view’:
Give it a name and an optional description:
Add your columns by selecting the fields from the list. Once done, on the RHS, select the ‘Sort By’:
Then simply add the columns you want to sort by, primary sort first:
You can change the column ascending/descending by clicking the arrow:
You even get a nice preview of your records sorted in the order you have set:
Save and publish:
And back in Dynamics 365 you can see the view, sorted by 3 columns:
I’m not sure if there is a limit for the number of columns you can set a default sort order for. Perhaps you could try and blog about it!
One limitation of this is that it only applies to System views. Personal views are still limited by the 2 column sort limit.
Happy CRMing everyone!
Book a meeting with us to learn more.
OA Systems did a brilliant job of updating our Microsoft CRM4.0 to Dynamics 365. The process was smooth from start to finish and they completed on time and on budget.Brendon Reid, Managing Director, Automation Associates Ltd
The OA Systems development team has a really detailed understanding of every layer of our businessAyla Hutton, Technology and Projects Manager at Safety ‘n Action
Level 1/95 Ascot Avenue
We are always looking for people who are excellent and passionate at what they do to join our team. If this sounds like you then we'd love to hear from you!