Let's Convert an Excel to Power Apps with SharePoint!
Hi everyone! 👋 Let’s wrap up 2024 with a practical tutorial to answer your questions and get you ready for 2025! Let's convert an Excel to a SharePoint list powered by Power Apps!
Part 2: • Converting Excel to One to Many with ...
We take a practical Power Apps Example to gather requirements.
In this video, we’ll show you how to take an Excel document—like a fire department radio inventory—and turn it into a fully functional SharePoint list. 📝➡️📂
We’ll explain why we avoid the out-of-the-box Excel-to-SharePoint upload button ❌ and instead walk you through best practices:
✅ Manually creating columns for better control.
✅ Copying and pasting your data to ensure clean, accurate results.
✅ Using a Solution for your Power App
This method gives you a well-organized list, ready for automation and workflows. Perfect for streamlining your processes as we head into the new year! 🚀
Let’s dive in!
Chapters
0:00 Introduction
0:38 Requested Power App Requirements
4:15 The Excel Data
5:32 Why I dont use From Excel Easy Button
7:24 How I Import from Excel
10:10 Create a Solution
12:00 Using Table and Form
14:04 Create a Save Button
17:30 Adding a People Picker
19:45 Adding another list that relates
23:22 Using a One to One LookUp
24:35 Conclusion
