How to Turn Your Excel Spreadsheets into Power Apps

#dataverse #powerapps #copilot
In this video I show you how you can get your spreadsheet into a Power App (and a Dataverse table) in just a couple of clicks with the new Copilot for Power Apps. For more complex "mission critical" spreadsheets with data relationships, I show you how you can go further by creating and relating multiple tables and importing your data into Dataverse and working with it in Power Apps.

0:00 - Moving from Excel to Power Apps
0:30 - Create Power Apps from Excel with Microsoft Copilot
5:50 - Testing and Editing the Canvas App
9:23 - Working with spreadsheets with multiple tables
11:30 - Configuring the Dataverse Contact table
13:40 - Working with Solutions
16:02 - Alternate Keys
17:20 - Create a Dataverse table from Excel
21:02 - Create a data relationship between tables
22:41 - Create a view and a form
25:39 - Create a model-driven app
27:03 - Import your data from Excel into Dataverse
31:48 - Update your Canvas App
32:28 - Learn more about model driven Power Apps

-------------------------
Connect with me:

[callielampe]

Thank you so much for this training. I've been trying to wrap my mind around this with more real life examples and this helped tremendously. Also, I love your teaching style and your ability to communicate clearly. Thank you for that. I'm looking forward to watching your longer video as soon as I have a chance.

[mattsnow]

You are a great presenter Lisa. I'm totally new to this universe so I have a lot of learning to do about use cases and how to do things properly. I appreciate your energy and style-thanks very much.

[studie]

Hi Lisa, I have checked multiple MVP's about this particular topic (turning an Excel sheet into PowerApps) and I would like to compliment you on your work. I could 't really understand and get this technique into practice AND understand every step and reasonings, but your extensive way of explaining this concept and every little step taken into account, really helped me to understand everything. You really stand out and I really appreciate it and like it that you take the time to help us understand. Just wanted to give you my sincere compliments I am so happy I dropped by your channel, because it helped me to reproduce it in my own environment AND understand the concept behind it. Thank you for helping us to get better! You rock! You made it look easy for me now (and I was struggling)!

[MawuviCan]

You teach so well and the excitement in your voice makes the learning experience interesting. Thank you.

[titahaver]

You are just amazing Lisa. The way you present, speak and demo is just simply so easy to understand. 🤩

[markfeetham]

Oh My. I've struggled for 2 weeks with this. Raised a request with Microsoft...told me that my import was wrong. Contacted old friends at Microsoft that showed me a convoluted method of exporting then merging then reimporting the data to get it to link. Your amazing because spending the time watching this free video resolved it ALL for me. Thank you so much! Learning from Lisa - This is the way!

[belizatube]

Great video, Lisa! Thanks so much for sharing your knowledge.

[theadventuresofred]

There's so much happening in the MS stack at the moment, thanks for all your work making it accessible to the rest of us.

[DanOrian-sddl]

Amazing content getting to where I want to go with my data transformation but still have to watch more of your content. Thank you!

[nunolopes]

Thank you for the clear explanation Lisa, this was a great video to get some more insight on how this applications work in the back-end side. I work with CRM, and now I have a better idea on how some aspects of the application are developed. Thank you :)

[tabc]

When I'm searching for a topic I click on your video first. LOVE all your content.

[jrdnknx]

Thank you so much for breaking this down for me!!!!

[debabylex]

Thank you so much for this video Lisa. I've done the self paced online training but got really stuck with importing choice columns and specifying the correct column for lookup. This is just what I needed! Really amazing 👏

[PianoDentist]

From one Functional to another; you explain this very well Lisa - whilst avoiding mentioning CRM or ALM explicitly. 😉 As an old timer, who is habitually used to reaching for the legacy CRM designer experience, this is really helpful.
Love the idea of having the choice of a canvas or a model-driven app based on the same tables in Dataverse. Incidentally, for readers of Lisa's comments: These apps can be consumed via a web page, a mobile device or a power apps SharePoint web part.

[SJV]

Great explanation Lisa, this will be invaluable for me in my role. I have no hesitation in subscribing to your channel and look forward to exploring more of your presentations. You have a great presentation/training style that's easy to follow. Thank you.

[kdmgnqt]

Hello Lisa, Thank you for such a nice tutorial. I had no experience with Powerapps but i have completed a vulnerability tracking app assigned by my organization. Love your work and really really appreciate.

[sgronniger]

Love the Lego collection in the background!

[wlyxgsh]

Thanks for the intro...looking to move away from MS Access so this gave me some hope :)

[Manas]

I'm a big fan of your YT courses. You explain them so well..!!
One query - I have an excel with more than 200K data rows. And when followed your process to convert the excel to app, I'm not getting all the data. Is their any data/size restriction?
If yes, what is the best way to import such a big file to the app and update the same frequently (weekly)??

[colarguns]

Hi, thank you for your help on this! I am (trying) to build a workbook that will help small business owners. Once completed, I intend to sell it, but it seems I have no clue on how to correctly protect that workbook, as there are many apps that will crack the code! Would you have any advice on that? Thank you