How To Add Excel Data Source In Microsoft PowerApps

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

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 file in the Microsoft PowerApps.

Developer Requirements

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

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

Step 1 Create Excel file

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

Excel file

Step 2 We convert the data into Table

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

Excel file

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

Excel file

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

Note

We link our PowerApp through this table name only.

Excel file

Step 3 Log into the PowerApps

After downloading PowerApps from the Window store, we need Microsoft related organization’s Office 365 ID or (MSDN, Microsoft, Skype, Office 365 etc.) to login with it.

Excel file

Step 4 Create a New App in PowerApp

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

Excel file

Step 5 Choose the blank App

Excel file

Step 6 Designing the App

Now, let's start to design the app. In the left side, we can see the individual screens to add our data. In the right side, we see the list of layouts.

On the top, we see the formula bar. See the Properties of the screen, which you will select.

On the right side, we see the Add data source to add the external data source.

Excel file

Step 7

Click on the Add data Source.

Excel file

Step 8 Choose the Connection

Here, we have many connections to add the external data source. Static is required to add the external Excel file.

Excel file

Step 9

Choose the Excel file.

Excel file

Step 10 Adding the Table Name

Here, they list out the tables present in your table. We have to choose the table name (RankSheet), which was given in the Excel file and click the Connect button.

Excel file

Now, the table is added into PowerApps.

Excel file

Step 11 Choose the Layout

Next, we have to add the layout to display the data from the table. Hence, choose the style, which you require.

Excel file

Now, the style is applied.

Excel file

Step 12 Configure Data Source to App

Now, we need to configure the data source to our PowerApps. Choose RankSheet from TextualGallerySample.

Excel file

Choose the Columns to our TextBox.

Excel file

Step 13 Change the App Setting

Click on the File menu, where you need to see the app settings. Here, we change the app name, icon and color of the app.

Excel file

Step 14 Save the App

Now, we need to save it on Cloud or the local machine.

Excel file

Step 15

Run the app.

Excel file

Output

Excel file

Conclusion

I hope, you understood how to add Excel data source in Microsoft PowerApps and how to run it.