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...

[@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]

SUPER NICE THX U SO MUCH!

[@MelissaCarroll-gu7lg]

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

[@isvisvisvisv]

Thanks for your work Lisa, amazing as always

[@faulypi]

Looking forward to this. Thanks for the great work.

[@stepstep84]

Well done Lisa. Great run-through!

[@powerrudy]

Amazing tutorial, Lisa!!

[@dilipsolanki7856]

Thanks Lisa for this wonderful session. :)

[@NiftyBytes]

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

[@adamjelinek5944]

Perfect tutorial, can highly recommend! 👍

[@AndresBC-qb2ns]

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

[@ivanhmojica]

Great course. Very clear explanations. Thanks Lisa.

[@faulypi]

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

[@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.

[@MadeFromMud-australia]

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

[@martinparker9093]

Fantastic tutorial, thanks for sharing this.

[@jaapjager5878]

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

[@Morganjs1]

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.

[@trenier019]

Awesome video!!!

[@saumitrsharma2393]

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

[@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.

[@lillyclimant3464]

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!💯🏆👍

[@harikaamarakota202]

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

[@dougydoe]

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.

[@DanOrian-sd9dl]

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.

[@adyutsady118]

well done! keep it coming :)

[@diegoecoo]

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

[@EhsanulHuq-nr1ib]

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

[@junahs95]

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

[@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.

[@GoHokie]

Thank you!

[@user-go8rk5nv9w]

please upload in 1440 px clarity of content matter btw your videos helped me a lot and a lot of thanks to you Lisa. Keep up good work.

[@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.

[@SothearithKONGMrMuyKhmer]

Thanks so much, Lisa! 🥰

[@SothearithKONGMrMuyKhmer]

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!

[@DanielWesterdale]

Excellent tutorial, packed with features that are easily overlooked such as changing the default lookup views. Also being to add the Power Apps grid component from the modern look ( finally). Great you don't need Typescript to build a fully functioning model driven app. .

[@vaibhav2741]

Useful contents

[@jacksonwahomemuthui2687]

Thanks Lisa. Followed to the end.. proud of myself and you as well . I only need to work on it be responsive on power apps mobile.. the Copilot feature is also absent on power apps mobile..

[@ahmet-ozkaya]

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

[@DHINAGARANASHOKAN]

Good one

[@stepstep84]

Thanks!

[@LisaCrosbie]

Thank you so much, really appreciate that.

[@sajidyusuf]

Hi Lisa, Are you planning to add a section on using JavaScript in model driven Power Apps? I think it is very much needed to gain control of things like filtering lookup column values.

[@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.

[@CMPP365]

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]

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

[@mohammedusmaan967]

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

[@LisaCrosbie]

Thank you and thanks for the post - appreciate that 😎

[@user-mm1bi9qy2w]

I love you Lisa Crosbie

[@TheBetterDataSME]

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]

I love you Lisa♥

[@ashishramkisson9942]

Not all heroes wear capes. What a legend 💪

[@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]

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

[@nabilsidrak4495]

Hi Lisa, great video, would it be possible to use model-driven app to connect to a SQL database to get the model-driven app tables updated automatically by running SQL queries

[@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]

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]

That would help :)

[@faraikepekepe]

Let's go! Again

[@kingsk9090]

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🙏

[@kevinpham1645]

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?

[@satorareteku]

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

[@LisaCrosbie]

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]

@@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]

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

[@aimannishat2120]

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.

[@andrewgibson3684]

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]

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)

[@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]

Not bad, so glad people are finding it ☺️

[@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]

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?

[@nadiadorkenoo9395]

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]

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.

[@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]

This might cover what you need? How to Turn Your Excel Spreadsheets into Power Apps kzbin.info/www/bejne/o5-rqYZrjalroMU

[@mrgiant7926]

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

[@mrgiant7926]

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

[@marymuthonimarete7440]

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

[@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]

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.kzbin.info0tNQLj7uKwQ/edit

[@dichternebel01]

Hi Lisa, maybe I oversaw something but on kzbin.info/www/bejne/fqOsfZaefduAi6M the form "Information" is prepopulated but this form is not created yet in this tutorial or am I wrong?

[@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]

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.

[@AhmedBalfaqih]

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]

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]

​@@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]

@@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.

[@tanyash.5353]

I got stuck on Data Step1. In the Data Field drop-down list there was no "Screening call date" option.

[@LisaCrosbie]

You have to have already created that field before you go into the business process flow designer, perhaps you missed that? Go back to the solution and check for that field and add it if it isn’t there.

[@nishitmaheta]

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

[@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 kzbin.info/www/bejne/aX3JpGicdshkmLc

[@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]

I’m working on it.

[@alam0]

unable to upload application file getting error

[@LisaCrosbie]

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]

​@@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]

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]

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

[@LisaCrosbie]

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