Before reading this article, please go through the article's link, given below.
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 and save it as StudentDetails and enter the data.
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.
Now, create 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 as 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 Window store, we need Microsoft related organization’s Office 365 ID or (MSDN, Microsoft, Skype, Office 365, etc.) to login with it.
Step 4 Create a New App in PowerApp
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
Now, let's start to design the app. On the left side, we can see the individual screens to add our data. On 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.
Step 7
Click on the Add Data Source.
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.
Step 9
Choose the 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.
Now, the table is added into PowerApps.
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.
Now, the style is applied.
Step 12 Configure Data Source to App
Now, we need to configure the data source to our PowerApps. Choose RankSheet from TextualGallerySample.
Choose the Columns to our TextBox.
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.
Step 14 Save the App
Now, we need to save it on Cloud or the local machine.
Step 15
Run the app.
Output
Conclusion
I hope, you understood how to add an Excel data source in Microsoft PowerApps and how to run it.