PowerApps 連接器概觀Overview of connectors for PowerApps

資料是絕大多數應用程式的核心,您在 PowerApps 中建置的應用程式也是如此。Data is at the core of most apps, including those you build in PowerApps. 資料會儲存在「資料來源」中,藉由建立「連線」即可將該資料帶入應用程式。Data is stored in a data source, and you bring that data into your app by creating a connection. 連線會使用特定的「連接器」與資料來源通訊。The connection uses a specific connector to talk to the data source. PowerApps 擁有的連接器適用於許多熱門服務和內部部署資料來源,包括 SharePoint、SQL Server、Office 365、Salesforce 和 Twitter 等。PowerApps has connectors for many popular services and on-premises data sources, including SharePoint, SQL Server, Office 365, Salesforce, Twitter, and more. 若要開始在應用程式中新增資料,請參閱在 PowerApps 中新增資料連線To get started adding data to an app, see Add a data connection in PowerApps.

下表中的連結可提供最熱門連接器的詳細資訊。The following table has links to more information about our most popular connectors. 如需連接器的完整清單,請參閱所有連接器For a complete list of connectors, see All connectors.

         
Common Data Service Common Data ServiceCommon Data Service   Office 365 Outlook Office 365 OutlookOffice 365 Outlook
SharePoint SharePointSharePoint   Excel ExcelExcel
SQL Server SQL ServerSQL Server   商務用 OneDrive 商務用 OneDriveOneDrive for Business
Dynamics 365 Dynamics 365Dynamics 365   OneDrive OneDriveOneDrive
Office 365 Users Office 365 UsersOffice 365 Users   Dropbox DropboxDropbox

連接器類型Types of connectors

PowerApps 有兩種連接器:標準連接器 (如上述連接器) 和自訂連接器PowerApps has two types of connectors: standard connectors like the ones listed above, and custom connectors. 如果您使用標準連接器連線到 PowerApps 所支援的資料來源,請使用該連接器即可。If you're connecting to a data source that PowerApps supports with a standard connector, use that connector. 如果您需要連線到其他來源,例如您所建置的服務,請參閱註冊及使用自訂連接器If you need to connect to another source, like a service that you've built, see Register and use custom connectors.

根據所連線的資料來源類型以及該資料來源傳回資料的方式,標準連接器會有不同的行為:Standard connectors behave differently depending on the type of data source they connect to and how data is returned by that data source:

  • 某些連接器可使用表格式資料來源,例如 SharePoint、SQL Server 和 Excel。Some connectors work with tabular data sources, such as SharePoint, SQL Server, and Excel. 若使用這些資料來源,資料會以資料表形式傳回給 PowerApps。When working with these data sources, data is returned to PowerApps as a table. PowerApps 會使用自己的函式 (例如 Patch()Collect()Update() 等等) 來與資料互動。PowerApps uses its own functions, such as Patch(), Collect(), Update(), and so on to interact with the data. 表格式資料可輕易用於表單和程式庫中,因為資料表中的欄位會顯示為程式庫或表單中的欄位。Tabular data is also easy to use in forms and galleries, where a field in a table is displayed as a field in a gallery or form. 如需詳細資訊,請參閱下列文章:For more information, see the following articles:

    了解 PowerApps 中的資料來源Understand data sources in PowerApps

    從 Excel 資料產生應用程式Generate an app from Excel data

    從頭建立應用程式Create an app from scratch

    注意:若要連線到 Excel 中的資料,活頁簿必須裝載在雲端儲存體服務中,例如 OneDrive。Note: To connect to data in Excel, the workbook must be hosted in a cloud-storage service like OneDrive. 如需詳細資訊,請參閱從 PowerApps 連線至雲端儲存體For more information, see Connect to cloud-storage from PowerApps.

  • 其他連接器會使用函式型資料來源,例如 Twitter、Facebook 和 Office 365 Outlook。Other connectors work with function-based data sources, such as Twitter, Facebook, and Office 365 Outlook. 若使用這些資料來源,系統會根據在基礎服務中呼叫特定函式來將資料傳回給 PowerApps。When working with these data sources, data is returned to PowerApps based on calling specific functions in the underlying service. 例如,若您使用 Twitter 連接器,則會呼叫 Twitter.MyFollowers() 以傳回粉絲清單。For example, with the Twitter connector you call Twitter.MyFollowers() to return a list of your followers. 您仍可將這項資料用在表單或程式庫中,但相較於表格式資料,您需要再對這項資料進行一些處理。You can still use this data in a form or gallery, but it requires a little more work than tabular data. 如需詳細資訊,請參閱從 PowerApps 連線至 TwitterFor more information, see Connect to Twitter from PowerApps.

