Now that Smart Grids are in public preview via model-driven apps views, users can rapidly locate, filter, and sort their data using natural language instead of complex advanced filters. By using AI, the functionality streamlines data administration and enhances user experience by turning grid views into a smooth interface for immediate responses, locating records and starting actions on your data.

In Power Apps model-driven apps (including Dynamics 365 apps), you may now ask queries about data using natural language when utilizing the main grid view. Requesting “Task with high priority with pending follow-up after the specified date,” for instance, will limit your screen to just see those pertinent cases.


The following features are supported:
• Filtering of record
• Sorting
• Text search


The following capabilities aren’t supported:
• Query aggregation
• Query grouping
• Adding columns


Things to Think About
Check the generated filter tags after running a query to make sure your natural language query’s filter criteria were successfully interpreted. If any portion of your query is absent from the filter tags, that condition did not filter the results.
In the event that Copilot fails to yield the intended results, think about changing your query by:
• Using the names of the data columns as they appear in the grid header
• Using commas or periods to separate several conditions
• A text search will be conducted using search strings that contain two words or fewer (prior functionality).
• Use more than two terms when conducting a Copilot search. Put the search string in single or double quotations to do a text search for more than two words.

In conclusion, the introduction of Smart Grids in public preview for model-driven apps marks a significant advancement in how users interact with and manage their data. By leveraging natural language queries, users can now filter, sort, and search through grid data with ease, eliminating the need for complex manual filtering. This functionality enhances the user experience, making it more intuitive and efficient, especially for those who need to quickly locate and take action on records.


Please take note that this is a preview feature that will be enhanced with every weekly update.

Thank you, Arvind Khadye for your valuable inputs to this blog!

Leave a comment