How to Turn Your Excel Spreadsheets into Power Apps

252,420
0
2023-06-05に共有
#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:
☕ Buy me a coffee: www.buymeacoffee.com/lisacrosbie
🦉 Learn more about AI: aka.ms/learnwithlisa
🖇 LinkedIn: www.linkedin.com/in/lisa-crosbie/
📼 TikTok: www.tiktok.com/@lisa.crosbie
🐦 X (Twitter): twitter.com/LisaCrosbie
📚Take my LinkedIn Learning Course: Microsoft Power Platform Fundamentals (PL-900) Exam: Power Apps www.linkedin.com/learning/microsoft-power-platform…

コメント (21)
  • @callielampe203
    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.
  • 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.
  • Great video, Lisa! Thanks so much for sharing your knowledge.
  • @studie75
    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.
  • Amazing content getting to where I want to go with my data transformation but still have to watch more of your content. Thank you!
  • @jrdnknx3840
    Thank you so much for breaking this down for me!!!!
  • 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!
  • @tabc6870
    When I'm searching for a topic I click on your video first. LOVE all your content.
  • 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.
  • @nunolopes3910
    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 :)
  • @SJV992
    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.
  • @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 👏
  • 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.
  • Thanks for the intro...looking to move away from MS Access so this gave me some hope :)
  • @sgronniger
    Love the Lego collection in the background!