Field groups provide a way to group one or more fields of an entity. Field groups can help speed up and simplify the creation and maintenance of apps. A field group contains one or more fields and a field can appear in any number of field groups. A field cannot appear more than once in a field group.

Field groups are stored on an entity and are shared across all apps that use the same entity. At any given time there may be many different apps using the same entity and field groups of that entity. This centralization and sharing of field groups helps enforce consistency, because a field group will always display the same fields wherever it's used. This makes maintenance easy because a change to a field group is automatically reflected in all the places using that field group. Field groups help speed up the app authoring and customization process because an application author works with groups of fields, rather than individual fields.

Default field groups

Common Data Service includes several default field groups on entities. These field groups are used in various places to help speed up and ease app creation and customization.

Default field group name Description
DefaultDetails Used to display the details of a single record in view and edit.
DefaultLookup Used to display a lookup to select a record.

View a field group

  1. On powerapps.com, expand the Common Data Service section and click or tap Entities in the left navigation pane.
  2. If you have access to more than one database, ensure that you have the right database selected using the drop down above the list of entities.
  3. In the list of entities, click or tap the entity that you want to view the field group for.
  4. In the header above the list of fields, click or tap Field groups. You now see all the field groups that currently exist for the entity.
  5. In the list of field groups, click or tap the field group that you want to view the details for.
  6. In the field group details there are two lists side-by-side. One is titled Entity fields and lists all the fields for the entity. The other is titled Field group fields and lists the fields included in the field group.

Modify a field group

  1. View the field group that you want to modify.
  2. To add a field, double-click a field name in the Entity fields list. You can also drag and drop fields from the Entity fields list to the Field group fields list.
  3. To remove a field group, click the X next to the field name in the Field group fields list.
  4. Click or tap the Save button.

Create a field group

  1. On powerapps.com, expand the Common Data Service section, and click or tap Entities in the left navigation pane.
  2. If you have access to more than one database, ensure that you have the correct database selected using the drop down above the list of entities.
  3. In the list of entities, click the entity that you want to view the field group for.
  4. In the header above the list of fields, click or tap Field groups.
  5. At the top of the screen, click or tap the New field group action.
  6. Provide a name, display name, and description for the field group, and click or tap Next.
  7. Modify the field group, and click or tap Save.

Delete a field group

Deleting a field group is not supported.

View and edit field group data in Microsoft Excel

  1. View the field groups for the entity that you want to examine the data for.
  2. There is an Excel icon next to each field group. The Excel icon will only be enabled if the field group has fields.
  3. Click the Excel icon for the field group that you want to open in Excel. A workbook is generated containing the entity field list, the Excel Add-in, and a pointer to your environment.
  4. Open the generated workbook that is provided by the browser.
  5. After the workbook is open, enable editing. The Excel Add-in will then read the data into the workbook. For more information, see Open entity data in Excel.

Lookup and app generation with field groups

The default field groups help to speed up application authoring and customization. Some places where you can currently see field groups in action are:

  • Lookup control - If one of the fields that you add on your screen is a reference to another linked entity, the field is rendered as a lookup control (picklist). When a user clicks the lookup control to select a record from the linked entity, the fields displayed are determined by the DefaultLookup field group on the linked entity. Only the first two fields of the DefaultLookup field group are used.

  • Creating an app - When you generate an app by choosing the option to create an app from data, the screens for the entity that you select are automatically created. The Display Form control on the Display screen and the Edit Form control on the Edit screen use the DefaultDetails field group to determine which fields will be added by default to those screens.