Let’s get started
Please enter your work or school account to get started.
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|
|SQL Server||OneDrive for Business|
|Office 365 Users||Dropbox|
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:
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.
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 |
Azure Blob Storage
Azure Data Lake
Azure Resource Manager
Common Data Service
Computer Vision API
Dynamics 365 for Financials
Dynamics for Operations
Office 365 Bookings
Office 365 Outlook
Office 365 Users
Office 365 Video
OneDrive for Business
Visual Studio Team Services