Overview of connectors for PowerApps

• 08/28/2017
• 3 minutes to read
• Contributors
  • 
  • 
  • 

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

  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 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 Facebook 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 Instagram Instapaper Intercom JIRA JotForm LeanKit LinkedIn LiveChat LUIS Mail 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 Pinterest 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 Twitter 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.