AMS Grid for Dynamics 365
The Dynamics 365 grid. But better
Why is working with data in Dynamics so painful?
- Filters reset
- Lists jump to the top
- Paging is clunky
- Grouping loses detail
- Editing takes forever
AMS Grid fixes all of it, bringing Excel-like power directly into Dynamics 365.
Introducing
AMS Grid for Dynamics 365 and Power Apps
All your favourite features of Excel, now in Dynamics
Find and filter your records faster than ever
Build lists of records, or quotes in no time
Chart and analyse data instantly
All on one page - no reloading
"The solution has significantly improved our workflow for inputting and reviewing data, providing user-friendly data viewing compared to the standard view.”
Omotola Olufemi
Analyst
Impact Global Health
How does AMS Grid make Dynamics 365 faster?
It’s like Excel for Dynamics. No need to integrate Excel separately
Inline editing
Fill down columns
Just like in Excel you can fill down. A huge timesaver
Instant filtering
With grouping and sorting – no performance loss.
Just type and see immediate results
Fast charting
Easy data analysis in Dynamics! No complex set up.
Just select some data, choose a chart type and you’re done!
Drag and drop ordering
Both rows and columns
Multiple sorting levels
Pivot Tables - in Dynamics!
No need to export to Excel to create a pivot table in Dynamics 365.
All the features you’d expect from a pivot table. Sorting, filtering, aggregation, rage select and more
Multiple grouping levels at an instant
Make your data look great
Use custom icons for a better user experience
It even works quickly with huge data sets. Try it.
No more exporting to Excel
- Charting and analysis is done instantly in Dynamics
- Edits and reorders are immediately saved in the database.
- Easy copy / paste to Excel
Speedy data analysis
- Select a range and produce a chart instantly
- The flexibility of PowerBI, all within your CRM
- Run complex pivots, all without leaving Dynamics / Power Apps
Lightning fast list building
- Fast - easily handles 10,000+ records all from one screen
- Search and filtering tailored to your business - no superfluous extras to get in the way
- Stay on one screen. no reloading pages
Pricing
AMS Grid Starter
- 1 subgrid
- 5 grid fields
AMS Grid Standard
- 1 subgrid with up to 5 fields
- 1 editable optionset
- 1 editable lookup
- 1 editable date field
- 1 editable text field
- 1 editable number field
- drag and drop rows
AMS Grid Premium
- 1 subgrid with up to 10 fields
- 2 editable optionsets
- 2 editable lookups
- 2 editable date fields
- 2 editable text fields
- 2 editable number fields
- 1 frozen pane
- drag and drop rows
These prices are for our common bundled packages. Sometimes, you’ll find it better to get a bespoke package
Pricing includes licencing, development and support / updates.
Please call for details 01422 824831
What Is AMS Grid?
AMS Grid replaces the standard lists and views in Dynamics 365 & Power Apps with something that actually works the way you’d expect.
You can edit, filter, sort and update your data right there on screen, without the frustrations that come with the built-in options.
Slow grids and lists
Slow Dynamics 365 lists are one of the biggest complaints we hear. The standard Dynamics 365 grid is slow, especially with large data sets. Editable grids are even slower. Pages take time to load, scrolling is clunky, and data entry slows to a crawl.
AMS Grid loads thousands of records on a single screen with no paging, no lag, and no waiting around. If Dynamics 365 data entry is slow for your team, this is the fix.
Bulk editing and updating records
Need to bulk edit Dynamics 365 data? The native tools make it harder than it should be. Editing multiple records means opening each one individually, or exporting to Excel and re-importing.
With AMS Grid you can bulk update records directly in the grid. Edit multiple records at once using inline editing, fill down columns, and save everything back to Dynamics in real time. No export. No re-import. No waiting.
The data is saved using the same process as a regular grid, so business rules and workflows are honoured
Editable grid problems in Dynamics 365
The standard Dynamics 365 editable grid has well-known problems. Grids not saving. Changes lost when you navigate away. Subgrid problems where data doesn’t refresh properly. Grouping that strips out detail.
AMS Grid solves all of this. Edits save immediately for all users. Your scroll position, filters and grouping stay exactly where you left them. And sub-grids in Dynamics 365 work just as smoothly as the main grid.
Hard to edit records?
If your team finds Dynamics 365 records hard to edit, or if data entry feels like a chore, AMS Grid changes the experience completely. Lookups, text, numbers, dates and currency fields can all be edited in place. No opening individual records. No clicking through multiple screens.
Customising your Dynamics views
Want to customise Dynamics views without needing a developer? AMS Grid lets users save their own column layouts, groupings, and filters. It gives your team the flexibility to build the data lists they actually need, not just the ones an admin configured months ago.
And if you’ve been looking at building a custom Dynamics JavaScript grid, AMS Grid does it out of the box, with no code required.
Better data management for Microsoft Dynamics 365 and Power Apps
Want to take a look?
Or call us on
01422 824831
hello@allmysystems.co.uk
What people has asked us
- Building task or activity lists
- Building orders from product lists
- Building quotes (see AMS Rapid Quote)
- Searching and editing contact lists
Yes. This is not only a fast way of viewing data, it also saves your data changes for all users. Expect to find big time savings on repeated tasks.
Yes. Your data doesn’t leave Dynamics, so it remains safe in the Microsoft Azure cloud
Yes. Your security role is respected and your access to data is exactly the same as you’d expect from the normal use of Dynamics
Yes, you can save the charts as images files (PNGs)
It’s easy, just contact us and we’ll do the rest. The system is modular, so we’ll make sure you only install what you need.
No, you can pick and choose which entities you display AMS grid on.
Yes. When you close the record, your filters, grouping and scroll position stay exactly as they were.
Yes. Just drag items up or down. The new order is saved automatically.
Yes. Lookups, text, numbers, dates, currency and yes/no fields can all be edited in place.
Yes. Type straight into any column header to filter instantly.
Yes. You can save your own column order and restore it whenever you like.
No. The grid keeps your place when you return.
Yes. A preview panel or pop‑up can be added as an extra configuration option.
Yes. You can export full datasets or selected ranges to Excel or CSV.
Bulk add is included. Full CSV import can be added if needed.
Yes, the solution is actively updated to work with the most recent versions of Dynamics. We also support you in using the product
Yes, these fields are supported by AMS Grid
At the entity level, edits to data will trigger business rules, workflows and Power Automate flows.
Any form-level rules or flows will not be triggered
Why All My Systems?
Because software alone doesn’t transform a business – people do.
We’re a UK-based Microsoft partner helping organisations like yours simplify operations, empower teams and delight customers.
We’ve seen what happens when a great business system meets a team that truly cares. The result? Growth that sticks.
Find out how to speed up your data work in Dynamics 365
Or call us to book on 01422 824831
email: hello@allmysystems.co.uk