Others

How to Choose Between Dataverse Standard and Custom Tables

Kushani NimanthikaKushani Nimanthika Oct 13, 2026 869 views

Question details

The user wants to understand the differences between standard and custom tables in Dataverse, when to use each, and how to verify if a specific table was created by Dynamics 365 or an installed add-on.

How to Choose Between Dataverse Standard and Custom Tables
Product
Microsoft Dataverse
Device & OS
not provided
Scenario
Deciding whether to use an existing standard table or create a new custom table to organize business data efficiently without reinventing the wheel.
Observed behavior
Users need clarification on identifying table types via logical names and prefixes, and locating the source of tables like Functional Locations.
Before you start

Ensure you have the necessary System Administrator or System Customizer security roles in your Power Apps or Dynamics 365 environment to view table properties and inspect installed solutions.

Solution 1Recommended

Identify and Choose Between Standard and Custom Tables

Understand the defining characteristics of standard and custom tables to make the best structural choice for your business data.

Standard tables are created by default with the Dataverse database and cover common business concepts like Account, Contact, and User. Custom tables are added manually later to address specific organizational requirements that standard tables cannot fulfill.

1
Evaluate existing standard tables

Always check if a standard table (such as the default Address table) meets your requirements before building a new one. Reusing standard tables prevents duplicating efforts and ensures better integration with Microsoft apps.

2
Check the logical name for prefixes

In the Power Apps portal, view the table's properties. Standard tables use default logical names (e.g., 'account'), whereas custom tables use an organization publisher prefix (e.g., 'new_account' or 'cra_account').

3
Customize existing standard tables

If a standard table is close to what you need, you can often customize and extend it by adding new columns, relationships, and views rather than starting from scratch.

Identify and Choose Between Standard and Custom Tables
Best Practice: Whenever possible, utilize and extend standard tables. This ensures seamless compatibility with future Dynamics 365 updates and built-in features.
Free Microsoft Office alternative

Manage Your Data Exports and Reports with WPS Office

While working with Microsoft Dataverse and Dynamics 365, you frequently need to handle exported data, build reports, and create documentation. WPS Office provides a free, lightweight, and highly compatible alternative to Microsoft Office, ensuring smooth transitions for all your business tasks.

  1. 1. Download the installer: Visit the official WPS Office website and click the Free Download button for your operating system.
  2. 2. Install WPS Office: Run the installer and follow the on-screen instructions to set up the software on your device.
  3. 3. Open your exported data: Launch WPS Spreadsheets to seamlessly open and analyze the CSV or Excel files exported from Dataverse.
Fully compatible with Microsoft Excel (.xlsx) formats for analyzing Dataverse exports.Lightweight design ensures fast loading times even for large datasets and reports.Familiar user interface makes transitioning from Microsoft Office effortless.Free built-in PDF tools for securely sharing your business data reports.
microsoft office alternative - wps office

Frequently Asked Questions

Can I convert a custom table into a standard table in Dataverse?

No, once a table is created as a custom table, it permanently retains its custom status and publisher prefix. If you decide a standard table is a better fit later, you will need to migrate your data from the custom table to the standard one.

Why is it better to use standard tables instead of creating custom ones?

Standard tables are deeply integrated into Dynamics 365 applications and often come with built-in business logic, default relationships, and out-of-the-box features. Reusing them prevents data duplication and simplifies long-term maintenance.

Where can I find the logical name of a Dataverse table?

You can find the logical name by navigating to the Power Apps maker portal, clicking on 'Tables' in the left pane, selecting your specific table, and viewing its details under the table properties section.