Model Driven Power Apps Beginner Tutorial [Full Course] 2024 Edition

Ғылым және технология

Model-driven Power Apps are database applications that can manage end-to-end business data and processes at scale - think of things that run your organization, like a customer relationship management system, a grants management or permit management system, or a human resources system. In this complete course, designed for beginners, I take you step by step through how to build a model-driven Power App, covering how you can create a database and all the app elements with low code.
Accompanying materials:
✅ Download the spreadsheets with sample data and the image for the custom page here: github.com/lisacrosbie/MDA
📖 Get the full 150-page step-by-step course guide full of screenshots and bonus learning content here: buymeacoffee.com/lisacrosbie/...
Timestamps:
0:00 - Model-Driven Apps - Complete Course and Materials
1:08 - Demo What is a Model Driven Power App
6:00 - Sign up for a Power Apps Developer Plan
7:29 - Module 1: Environment Settings
10:34 - Module 2: Build Tables, Columns, and Relationships
26:46 - Module 3: Build Views and Forms
1:05:36 - Module 4: Create a Business Process Flow
1:15:33 - Module 5: Build a Model-Driven App
1:22:00 - Module 6: Import and Work with Data in the App
1:40:56 - Module 7: More View and Form Components
1:54:55 - Module 8: Create a Custom Page
2:13:30 - Module 9: Security Roles and Sharing the App
-----------------------------------------------------
Connect with me:
☕ Buy me a coffee: www.buymeacoffee.com/lisacrosbie
🦉 Learn more about AI: aka.ms/learnwithlisa
🖇 LinkedIn: / lisa-crosbie
📼 TikTok: / lisa.crosbie
🐦 X (Twitter): / lisacrosbie
📚Take my LinkedIn Learning Course: Microsoft Power Platform Fundamentals (PL-900) Exam: Power Apps / microsoft-power-platfo...

