How To Add Excel Data Source In Microsoft PowerApps

Introduction

Before reading this article, please go through the article's link, given below.

• Quick Start on Microsoft PowerApps

In PowerApps, we can add a connection to an existing external data source. The external data source available in PowerApps connects to Excel, Facebook, Twitter, SharePoint, Salesforce, OneDrive, DropBox, etc.

We can display and manage the data in the source from your app, as given below.

• Connect to OneDrive and manage the data in an Excel Workbook in your app.
• Connect to Twilio and send an SMS message from your app.
• Connect to SQL Azure and update a table from your app.
• Send a tweet.

Here, we are going to see how we connect Excel files in the Microsoft PowerApps.

Developer Requirements

1. Download PowerApps from the Windows Store.
2. Microsoft Excel.

Follow the steps, given below to add Excel as an external data source in PowerApps.

Step 1. Create an Excel file.

Here, we first create an Excel file save it as StudentDetails, and enter the data.

Step 2. We convert the data into a Table.

Now, we convert our data into Table format. Select the content and go to the Insert menu. Choose the Table.

Now, create a Table Window, which is displayed. Now, we need to tap the OK button.

Now, our data is converted into the table and we need to change the name of the table to RankSheet. Save the Excel file.

Note. We link our PowerApp through this table name only.

Step 3. Log in to the PowerApps.

After downloading PowerApps from the Windows store, we need a Microsoft-related organization’s Office 365 ID (MSDN, Microsoft, Skype, Office 365, etc.) to log in with it.

Step 4. Create a New App in PowerApps.

After login, we can see the Dashboard. Subsequently, we need to click on the New button.

Step 5. Choose the blank App.

Step 6. Designing the App.