所有連接器All connectors

下列表格列出所有連接器。The following table lists all our connectors. 如需各連接器的詳細資訊,請參閱 Microsoft 連接器參考For more information about each connector, see the Microsoft Connector Reference. 需要 PowerApps 方案 1 或方案 2 才能使用進階連接器。Premium connectors require PowerApps Plan 1 or Plan 2. 如需詳細資訊,請參閱 PowerApps 方案For more information, see PowerApps Plans.

   
10to8 約會排程10to8 Appointment Scheduling
Act!Act!
Adobe Creative CloudAdobe Creative Cloud 進階連接器
Adobe SignAdobe Sign
Amazon RedshiftAmazon Redshift 進階連接器
Apache ImpalaApache Impala 進階連接器
AppFiguresAppFigures
核准Approvals
AsanaAsana
AWeberAWeber 進階連接器
Azure ADAzure AD
Azure Application InsightsAzure Application Insights
Azure 自動化Azure Automation
Azure Blob 儲存體Azure Blob Storage
Azure Cosmos DBAzure Cosmos DB
Azure Data Lake StoreAzure Data Lake
Azure Event GridAzure Event Grid
Azure Event Grid 發佈Azure Event Grid Publish
Azure 檔案儲存體Azure File Storage
Azure Log AnalyticsAzure Log Analytics
Azure Log Analytics 資料收集器Azure Log Analytics Data Collector
Azure 佇列Azure Queues
Azure Resource ManagerAzure Resource Manager
Azure 資料表儲存體Azure Table Storage
Basecamp 2Basecamp 2
Basecamp 3Basecamp 3
Benchmark 電子郵件Benchmark Email 進階連接器
Bing 地圖服務Bing Maps
Bing 搜尋Bing Search
BitbucketBitbucket 進階連接器
BitlyBitly
Bizzy (H3 解決方案等)Bizzy (H3 Solutions, Inc.)
BloggerBlogger
BoxBox
bttnbttn
緩衝區Buffer
CalendlyCalendly 進階連接器
CampfireCampfire
Capsule CRMCapsule CRM 進階連接器
ChatterChatter 進階連接器
Cognito FormsCognito Forms
Common Data ServiceCommon Data Service 進階連接器
Computer Vision APIComputer Vision API
單位轉換Content Conversion
內容仲裁Content Moderator
DB2DB2 進階連接器
DisqusDisqus
DocFusion365 – SPDocFusion365 – SP 進階連接器
DocuSignDocuSign 進階連接器
DropboxDropbox
Dynamics 365Dynamics 365
Dynamics 365 for FinancialsDynamics 365 for Financials
營運用 DynamicsDynamics for Operations
Dynamics NAVDynamics NAV
Easy RedmineEasy Redmine 進階連接器
Elastic FormsElastic Forms
事件中樞Event Hubs
EventbriteEventbrite 進階連接器
ExcelExcel
人臉識別 APIFace API
FacebookFacebook
檔案系統File System
FlicFlic
FlowFormaFlowForma 進階連接器
FreshBooksFreshBooks 進階連接器
FreshdeskFreshdesk
FreshserviceFreshservice 進階連接器
FTPFTP
GitHubGitHub
GmailGmail
Google 日曆Google Calendar
Google 聯絡人Google Contacts
Google 雲端硬碟Google Drive
Google 試算表Google Sheets
Google 工作Google Tasks
GoToMeetingGoToMeeting 進階連接器
GoToTrainingGoToTraining 進階連接器
GoToWebinarGoToWebinar 進階連接器
HarvestHarvest 進階連接器
HelloSignHelloSign 進階連接器
HipChatHipChat
具有 Azure AD 的 HTTPHTTP with Azure AD 進階連接器
InformixInformix 進階連接器
InfusionsoftInfusionsoft 進階連接器
InoreaderInoreader
InsightlyInsightly
InstagramInstagram
InstapaperInstapaper
IntercomIntercom
JIRAJIRA 進階連接器
JotFormJotForm 進階連接器
LeanKitLeanKit 進階連接器
LinkedInLinkedIn
LiveChatLiveChat 進階連接器
LUISLUIS
郵件Mail
MailChimpMailChimp 進階連接器
MandrillMandrill 進階連接器
中型Medium
Microsoft FormsMicrosoft Forms
Microsoft StaffHubMicrosoft StaffHub
Microsoft TeamsMicrosoft Teams
Microsoft TranslatorMicrosoft Translator
MSN 天氣MSN Weather
Muhimbi PDFMuhimbi PDF
MySQLMySQL 進階連接器
NexmoNexmo 進階連接器
NotificationsNotifications
Office 365 BookingsOffice 365 Bookings
Office 365 群組Office 365 Groups
Office 365 OutlookOffice 365 Outlook
Office 365 UsersOffice 365 Users
Office 365 VideoOffice 365 Video
OneDriveOneDrive
商務用 OneDriveOneDrive for Business
OneNote (商務)OneNote (Business)
Oracle DatabaseOracle Database 進階連接器
Outlook Customer ManagerOutlook Customer Manager
Outlook 工作Outlook Tasks
Outlook.comOutlook.com
PagerDutyPagerDuty
ParserrParserr
PaylocityPaylocity 進階連接器
PinterestPinterest
PipedrivePipedrive 進階連接器
Pitney Bowes 資料驗證Pitney Bowes Data Validation 進階連接器
Pivotal TrackerPivotal Tracker
PlannerPlanner
PlivoPlivo 進階連接器
PostgreSQLPostgreSQL 進階連接器
Power BIPower BI
PowerApps 通知PowerApps Notification 進階連接器
線上專案Project Online
RedmineRedmine
RSSRSS
SalesforceSalesforce 進階連接器
SendGridSendGrid
服務匯流排Service Bus
SFTPSFTP
SharePointSharePoint
商務用 SkypeSkype for Business
SlackSlack
SmartSheetSmartSheet
SMTPSMTP
SparkPostSparkPost
SQL ServerSQL Server
StripeStripe 進階連接器
SurveyMonkeySurveyMonkey 進階連接器
Teamwork ProjectsTeamwork Projects 進階連接器
TeradataTeradata 進階連接器
文字分析Text Analytics
TodoistTodoist
ToodledoToodledo
TrelloTrello
TwilioTwilio
TwitterTwitter
TypeFormTypeForm
UserVoiceUserVoice 進階連接器
影片索引器Video Indexer
VimeoVimeo
Visual Studio Team ServicesVisual Studio Team Services
WebMergeWebMerge
WordPressWordPress
WunderlistWunderlist
YammerYammer
YouTubeYouTube
ZendeskZendesk 進階連接器

如果您有關於特定連接器的問題,請使用 PowerApps 論壇If you have questions about a specific connector, please use the PowerApps Forums. 如果您有新連接器的構想或改進建議,請使用 PowerApps 構想If you have an idea for a new connector or suggestions for improvement, use PowerApps Ideas.