可委派的資料來源Delegable data sources

如同了解委派一文中詳述,委派是指 PowerApps 將資料的處理委派給資料來源,而非將資料移至應用程式以在本機處理。As outlined in detail in the Understand delegation article, delegation is where PowerApps will delegate the processing of data to the data source rather than moving data to the app for processing locally.

僅有表格式資料來源支援委派。Delegation is supported for tabular data sources only. 這份清單可識別表格式資料來源,以及它們是否支援委派,詳細說明請見下一節。This list identifies tabular data sources and whether they support delegation, with details in the next section.

  • Common Data Service - Common Data Service - Yes
  • SharePoint - SharePoint - Yes
  • SQL Server - SQL Server - Yes
  • Dynamics 365 - Dynamics 365 - Yes
  • Salesforce - Salesforce - Yes
  • Excel - 即將支援Excel - Coming soon
  • 營運用 Dynamics 365 - 尚未支援Dynamics 365 for Operations - Not yet
  • 財務用 Dynamics 365 - 尚未支援Dynamics 365 for Financials - Not yet
  • Dynamics NAV - 尚未支援Dynamics NAV - Not yet
  • Google 試算表 - 尚未支援Google Sheets - Not yet

我們將持續新增更多的表格式資料來源及其委派支援。More tabular data sources and delegation support for them are being added continuously.

本文件列出每個資料來源其支援委派的目前狀態。This document lists the current state of supported delegation per data source.

必要條件Prerequisites

資料來源和支援委派的清單List of data sources and supported delegation

這份包含資源來源及可委派函式和述詞的清單會定期更新,以反映 PowerApps 中委派支援的目前狀態。This list of data sources and delegable functions and predicates will be updated periodically to reflect the current status of delegation support in PowerApps.

最上層的可委派函式Top-level delegable functions

  Common Data ServiceCommon Data Service SharePointSharePoint SQL ServerSQL Server Dynamics 365Dynamics 365 SalesforceSalesforce
AverageAverage No No Yes No No
篩選Filter Yes Yes Yes Yes Yes
LookUpLookUp Yes Yes Yes Yes Yes
最大值Max No No Yes No No
MinMin No No Yes No No
搜尋Search 1Yes1 No Yes Yes Yes
排序Sort Yes Yes Yes Yes Yes
SortByColumnsSortByColumns Yes Yes Yes Yes Yes
SumSum No No Yes No No

1僅適用於字串欄位1For string fields only

Filter 與 LookUp 可委派述詞Filter and LookUp delegable predicates

  Common Data ServiceCommon Data Service SharePointSharePoint SQL ServerSQL Server Dynamics 365Dynamics 365 SalesforceSalesforce
NotNot Yes No Yes Yes Yes
IsBlankIsBlank No No Yes Yes No
TrimEndsTrimEnds No No Yes No No
LenLen No No Yes No No
+、-+, - No No Yes No No
<、<=、=、<>、>、>=<, <=, =, <>, >, >= Yes 是 (僅 =)Yes (only =) Yes Yes Yes
And (&&)、Or (||)、Not (!)And (&&), Or (||), Not (!) 2Yes2 是 (Not(!) 除外)Yes (except Not(!)) Yes Yes Yes
inin No No Yes No Yes
StartsWithStartsWith No Yes No No No

2僅適用於運算子。2For operators only. And/Or/Not 函式未委派。And/Or/Not function not delegated.