Пікірлер: 92

  • @LisaCrosbie
    @LisaCrosbieАй бұрын

    Accompanying materials: ✅ Download the spreadsheets with sample data and the image for the custom page here: github.com/lisacrosbie/MDA 📖 Get the full 150-page step-by-step course guide full of screenshots and bonus learning content here: buymeacoffee.com/lisacrosbie/e/248706 -------------------------------------------------------------------------------------------------------------- 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-fundamentals-pl-900-cert-prep-power-apps/

  • @KorniPesut

    @KorniPesut

    29 күн бұрын

    SUPER NICE THX U SO MUCH!

  • @harikaamarakota202
    @harikaamarakota2023 күн бұрын

    Highly recommended tutorial with proper content and implementation, waiting for your canvas app tutorials😊

  • @EhsanulHuq-nr1ib
    @EhsanulHuq-nr1ib2 күн бұрын

    Your tutorial was incredibly clear and well-organised. Thank you for sharing your expertise with such engaging and thoughtful presentation!

  • @ivanhmojica
    @ivanhmojica4 күн бұрын

    Great course. Very clear explanations. Thanks Lisa.

  • @user-mm1bi9qy2w
    @user-mm1bi9qy2wСағат бұрын

    I love you Lisa Crosbie

  • @MelissaCarroll-gu7lg
    @MelissaCarroll-gu7lg23 күн бұрын

    Hi Lisa, Thank you thank you. From this tuturial in 24 hours I have been able to create an app for my manager that tracks meetings, activities, tasks and people!! So powerful. I have learn't so much from all your tutorials. Please don't stop!! The back end info about security roles was extremely helpful too! The only issue I have is getting the colours into the app. In a previous tutorial you did it explained going to the classic version. I have tried both and either it's take time to sync and I'm not patient or I've done something wrong. Are you open to topics for some new tutorials? i have a long list

  • @MadeFromMud-australia
    @MadeFromMud-australia14 күн бұрын

    thanks heaps Lisa, I love your pace, your explanations and of course your aussie accent makes me feel right at home :)

  • @faulypi
    @faulypiАй бұрын

    Looking forward to this. Thanks for the great work.

  • @isvisvisvisv
    @isvisvisvisvАй бұрын

    Thanks for your work Lisa, amazing as always

  • @powerrudy
    @powerrudy24 күн бұрын

    Amazing tutorial, Lisa!!

  • @NiftyBytes
    @NiftyBytesАй бұрын

    Thank you so much Lisa, your vids are very valuable.

  • @stepstep84
    @stepstep8415 күн бұрын

    Well done Lisa. Great run-through!

  • @chh8860
    @chh8860Ай бұрын

    I am new, VERY new, to Power Apps. On a 0-10 scale, I am likely at zero. I just began the video this morning, but so far it has been quite helpful ... even though I will have to rewatch many times before I can sustain air under my wings and fly from the nest. Lisa's comprehension, content and delivery are ALL excellent. Thank you Lisa ... your timing releasing this video on this topic is perfect for me.

  • @lillyclimant3464
    @lillyclimant346429 күн бұрын

    Thank you so much Lisa. You are generous and created materials that are useful for the community. I have learnt so much about MDA only from you. Keep up the great work!💯🏆👍

  • @martinparker9093
    @martinparker909329 күн бұрын

    Fantastic tutorial, thanks for sharing this.

  • @adamjelinek5944
    @adamjelinek594424 күн бұрын

    Perfect tutorial, can highly recommend! 👍

  • @trenier019
    @trenier019Ай бұрын

    Awesome video!!!

  • @faulypi
    @faulypiАй бұрын

    Great tutorial Lisa. This has been a very useful update. I got through it in two sittings. It flowed quite well.

  • @jaapjager5878
    @jaapjager5878Ай бұрын

    This was a really great experience and gave me a kickstart in building my own app. Thank you so much

  • @Morganjs1
    @Morganjs129 күн бұрын

    This is an excellent tutorial, the approach of building something practical and explaining as you go works really well. Thank you so much for doing this.

  • @AndresBC-qb2ns
    @AndresBC-qb2ns15 күн бұрын

    I've just seen it all the way through. Nice tutorial. Thank you for sharing!

  • @es7995
    @es7995Ай бұрын

    Nicely done Lisa. Feel like I have a very good understanding of the model driven power app. Love that you didn't edit the video. Mistakes, slow saves and the like are all part of it. Keep up the good work.

  • @adyutsady118
    @adyutsady118Ай бұрын

    well done! keep it coming :)

  • @GoHokie
    @GoHokie23 күн бұрын

    Thank you!

  • @DanOrian-sd9dl
    @DanOrian-sd9dl14 күн бұрын

    Getting more familiar with your Content to add to previous video. Navigating where, what and how I can apply them to my data.👌 Thank you well done.

  • @saumitrsharma2393
    @saumitrsharma239314 күн бұрын

    Wonder full explanation well done Lisa, I have followed the steps and implemented the same

  • @andrewgibson3684
    @andrewgibson3684Ай бұрын

    Thanks so much for this Lisa. We have included a link of your video on our internal SharePoint site as a learning resource for our development team and citizen developers.

  • @vaibhav2741
    @vaibhav27413 күн бұрын

    Useful contents

  • @dougydoe
    @dougydoe29 күн бұрын

    Finally downloaded the resources and the step-by-step guide/manual as well. A little price to pay for your hard work in equipping us. Hopefully, I can fill the gaps in my MDA skills. Thanks for sharing.

  • @diegoecoo
    @diegoecooАй бұрын

    🥰Wow! you are a very generous person for sharing your knowledge with the community. From Buenos Aires (Argentina) I send you greetings! 🥰

  • @mtamitolanga
    @mtamitolangaАй бұрын

    Thank you very much for sharing this updated version. I like how fast and simplified one can create tables in Dataverse. I'm currently working on a Helpdesk solution and struggling with deciding whether to use model-driven or canvas for my app. I've seen Helpdesk templates and other tutorials using canvas and perhaps I should use canvas. Do you know of any tutorial or template that I can follow for model-driven? I'd really like to use model-driven. Thank you.

  • @DHINAGARANASHOKAN
    @DHINAGARANASHOKANАй бұрын

    Good one

  • @ashishramkisson9942
    @ashishramkisson994221 күн бұрын

    Not all heroes wear capes. What a legend 💪

  • @SothearithKONGMrMuyKhmer
    @SothearithKONGMrMuyKhmer19 күн бұрын

    Thanks so much, Lisa! 🥰

  • @SothearithKONGMrMuyKhmer

    @SothearithKONGMrMuyKhmer

    15 күн бұрын

    Dear Lisa, I have a question; if I build an app using an environment (with my name instead of the company’s environment), will all the information I put into the app and store in Dataverse be accessible by others (outside of the company). Thank you!

  • @junahs95
    @junahs95Ай бұрын

    Watched the tutorial back from 2022 a couple of weeks ago. Excited to watch this one!

  • @LisaCrosbie

    @LisaCrosbie

    Ай бұрын

    Awesome, enjoy! The core skils are the same but this is a different scenario, so extra practice and some new things like Custom Pages.

  • @mohammedusmaan967
    @mohammedusmaan96712 күн бұрын

    Just finished building the app, about to post on linkedin. will also tag you

  • @LisaCrosbie

    @LisaCrosbie

    11 күн бұрын

    Thank you and thanks for the post - appreciate that 😎

  • @ahmet-ozkaya
    @ahmet-ozkayaАй бұрын

    I just finished old version yesterday, I missed some points due to version issues. 😂😅😮Great tutorials. 🎉🎉🎉 Thanks 🙏

  • @Dmarquesinfo
    @DmarquesinfoАй бұрын

    Great video Lisa. Would like you to have explored in more detail the permissions part. Per example, is it possible to limit a user to a certain step in the business process flow? That would be great to create some kind of approval process without using power automate.

  • @LisaCrosbie

    @LisaCrosbie

    Ай бұрын

    Thanks, great ideas for other videos. (and no you can't restrict a user to a certain step in the business process flow, I think the closest is you could restrict access to editing a field that is required to move it along)

  • @Dmarquesinfo

    @Dmarquesinfo

    Ай бұрын

    That would help :)

  • @stepstep84
    @stepstep8415 күн бұрын

    Thanks!

  • @LisaCrosbie

    @LisaCrosbie

    14 күн бұрын

    Thank you so much, really appreciate that.

  • @TheBetterDataSME
    @TheBetterDataSME9 күн бұрын

    This was a very good tutorial - thank you. Quick question - have you experienced the business process workflow not showing up on the form? When I inspect the Application form I get this: Cannot read properties of null (reading 'colorNeutralBackground1') .

  • @tetopp4219
    @tetopp4219Ай бұрын

    I love you Lisa♥

  • @CMPP365
    @CMPP36529 күн бұрын

    Smashed it in one sitting! Thanks as always Lisa.. a quick reminder to all that the date format in the 'application' CSV file is US, it might only import 11 records or throw an error. Such a useful and up to date newbie video, Thank You!

  • @LisaCrosbie

    @LisaCrosbie

    27 күн бұрын

    Thanks yes, I have my environment settings here set to US to match the spreadsheet because that’s where most of my viewers are. But in real life here in Australia both my environment and spreadsheets use dd/mm/yyyy

  • @trstrean
    @trstreanАй бұрын

    Great video! You hit on a question I've been having about choosing between the User table and Entra table. Could you do a video that explains why someone would choose one or the other? In my organization, the User table includes far more info and pre-designed views and forms and I think it also includes the Entra ID which could be used for getting related info. Neither table had manager or org info which would have been nice for the hierarchy to generate.

  • @LisaCrosbie

    @LisaCrosbie

    Ай бұрын

    I’ve had a lot of requests for this, it’s on my (long!) list. Essentially user only gives you the licensed users in the environment- so if you have an app or environment that is used organisation wide or where the lookup is only needed to connect people who use the app you can use that. But if you want everyone including unlicensed users you need to use the Entra ID table

  • @kingsk9090
    @kingsk909010 күн бұрын

    Thank you for the amazing tutorial. Does anyone know the data type or FX fomula for Time Only colunm in a table. I am using dataverse as my database🙏

  • @faraikepekepe
    @faraikepekepeАй бұрын

    Let's go! Again

  • @kevinpham1645
    @kevinpham164521 күн бұрын

    Great course! However, I'm struggling to map employee email to entra id lookup field via dataflow in dataverser. I have a dataflow in dataverse connecting to sql server. The data i get back has an email field. I want to map this field to the entra id lookup field (called EmployeeAAD) in my dataverse table, i don't see anyway for me to map this. I don't see the EmployeeADD as a field to map to. Any suggestion or way to map this?

  • @andrewgibson3684
    @andrewgibson368429 күн бұрын

    Hi Lisa, One little thing for anyone with a dd/mm/yyyy format on their computer is the import of the applications file might fail (eg 05/25/2024). Not sure if you want to add in another file for non-US date formats, or change the existing files days of the month to all be 12 or under?

  • @LisaCrosbie

    @LisaCrosbie

    27 күн бұрын

    Good suggestion, I’ll add on a different version of the file in the dd/mm/yyyy format for those outside the US (that’s the format I normally work in)

  • @aimannishat2120
    @aimannishat212016 күн бұрын

    I have 1 question if we want to import data here from any other source apart from Excel then how can we do that? Suppose if we want to add data from SQL.

  • @satorareteku
    @satorareteku22 күн бұрын

    Wondering if I could make "Service Request" form approval process using this guide. Much thanks for a tutorial!

  • @LisaCrosbie

    @LisaCrosbie

    22 күн бұрын

    Yes, you totally can, that’s a great use case. My older version of this tutorial is an asset management app, that might also help with ideas

  • @satorareteku

    @satorareteku

    21 күн бұрын

    @@LisaCrosbie, Thank you! And as said in 2:40 do you need a premium license to use an “app” or do you need it for “premium objects in app” like in canvas app?

  • @LisaCrosbie

    @LisaCrosbie

    20 күн бұрын

    All users will need a premium or per app license for a model driven app.

  • @marymuthonimarete7440
    @marymuthonimarete744011 күн бұрын

    I am having difficulties importing csv into dataverse. Anyone with a resource I can read about how to?

  • @nadiadorkenoo9395
    @nadiadorkenoo939528 күн бұрын

    Hi Lisa, Thank you very much for this presentation I'm living in France and English is not my first language Excuse me if my English is not correct. I started with Power Apps to create an application for monitoring the activity of a team of medical visitors. I didn't have a good maitrise of the tool and since I discovered your videos they have helped me enormously because they are very detailed and very informative. Thanks you very very much.😊😉 I discovered the concept of "Model driven apps" with your presentations. Personally I start developeding my application from nothing and trust me It no easy!!!! I have a question please if you can help me I'm will be very grateful 🥰🤩 How do I allow my users to use the application? Every time after 30 days they receive a message that says your license has expired. Request a new license" I am developing the application so I have a "Power Apps Premium" license. Do I have to buy a license or subscription from them? Thanks you Lisa 😘and see you soon

  • @LisaCrosbie

    @LisaCrosbie

    27 күн бұрын

    Every user will need a paid Power Apps per app or premium license Well done on building you app, and wishing you every success with it.

  • @AlbertoAcero
    @AlbertoAceroАй бұрын

    Hi Lisa, thanks for sharing your knowledge. My question: I created a form (service request) that users must fill but once they "send" the form (change the status of the form from "created" to "in process") I need to change the user permission from edit to read-only so they can check the status of their request but not change any info. How you do that in model-driven apps? (Greetings from Colombia)

  • @LisaCrosbie

    @LisaCrosbie

    27 күн бұрын

    The simplest solution is that you set the role permission on the table to “create” but then no permission to “write” (edit). Would that solve it?

  • @mrgiant7926
    @mrgiant7926Ай бұрын

    Hi Lisa…great video. Do you cover importing excel? I am having a nightmare trying to import data. If I do a create table from excel I only get 20 rows (out of 300) and the import wizard won’t map columns…I am a bit of a loss

  • @LisaCrosbie

    @LisaCrosbie

    Ай бұрын

    This might cover what you need? How to Turn Your Excel Spreadsheets into Power Apps kzread.info/dash/bejne/n6J82rVuiKeemsY.html

  • @mrgiant7926

    @mrgiant7926

    Ай бұрын

    @@LisaCrosbie thanks, I'll take a look. I'm up to about 6 hours online with MS cust servs and no progress!

  • @mrgiant7926

    @mrgiant7926

    Ай бұрын

    @@LisaCrosbie thanks...followed it, only 20 rows :(

  • @DHINAGARANASHOKAN
    @DHINAGARANASHOKANАй бұрын

    When user enters 3 to 4 fields and hit save mandatory fields required validation is not allowing to save the records.is there any way where user can enter the value and save the records.our validation on required fields should stop users not to move from stage to stage but it should let user to save the records. Is there any possibility to do this in model driven app. Thanks.

  • @LisaCrosbie

    @LisaCrosbie

    Ай бұрын

    No, if you make a field mandatory it's mandatory, you can't save the record without it, that's how it works. Does anything in this video help with ideas studio.kzread.info0tNQLj7uKwQ/edit

  • @AhmedBalfaqih
    @AhmedBalfaqih12 күн бұрын

    Brilliantly planned and delivered, everything went well with every first attempt, which is rare. However, when I reached the part where we could import the Excel data, Power Apps flashed, and nothing appeared. I tried everything related to Excel with the same result: Just a quick flash, and it disappears. I tried to find out what was happening and searched online but could not find any answer. Do you have any idea why? Thank you anyway. BTW, I got the 150-page content.

  • @LisaCrosbie

    @LisaCrosbie

    11 күн бұрын

    That’s strange; I haven’t seen that problem before. Try a different browser, make sure your pop ups are enabled? Otherwise try the community forum to see if anyone else has had and sorted a similar problem

  • @AhmedBalfaqih

    @AhmedBalfaqih

    11 күн бұрын

    ​@@LisaCrosbie@LisaCrosbie, I have no issues with pop-ups as parts of your video trigger them. I tried MS Edge and changed the environment to no avail. My last resort will be the community.

  • @AhmedBalfaqih

    @AhmedBalfaqih

    7 күн бұрын

    @@LisaCrosbie I posted the issue to the community 3 days ago. Today, someone answered. Basically, I had to switch to the classic view and then back to the new view, and it worked.

  • @Spotlight.Data.Analytics
    @Spotlight.Data.AnalyticsАй бұрын

    In only 12 hours, you got nearly 1500 views! Shows you how much we appreciate and respect you, Lisa! Thanks for this amazing tutorial.

  • @LisaCrosbie

    @LisaCrosbie

    Ай бұрын

    Not bad, so glad people are finding it ☺️

  • @jacobjoseph2005
    @jacobjoseph2005Ай бұрын

    Not able to sign up for the PowerApps developer plan for free. Still showing signup with work or school account. Is there anything more to be done?

  • @LisaCrosbie

    @LisaCrosbie

    Ай бұрын

    You're right, you need a work or school account. The best way around it is to sign up for a trial of Microsoft 365 E3, then use that account to sign up for the Power Apps developer plan.

  • @nishitmaheta
    @nishitmahetaАй бұрын

    Can you help me find a best course for Dynamic 365 CRM ? not much course and content is available on internet.

  • @LisaCrosbie

    @LisaCrosbie

    Ай бұрын

    Try this one of mine, let me know what else you are looking for. I also have a configuration video. Microsoft Dynamics 365 Sales (CRM): Tutorial for Beginners kzread.info/dash/bejne/ZYCa1ZefccaXkrg.html

  • @nishitmaheta

    @nishitmaheta

    Ай бұрын

    @@LisaCrosbie i am looking for Fundamente certificate course for Dynamics 365 CRM. i will go through of your video play list . if you have good source or course available same as power apps do share with me . happy to have a coffee ☕

  • @LisaCrosbie

    @LisaCrosbie

    19 күн бұрын

    I’m working on it.

  • @alam0
    @alam029 күн бұрын

    unable to upload application file getting error

  • @LisaCrosbie

    @LisaCrosbie

    27 күн бұрын

    Is your environment in did/mm/yyyy format? If so you’ll need to change the dates on the spreadsheet. I’m uploading a different version in that format shortly.

  • @alam0

    @alam0

    26 күн бұрын

    ​@@LisaCrosbie i've change my time zone same as you did in the video, but still facing same issue. Invalid OptionSet Error code: 0x80048403 Session Id: d9d65e2a-c14d-47b2-a9eb-8692320a678f Activity Id: a5bbec14-df43-458b-961f-08b51eb428ea Time: Sun May 05 2024 13:55:07 GMT+0530 (India Standard Time)

  • @LisaCrosbie

    @LisaCrosbie

    19 күн бұрын

    Invalid option set sounds like something is wrong in the option set mapping. Are the values you’ve used exactly the same as what I did? Did you go into the option set when you do the mapping to check that the values match?

  • @xarzu
    @xarzu29 күн бұрын

    Do the Brits think the American accent is awesome as I think your accent is?

  • @LisaCrosbie

    @LisaCrosbie

    28 күн бұрын

    But I don’t have an accent, you do 😂