分享方式：

編輯表格

  • 文章

您可以編輯任何您所建立的自訂資料表。 標準資料表或受管理的自訂資料表可能有可進行的變更相關之限制。

您可以對資料表執行下列編輯動作：

您也可以變更支援資料表之資料列：

備註

標準資料表是隨附於環境但不是系統或自訂資料表的一般資料表。 受管理的自訂資料表是透過匯入受管理的解決方案而加入至系統的資料表。 您可以編輯這些資料表的程度由為每個資料表設定的受管理的屬性決定。 無法編輯的所有屬性將會停用。

使用 Power Apps 編輯資料表屬性

在 Power Apps 中，選取解決方案，打開您想要的未受管理的解決方案，然後選取您要編輯的資料表。 若要修改資料表屬性，請選取命令列上的設定以檢視編輯資料表窗格，如下所示：

編輯資料表屬性。

如需可編輯之屬性的描述，請建立資料表。

備註

一旦啟用，就不能變更所有的資料表屬性。 其他資訊：只能啟用的資料表選項

標準資料表名稱也可以用於應用程式中的其他文字。 若要找出並變更使用這個名稱的文字，請參閱編輯標準資料表訊息

使用方案總管編輯資料表

使用方案總管編輯資料表時，您需要找到您要將資料表新增到的未受管理的解決方案。

Open an unmanaged solution

  1. From Power Apps select Solutions from the left navigation pane, and then on the toolbar, select Switch to classic. If the item isn’t in the side panel pane, select …More and then select the item you want.

  2. In the All Solutions list open the unmanaged solution you want.

變更資料表的名稱

使用顯示名稱和複數名稱屬性來變更應用程式中的資料表名稱。

備註

標準資料表名稱也可以用於應用程式中的其他文字。 若要找出並變更使用這個名稱的文字，請參閱編輯標準資料表訊息

變更用於自訂資料表的圖示

根據預設，Web 應用程式中的所有自訂資料表都有相同的圖示。 您可以為您想要的自訂資料表圖示建立影像 Web 資源。 其他資訊：變更自訂資料表的圖示。

只能啟用的資料表選項

下表列出可啟用的資料表選項，不過，這些項目在啟用之後就無法停用：

Option Description
Activities Associate activities to records for this table.
Business process flows Create business process flows for this table. More information: Create a business process flow to standardize processes
Connections Use the connections feature to show how records for this table have connections to records of other tables that also have connections enabled.
Feedback Let customers write feedback for any table record, or rate table records within a defined rating range. More information: Enable a table for feedback/ratings
Notes Append notes to records for this table. Notes include the ability to add attachments.
Queues Use the table with queues. Queues improve routing and sharing of work by making records for this table available in a central place that everyone can access.
Sending email Send emails using an email address stored in one of the fields for this table. If a Single Line of Text field with format set to email doesn’t already exist for this table, a new one will be created when you enable sending email.

啟用或停用資料表選項

下表列出您可以隨時啟用或停用的資料表選項。

Option Description
Access Teams Create team templates for this table.
Allow quick create After you create and publish a Quick Create Form for this table, people can create a new record using the Create button in the navigation pane. More information: Create and design forms

When quick create is enabled for a custom activity table, the custom activity is visible in the group of activity tables when people use the Create button in the navigation pane. However, because activities don't support quick create forms, the main form is used when the custom table icon is clicked.
Areas that display this table In the web application, choose one of the available sitemap areas to display this table. This setting doesn't apply to model-driven apps.
Auditing When auditing is enabled for your organization. Auditing allows for changes to table records to be captured over time. When you enable auditing for a table, auditing is also enabled on all its fields. You can select or clear fields that you want to enable auditing on.
Change Tracking Enables data synchronization in a performant way by detecting what data changed since the data was initially extracted or last synchronized.
Color Set a color to be used for the table in model-driven apps.
Description Provide a meaningful description of the purpose of the table.
Document management After other tasks are performed to enable document management for your organization, enabling this feature allows for this table to participate in integration with SharePoint.
Duplicate Detection If duplicate detection is enabled for your organization, enabling duplicate detection allows you to create duplicate detection rules for this table.
Enable for mobile Make this table available to the Dynamics 365 for phones and tablets apps. You can also make this table Read-only in mobile.

If the forms for a table require an extension not supported in Dynamics 365 for phones and tablets apps, use this setting to ensure that mobile app users can't edit the data for these tables.
Enable for phone express Make this table available to the Dynamics 365 for phones app.
Mail merge People can use this table with mail merge.
Offline capability for Dynamics 365 for Outlook Whether data in this table is available while the Dynamics 365 for Outlook application isn't connected to the network.
Primary Image System tables that support images already have an Image field. You can choose whether to display data in this field as the image for the record by setting this field to [None] or Default Image.

For custom tables, you must first create an image field. After you create one, you can change this setting to set the primary image. More information: Image columns
Reading pane in Dynamics 365 for Outlook Whether the table is visible in the reading pane for the Dynamics 365 for Outlook app.
Use custom Help When enabled, set a Help URL to control what page users see when they select the help button in the application. Use custom help to provide guidance specific to your company processes for the table.

請參閱

建立資料表
使用方案總管建立和編輯資料表