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 for Business OneDrive for BusinessOneDrive for Business
Dynamics 365 Dynamics 365Dynamics 365   OneDrive OneDriveOneDrive
Office 365 用户 Office 365 用户Office 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!
Adobe Creative CloudAdobe Creative Cloud 高级连接器
Adobe 登录Adobe 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 LakeAzure Data Lake
Azure 事件网格Azure Event Grid
Azure 事件网格发布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 资源管理器Azure Resource Manager
Azure 表存储Azure Table Storage
Basecamp 2Basecamp 2
Basecamp 3Basecamp 3
基准检验电子邮件Benchmark Email 高级连接器
必应地图Bing Maps
必应搜索Bing Search
BitbucketBitbucket 高级连接器
BitlyBitly
Bizzy (H3 Solutions, Inc.)Bizzy (H3 Solutions, Inc.)
BloggerBlogger
BoxBox
bttnbttn
缓冲区Buffer
CalendlyCalendly 高级连接器
CampfireCampfire
Capsule CRMCapsule CRM 高级连接器
ChatterChatter 高级连接器
Cognito FormsCognito Forms
Common Data ServiceCommon Data Service 高级连接器
计算机影像 APIComputer Vision API
内容转换Content Conversion
内容审查器Content Moderator
DB2DB2 高级连接器
DisqusDisqus
DocFusion365 – SPDocFusion365 – SP 高级连接器
DocuSignDocuSign 高级连接器
DropboxDropbox
Dynamics 365Dynamics 365
Dynamics 365 for FinancialsDynamics 365 for Financials
Dynamics for OperationsDynamics 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 DriveGoogle 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 高级连接器
通知Notifications
Office 365 BookingsOffice 365 Bookings
Office 365 组Office 365 Groups
Office 365 OutlookOffice 365 Outlook
Office 365 用户Office 365 Users
Office 365 视频Office 365 Video
OneDriveOneDrive
OneDrive for BusinessOneDrive for Business
OneNote(企业版)OneNote (Business)
Oracle 数据库Oracle 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 OnlineProject Online
RedmineRedmine
RSSRSS
SalesforceSalesforce 高级连接器
SendGridSendGrid
服务总线Service Bus
SFTPSFTP
SharePointSharePoint
Skype for BusinessSkype for Business
SlackSlack
SmartSheetSmartSheet
SMTPSMTP
SparkPostSparkPost
SQL ServerSQL Server
StripeStripe 高级连接器
SurveyMonkeySurveyMonkey 高级连接器
团队合作项目Teamwork Projects 高级连接器
TeradataTeradata 高级连接器
文本分析Text Analytics
TodoistTodoist
ToodledoToodledo
TrelloTrello
TwilioTwilio
TwitterTwitter
TypeFormTypeForm
用户心声UserVoice 高级连接器
视频索引器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.