Overview of connectors for 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 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 | ![]() |
Office 365 Outlook | |
![]() |
SharePoint | ![]() |
Excel | |
![]() |
SQL Server | ![]() |
OneDrive for Business | |
![]() |
Dynamics 365 | ![]() |
OneDrive | |
![]() |
Office 365 Users | ![]() |
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
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 ![]() Adobe Sign Amazon Redshift ![]() Apache Impala ![]() AppFigures Approvals Asana AWeber ![]() 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 ![]() Bing Maps Bing Search Bitbucket ![]() Bitly Bizzy (H3 Solutions, Inc.) Blogger Box bttn Buffer Calendly ![]() Campfire Capsule CRM ![]() Chatter ![]() Cognito Forms Common Data Service ![]() Computer Vision API Content Conversion Content Moderator DB2 ![]() Disqus DocFusion365 – SP ![]() DocuSign ![]() Dropbox Dynamics 365 Dynamics 365 for Financials Dynamics for Operations Dynamics NAV Easy Redmine ![]() Elastic Forms Event Hubs Eventbrite ![]() Excel Face API File System Flic FlowForma ![]() FreshBooks ![]() Freshdesk Freshservice ![]() FTP GitHub Gmail Google Calendar Google Contacts Google Drive Google Sheets Google Tasks GoToMeeting ![]() GoToTraining ![]() GoToWebinar ![]() Harvest ![]() HelloSign ![]() HipChat HTTP with Azure AD ![]() Informix ![]() Infusionsoft ![]() |
Inoreader Insightly Instapaper Intercom JIRA ![]() JotForm ![]() LeanKit ![]() LiveChat ![]() LUIS MailChimp ![]() Mandrill ![]() Medium Microsoft Forms Microsoft StaffHub Microsoft Teams Microsoft Translator MSN Weather Muhimbi PDF MySQL ![]() Nexmo ![]() Notifications Office 365 Bookings Office 365 Groups Office 365 Outlook Office 365 Users Office 365 Video OneDrive OneDrive for Business OneNote (Business) Oracle Database ![]() Outlook Customer Manager Outlook Tasks Outlook.com PagerDuty Parserr Paylocity ![]() Pipedrive ![]() Pitney Bowes Data Validation ![]() Pivotal Tracker Planner Plivo ![]() PostgreSQL ![]() Power BI PowerApps Notification ![]() Project Online Redmine RSS Salesforce ![]() SendGrid Service Bus SFTP SharePoint Skype for Business Slack SmartSheet SMTP SparkPost SQL Server Stripe ![]() SurveyMonkey ![]() Teamwork Projects ![]() Teradata ![]() Text Analytics Todoist Toodledo Trello Twilio TypeForm UserVoice ![]() Video Indexer Vimeo Visual Studio Team Services WebMerge WordPress Wunderlist Yammer YouTube Zendesk ![]() |
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.