How to Connect Excel Spreadsheets to Power Apps | Step-by-Step Tutorial

In this comprehensive step-by-step tutorial, we will walk you through the process of creating and connecting apps to Excel spreadsheets using Power Apps. Whether you're an Excel enthusiast looking to leverage its power for app development or a seasoned Power Apps user, this video has something valuable to offer.
Our journey includes:
Creating and configuring Excel spreadsheets, the backbone of our data.
Establishing a robust connection between your Power Apps and Excel, ensuring seamless data integration.
Building a responsive canvas app optimized for smartphone usage, making your app accessible to a wider audience.
Demonstrating how to visualize, manipulate, and work with data directly from your Excel spreadsheet within Power Apps.
Guidance on saving your app to avoid data loss and publishing it to make it shareable with others.
If you find this tutorial helpful, please consider liking and subscribing to our channel. Your support motivates us to keep creating content like this.
This video is part of a comprehensive Power Apps course on Udemy, designed for beginners to build their first apps confidently.
Enroll now to ensure lifetime access and explore the complete course. Don't forget to subscribe, like, and comment to support our channel and receive valuable content.
🎁 Full Course Link: www.udemy.com/course/power-ap...
In this video, we focus on connecting our Power App to the Excel spreadsheet we created and configured in the previous classes. We begin by closing the spreadsheet to ensure smooth functioning within Power Apps.
Next, we navigate back to Power Apps and click on "Apps" to create a new app. We choose the "Canvas" option, specifically the phone format, as our app will primarily be used on smartphones. I name my app "Power Contacts," but feel free to choose your own name.
To connect to the data source, we access the "Data" pane and search for the "OneDrive" connector. If you stored your Excel file in OneDrive, select "OneDrive" or "OneDrive for Business" based on your account type. If you stored the file in SharePoint, search for the "SharePoint" connector.
If you don't have an existing connection, you can create a new one by clicking on "Add a connection." Once connected, navigate to the Excel file by browsing through the folders. Select the Excel file and choose the table named "TB Contacts" that we created earlier.
After connecting, we add a data table to visualize the data from the spreadsheet. We configure the table to display the desired fields (name, phone, department, email, and comments) and see the data populating the table within the canvas app. We can play the app and observe how it reflects any changes made to the spreadsheet.
To ensure the app is saved, we click on "Save" and then proceed to publish the app by clicking on "Publish." Now, our app is ready to be shared and used. We can access it on make.powerapps.com and play the app, seeing the data table displaying the information from the Excel file.
Stay tuned for the next class, where we start building elements in the screens of our app. If you're new to Power Apps or looking to enhance your app-building skills, this course is perfect for you!
Power Apps Lesson 12 - 🎥 Watch the full playlist here: • Power Apps Beginner Co...
#PowerApps #AppDevelopment #SpreadsheetIntegration #DataConnection #CanvasApp #StepByStepTutorial
Keywords: Power Apps course, connecting Power Apps to Excel, Excel spreadsheet integration, canvas app development, app-building skills, Power Apps beginners, data visualization, data source connectivity, Excel data management, Power Apps tutorial, data table configuration, data display in Power Apps, app development techniques, app data storage, app development best practices, Power Apps connectivity options, OneDrive integration, SharePoint integration, Power Apps data visualization, Excel file configuration, Excel table connection, app publishing, make.powerapps.com, Power Apps sharing, Power Apps data synchronization, app data updates.

[@RudimarPowerApps]

Make sure to SUBSCRIBE so you dont't miss the next videos!!

[@sakthivels2812]

@powerrudy, thanks for the video, this helped me. One ask is that if I modify the excel everytime should I refresh the connector to the data to reflect on the app? Any way we can make it automatically refresh and show it in the app?

[@fernandamello837]

Como consigo conectar um Excel que está no share point ao invés do one drive? Tentei o mesmo processo e não funciona de jeito nenhum.

[@danielarodriguesferreira2858]

Thanks for sharing :)

[@powerrudy]

Thanks for the visit!

[@markwhite168]

Amazing thing is that in a corporate environment I put the Data table onto canvas and while the headers are there it doesn't show any data. However, if I take a file from some Microsoft example and connect to that one, the very same control displays data. I tried changing the xls data sensitivity to "Public", still no data in Data table. There is some annoying stupid feature that prevents Data table from reading Excel docs from One Drive for Business and makes using this impossible, but I can't find out what it is.

[@powerrudy]

Have you figured out why? Excel has these annoying things.. Particularly I'd not recommend do anything serious using it.. just for proof of concepts and learning. Go with SharePoint if you want to stay in the standard connectors.

[@markwhite168]

moved table to Azure SQL DB and there the stupid blocknig functionality can't kick in@@powerrudy

[@stefanocherubini]

Hi, I did a test but what do I do if I want to modify the excel file imported directly from the app? Thank you

[@powerrudy]

Not possible, you will need to connect to the excel that is somewhere else, like SharePoint or OneDrive.

[@yared5540]

unable to upload the excel file, is there any formating rule that I'm missing? Thanks for the video

[@markwhite168]

You have to format the data in Excel as table (Home, Format as table). Also if you select columns then PowerApps will complain you have too many rows (as table will have 100.000+ empty rows). It's overall very immature and annoying product.

[@yared5540]

​@@markwhite168 Thank you for taking your time, I will try to do that.

[@nigharfatima2862]

when i connect it with onedrive and then select the excel file, the table which i created in excel file did not show and showing the massage "The table didn't load correctly, please try again ", even i have checked all the thing again and again.

[@powerrudy]

Sad to hear that! Unfortunately I do not have any recommendation besides trying to setup a new file again and keep the file closed while connecting.. good luck!

[@CONG001]

you will have to select the whole table within excel then press format as a table. Home > Format as a table

[@focuswallah]

I am unavailable to connect

[@powerrudy]

What does it say?