Office IT Tips

Create a Canvas App from Excel Data in Power Apps

Posted on by Jonh Luke

Introduction

Building apps quickly from spreadsheets is one of the most practical ways to modernize business workflows. The create canvas app from Excel data in Power Apps approach allows users to turn existing Excel tables into fully functional mobile or web applications with minimal effort. Instead of manually designing databases or complex backends, you can leverage structured Excel data and instantly transform it into a working app.

In this guide, you’ll learn how to create a canvas app using Excel data as the source, explore three different setup methods, and understand how to build a simple but functional app with browsing, editing, and deleting capabilities.

What Is a Canvas App from Excel Data?

A canvas app in Microsoft Power Apps lets you design an application by dragging and dropping components onto a flexible interface. When connected to Excel data, the app reads structured tables and uses them as a dynamic data source.

This method is ideal for:

  • Business users tracking data in Excel
  • Rapid prototyping of internal tools
  • Lightweight CRUD (Create, Read, Update, Delete) apps

The primary keyword intent here is informational, as users want to learn how to build apps from Excel step by step.

Three Ways to Build Apps from Excel

Power Apps provides multiple entry points depending on your needs:

  • Upload Excel or CSV files to create a Dataverse table
  • Connect directly to an Excel file stored in the cloud
  • Start from a blank canvas app and manually connect Excel data

Each method balances flexibility, speed, and scalability differently.

Method 1: Upload Excel or CSV to Dataverse

Uploading your file converts Excel data into a structured Dataverse table, giving you better security and scalability.

Steps:

  1. Sign in to Power Apps
  2. Select Start with data
  3. Choose Upload file
  4. Upload your Excel or CSV file
  5. Configure table settings and column types
  6. Set row ownership rules
  7. Save and open the generated app

This method is best for long-term solutions where Excel evolves into a database-like system.

Method 2: Connect to an External Excel File

If your Excel file is already stored in cloud storage such as OneDrive or Dropbox, you can directly connect it.

Steps:

  1. Go to Power Apps home
  2. Select Start with data
  3. Choose Excel Online (Business)
  4. Connect to your cloud account
  5. Select the Excel file and table
  6. Generate the app automatically

This is the fastest way to turn existing spreadsheets into apps without migrating data.

Method 3: Build a Blank Canvas App with Excel Data

This method offers the most flexibility. You manually design screens and connect Excel data.

Prepare Your Excel Data

Make sure your Excel data is formatted as a table before importing.

Example dataset:

  • StartDay
  • StartTime
  • Volunteer
  • Backup

Save the file as eventsignup.xlsx and upload it to OneDrive.

Create the App and Connect Data

  1. Open Power Apps and select Create → Start from blank
  2. Choose Phone layout
  3. Click Connect to data
  4. Add OneDrive connection
  5. Select your Excel file
  6. Choose the Schedule table
  7. Confirm connection

Build the View Screen

After connecting data, create a screen to display records.

  1. Add a new List screen
  2. Rename the title to “View records”
  3. Set the gallery data source to Schedule
  4. Configure search and sort by Volunteer field

This allows users to filter and browse data dynamically.

Configure Data Display and Sorting

Inside the gallery, ensure fields are mapped correctly:

  • Title → Volunteer
  • Subtitle → StartDay
  • Body → StartTime

This structure makes the app intuitive for end users.

Create the Edit Screen

Add a form screen to handle editing and adding records.

Reorder Form Fields

You can adjust the form layout to prioritize important data fields.

Move the Volunteer field to the top so users can input key information first.

Customize Screen Title

Rename the form header for clarity.

Set the title to Change records to clearly indicate editing mode.

Manage Screens in the App

To keep your app organized, rename and delete default screens.

Remove unused screens and rename:

  • Screen2 → ViewScreen
  • Screen3 → ChangeScreen

This improves navigation clarity.

Add Refresh and New Record Actions

To make the app interactive, configure action icons.

Refresh Data

Refresh icon used to reload Excel data in Power Apps

Refresh icon used to reload Excel data in Power Apps

Use:
Refresh(Schedule)

This ensures users always see the latest Excel data.

Add New Records

Use:
NewForm(EditForm1); Navigate(ChangeScreen)

This opens a blank form for new entries.

Enable Record Selection and Editing

Users can edit existing records directly from the list.

Use:
EditForm(EditForm1); Navigate(ChangeScreen)

This allows seamless switching between view and edit modes.

Enable Save, Cancel, and Delete Actions

On the edit screen:

  • Save changes using SubmitForm
  • Cancel edits using ResetForm
  • Delete records using Remove function

These actions complete the full CRUD functionality of the app.

Conclusion

Creating apps using Excel data in Power Apps is a fast and efficient way to modernize manual workflows. Whether you upload files, connect cloud spreadsheets, or build from scratch, the create canvas app from Excel data in Power Apps method gives you flexible options to transform static data into interactive business applications.

By following the steps in this guide, you can build a fully functional app with browsing, editing, and data management features in just a few minutes. Start experimenting with your own Excel datasets and bring your ideas to life today.

Jonh Luke