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 has connectors for many popular services and on-premises data sources, including SharePoint, SQL Server, Office 365, Salesforce, Twitter, and more. 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 Service   Office 365 Outlook Office 365 Outlook
SharePoint SharePoint   Excel Excel
SQL Server SQL Server   OneDrive for Business OneDrive for Business
Dynamics 365 Dynamics 365   OneDrive OneDrive
Office 365 Users Office 365 Users   Dropbox Dropbox

Types of connectors

PowerApps has two types of connectors: standard connectors like the ones listed above, and custom connectors. 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:

  • Some connectors work with tabular data sources, such as SharePoint, SQL Server, and Excel. When working with these data sources, data is returned to PowerApps as a table. 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:

    Understand data sources in PowerApps

    Generate an app from Excel data

    Create an app from scratch

    Note: To connect to data in Excel, the workbook must be hosted in a cloud-storage service like OneDrive. For more information, see Connect to cloud-storage from PowerApps.

  • Other connectors work with function-based data sources, such as Twitter, Facebook, and Office 365 Outlook. When working with these data sources, data is returned to PowerApps based on calling specific functions in the underlying service. 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. For more information, see Connect to Twitter from PowerApps.

All connectors

The following table lists all our connectors. For more information about each connector, see the Microsoft Connector Reference. Premium connectors require PowerApps Plan 1 or Plan 2. For more information, see PowerApps Plans.

   
10to8 Appointment Scheduling
Act!
Adobe Creative Cloud Premium connector
Adobe Sign
Amazon Redshift Premium connector
Apache Impala Premium connector
AppFigures
Approvals
Asana
AWeber Premium connector
Azure AD
Azure Application Insights
Azure Automation
Azure Blob Storage
Azure Cosmos DB
Azure Data Lake
Azure Event Grid
Azure Event Grid Publish
Azure File Storage
Azure Log Analytics
Azure Log Analytics Data Collector
Azure Queues
Azure Resource Manager
Azure Table Storage
Basecamp 2
Basecamp 3
Benchmark Email Premium connector
Bing Maps
Bing Search
Bitbucket Premium connector
Bitly
Bizzy (H3 Solutions, Inc.)
Blogger
Box
bttn
Buffer
Calendly Premium connector
Campfire
Capsule CRM Premium connector
Chatter Premium connector
Cognito Forms
Common Data Service Premium connector
Computer Vision API
Content Conversion
Content Moderator
DB2 Premium connector
Disqus
DocFusion365 – SP Premium connector
DocuSign Premium connector
Dropbox
Dynamics 365
Dynamics 365 for Financials
Dynamics for Operations
Dynamics NAV
Easy Redmine Premium connector
Elastic Forms
Event Hubs
Eventbrite Premium connector
Excel
Face API
Facebook
File System
Flic
FlowForma Premium connector
FreshBooks Premium connector
Freshdesk
Freshservice Premium connector
FTP
GitHub
Gmail
Google Calendar
Google Contacts
Google Drive
Google Sheets
Google Tasks
GoToMeeting Premium connector
GoToTraining Premium connector
GoToWebinar Premium connector
Harvest Premium connector
HelloSign Premium connector
HipChat
HTTP with Azure AD Premium connector
Informix Premium connector
Infusionsoft Premium connector
Inoreader
Insightly
Instagram
Instapaper
Intercom
JIRA Premium connector
JotForm Premium connector
LeanKit Premium connector
LinkedIn
LiveChat Premium connector
LUIS
Mail
MailChimp Premium connector
Mandrill Premium connector
Medium
Microsoft Forms
Microsoft StaffHub
Microsoft Teams
Microsoft Translator
MSN Weather
Muhimbi PDF
MySQL Premium connector
Nexmo Premium connector
Notifications
Office 365 Bookings
Office 365 Groups
Office 365 Outlook
Office 365 Users
Office 365 Video
OneDrive
OneDrive for Business
OneNote (Business)
Oracle Database Premium connector
Outlook Customer Manager
Outlook Tasks
Outlook.com
PagerDuty
Parserr
Paylocity Premium connector
Pinterest
Pipedrive Premium connector
Pitney Bowes Data Validation Premium connector
Pivotal Tracker
Planner
Plivo Premium connector
PostgreSQL Premium connector
Power BI
PowerApps Notification Premium connector
Project Online
Redmine
RSS
Salesforce Premium connector
SendGrid
Service Bus
SFTP
SharePoint
Skype for Business
Slack
SmartSheet
SMTP
SparkPost
SQL Server
Stripe Premium connector
SurveyMonkey Premium connector
Teamwork Projects Premium connector
Teradata Premium connector
Text Analytics
Todoist
Toodledo
Trello
Twilio
Twitter
TypeForm
UserVoice Premium connector
Video Indexer
Vimeo
Visual Studio Team Services
WebMerge
WordPress
Wunderlist
Yammer
YouTube
Zendesk Premium connector

If you have questions about a specific connector, please use the PowerApps Forums. If you have an idea for a new connector or suggestions for improvement, use PowerApps Ideas.