Create a Data Table from Excel Data using PowerApps

SharePoint Online training courses

In this Powerapps Tutorial, We will discuss how to create a Data Table from the Excel Data using Powerapps.

Also, we will see various properties and alignments of the Data table in Power Apps.

To create a Data Table From Excel Data using Power Apps, We have to follow these two steps as:

  1. Create an Excel file and Format that Excel file as Table
  2. Rename the Excel File Name and Upload it into OneDrive for Business
  3. Create a Canvas app from Excel using Power Apps

Also check:

Create and Format Excel as Table and Upload it into OneDrive for Business

Follow the below processes:

  • Create an Excel file using some sample records as below.
  • Open the Excel file, go to the Home tab. Click on Format as Table option and select any table format.
Create Data Table from Excel using PowerApps
powerapps create data table from excel
  • Change your Excel Table name (Employee_Work_Status) and Save it.
  • Upload your Excel file into any Cloud-Storage account like OneDrive, OneDrive for Business, etc.
Create Data Table from Excel using Power Apps
powerapps create data table from excel

Create a Data Table from Excel Data using PowerApps

Follow the below steps to create a Canvas app from Excel Data using Power Apps.

Step-1: (Create Canvas app from blank)

  • Open the Power Apps page through the Browser. Sign in your Power Apps using Microsoft account.
  • In the Power Apps page, Select the Canvas app from blank under Make your own app as shown below.

Step-2: (Specify Name for App)

  • Provide a name for your new app (EmployeeExcelApp), Select any format as Tablet or Phone and then click on Create.

Step-3: (Create a New Screen)

Go to Home tab -> New screen -> Click on Blank as shown below.

Create Data Table from Excel Data using PowerApps
Create a Data Table from Excel Data using PowerApps

Step-4: (Create a Data table)

Go to Insert tab -> Click on Data table as like below screenshot.

Create a Data Table from Excel Data using PowerApps
Create a Data Table from Excel Data using PowerApps

Step-5: (Connect to Data Source)

  • Select connect to data link option in the middle of the screen.
  • The Data sources will appear on the left side of the page once you clicking on the link. Expand the Connectors and select the connection for your cloud-storage account if it shows in that Data sources.
  • Otherwise if it not appears, then you can easily add a new connection using +Add a connection.
  • Select OneDrive for Business under the Connectors section and add your connection.
Create a Data Table from Excel using PowerApps
Create a Data Table from Excel using PowerApps
  • Select the data source as Employee_Work_Status as shown below.
Create a Data Table from Excel in Power Apps
Create a Data Table from Excel using PowerApps

Step-6: (Choose an Excel file)

In the Choose a table section, select the checkbox for Employee_Work_Status and then click on to Connect. Now you can close your data pane by using a cross icon.

Create a Data Table from Excel using Power Apps

Now you can see the Data Table will be ready to use for your requirement. Just you need to add all fields into the Data Table.

Create a Data Table from Excel Data using PowerApps
Create a Data Table from Excel using PowerApps

Step-7: (Edit field Data in Data Table)

  • Select the Data Table and go to the Properties tab on the right side.
  • Select the Data source as Employee_Work_Status from the drop-down.
  • Click on Edit fields from the Fields section.
  • Click on the “+Add field” and choose one or more fields as per your requirement.
  • Click on the Add button.
Create a Data Table from Excel in PowerApps
powerapps create data table

After adding all the fields into the Data table, you can see your records as a table format like the below screenshot.

In the Data field section, you can see the properties of each data as like:

  • Control type: It specifies the control type of a field.
  • Field name: It specifies the name of the field.
  • Data type: It specifies the data type of a field.
  • Required: It specifies the field is required or not.
create a canvas app from scratch based on excel data using Power Apps

Data Table Properties in PowerApps

If you want to provide some design for your Data Table in Powerapps so that it will be more attractive, then you can use the Properties tab in the Data table.

Select the Data table and go to Properties tab as shown below. You can see the properties like:

  • Size: You can increase the size of your Data table by using Width and Height.
  • Color: You can provide the font color.
  • Font: You can change the font to any font format.
  • Font size: You can provide the font size.
  • Font weight: You can specify the weight of the font either Bold, Semibold, Normal, or Lighter.
  • Border: You can give a border to the Data table.
  • Hover color: If you want to set the color for hover, then you can set and so on.
create a canvas app from scratch based on excel data using PowerApps
powerapps create data table

Data Table Alignment in PowerApps

In Powerapps, suppose you want to display the Data table in the middle, right or left part of the screen as per your requirement.

In the left navigation of Powerapps screen, Go to the Tree view -> Click on Screens tab -> Click on DataTable -> Align -> Choose the align as left, right, top or center as per your requirement.

In the same way, you can use some Data table properties like Cut, Copy, Delete, Rename, etc as shown below.

create app from excel spreadsheet in PowerApps
Data Table Alignment in PowerApps

Also, you may like the below Powerapps Tutorials:

In this Powerapps Tutorial, We discussed how to create a Data Table from the Excel Data using PowerApps.

Also, we saw PowerApps Data Table Properties and Alignments.

>