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!
appFigures
Asana
Azure Automation
Azure Blob Storage
Azure Data Lake
Azure DocumentDB
Azure Queues
Azure Resource Manager
Basecamp 2
Basecamp 3
Bitbucket Premium connector
Bitly
Blogger
Box
bttn
Buffer
Campfire
Capsule CRM
Chatter Premium connector
Common Data Service Premium connector
Computer Vision API
DB2 Premium connector
Disqus
DocuSign Premium connector
Dropbox
Dynamics 365
Dynamics 365 for Financials
Dynamics for Operations
Dynamics NAV
Easy Redmine Premium connector
Excel
Eventbrite Premium connector
Face API
Facebook
File System
Flic
FreshBooks Premium connector
Freshdesk
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
Informix Premium connector
Infusionsoft Premium connector
Inoreader
Insightly
Instagram
Instapaper
Intercom
JIRA Premium connector
LeanKit Premium connector
LUIS
Mail
MailChimp Premium connector
Mandrill Premium connector
Medium
Microsoft Translator
MSN Weather
Muhimbi PDF
Notifications
Office 365 Bookings
Office 365 Outlook
Office 365 Users
Office 365 Video
OneDrive
OneDrive for Business
OneNote (Business)
Oracle Database Premium connector
Outlook Tasks
Outlook.com
PagerDuty
Pinterest
Pipedrive Premium connector
Pivotal Tracker
Power BI
PowerApps Notification Premium connector
Project Online
Redmine
RSS
Salesforce Premium connector
SendGrid
Service Bus
SFTP
SharePoint
Slack
SmartSheet
SMTP
SparkPost
SQL Server
Stripe Premium connector
SurveyMonkey Premium connector
Text Analytics
Todoist
Toodledo
Trello
Twilio
Twitter
TypeForm
UserVoice Premium connector
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.