You are currently viewing Using Microsoft Excel As A Database To Create A Power App

Using Microsoft Excel As A Database To Create A Power App


Creating Power Apps using Microsoft Excel AS database.

Works with Microsoft Office 365


 Following are the steps to create a Power App from Microsoft Excel.

  1. In PowerApps Home Page, Click on
  2. Select Excel Online, it will take you to the Connections Screen as shown below.Microsoft Excel as Database
  1. Click on New connection.New Connection

When you connect OneDrive/OneDrive for Business for the first time, you need to click on the New Connection. But once the connection is created, the OneDrive/ OneDrive for Business connection will be displayed in the below existing list of connections like SharePoint connection is displayed in the above screenshot. One needs to just click on the existing OneDrive connection to connect an Excel file to the app. When you click on New Connection, a list of all connections will be displayed as shown in below screenshot.Existing Connection

  1. Select OneDrive or OneDrive for Business, whichever is the source.Source Selection
  1. Click on Create button from above screen to create the OneDrive/ OneDrive for Business Connection for the first time.
  2. Click on OneDrive/ One Drive for Business under Connections.
  3. Choose the Excel File where data is saved.Excel File Location
  1. Choose the Table where Data is saved.
  2. Click on the Connect button to create the Power Apps Canvas App.Connect-Power Apps Canvas App

Microsoft Power Apps will automatically create the app in Phone Layout.

Leave a Reply