Let’s get started
Please enter your work or school account to get started.
In PowerApps, add a data connection to an existing app, or to an app that you're building from scratch. In this topic you use PowerApps Studio, but you can also use powerapps.com, as the Manage connections topic describes.
Your app's data connection can connect to SharePoint, Salesforce, OneDrive, or one of many other data sources.
Your next step after this article is to display and manage data from that data source in your app, as in these examples:
Most PowerApps apps use external information called Data Sources that is stored in cloud services. A common example is a table in an Excel file stored in OneDrive for Business. Apps are able to access these data sources by using Connectors.
The commonest data sources are tables which you can use to retrieve and store information. You can use connectors to data sources to read and write data in Microsoft Excel workbooks, SharePoint lists, SQL tables, and many other formats, which can be stored in cloud services like OneDrive for Business, DropBox, SQL Server, etc.
There are other kinds of data sources that are not tables, such as email, calendars, twitter, and (coming soon) notifications.
Click or tap New on the File menu (near the left edge).
On the Blank app tile, click or tap Phone layout .
Near the lower-right corner, click or tap Data sources to open the Data sources tab of the right-hand pane.
Note: If you're updating an existing app and the right-hand pane doesn't show the Data sources tab, select any screen by clicking or tapping it in the left navigation bar.
In the Data sources tab, click or tap Add data source.
Check the list on connections and see if the one you want to use is in the list.
If the connection you want to use appears in the list of connections, click or tap it to add it to the app.
If the list of connections does not include the one you want, follow these steps:
Click or tap New connection to display a list of connectors.
Scroll through the list of connectors until the type of connection that you want to create appears (for example, Office 365 Outlook), and then click or tap it.
Click or tap Create to both create the connection and add it to your app.
Some connectors, such as Microsoft Translator, require no additional steps, and you can show data from them immediately. Other connectors prompt you to provide credentials, specify a particular set of data, or perform other steps. For example, SharePoint and SQL Server require additional information before you can use them.