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/
Thank you so much Lisa for creating this fantastic video. Your explanations is clear, easy to understand, and delivered in a natural way. The content is very accurate, and I've learned a lot from it.
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.
I have been away from power apps for years and needed to get up to speed quick for a clients project. Wow! Your course is amazing. Thanks for saving me days of searching to find something that barely covers any of what you covered.
This is superb! Before I can get into the depths of Model-Driven Apps, I wanted a primer, something that covers all the basics end to end. I know I will not remember everything I have learnt here, but this video helps in bringing together all the puzzle pieces and gives you an introduction into the world of Model-Driven Apps, the right way. I am so grateful to you, Lisa. Can't thank you enough. It shows that you have put your heart and soul into creating this tutorial, your hard work speaks for itself, keep them coming! Thanks again.
This tutorial has been a game-changer for me (as it seems to have been for others). I feel like I've learned a lot & it has opened my eyes to a few things. Your delivery and the content itself is excellent - thank you!
Lisa, thank you for this guide, I watched in bite-sized chunks while eating lunch! First viewing to take it all in, second will be as I go along and attempt to recreate! Thanks for being comprehensive, understandable and honest, it is much appreciated. One question I've got is could you do a model driven app using Lists rather than Dataverse tables, as that's where all my info lies at the moment?
You can use lists as virtual tables in Dataverse and build your model-driven app on top of that - have a look at this video: th-cam.com/video/mEZSsx8B5HE/w-d-xo.html
This tutorial is fantastic! Lisa's clear explanations and step-by-step guidance make learning Model-driven Power Apps so much easier for beginners. Thank you for sharing your expertise and helping us build our skills! Looking forward to more tutorials from you!
I have found it incredibly useful. In fact, I have a project to develop, and this course covers 50% of it. The other 50% will involve developing an application for employee management once they have been hired. Do you have any tutorials for this? It would be great to have them; additionally, I need to know how to integrate both systems so that they function as one. This way, a user with the appropriate permissions would only see the recruitment section, while Human Resources would have access to the other section, and the general administrator would be able to see both. I greatly appreciate you taking the time to share your knowledge and help us. Of course, I would be happy to buy you a coffee.😊
I don’t have a tutorial for employee management but you can use the same principles as shown here to create your data model and app. You can use the same environment and create a new app with additional tables and its own navigation for that employee management side, then control the permissions with user roles so only the right users have access to that other app and the tables it uses. Good luck!
Thanks so much Lisa... great presentation as usual. I had an issue in that the search bar is replaced by a magnify glass, but I assume that is because of "version" that my company uses... I have seen that this type of view has changed over time that my organisation has been developing their D365 migration
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..
Hey Lisa, I am a big fan of you in the power platform conference last year..I've been following your tutorials on creating Model-Driven Apps and I'm currently developing an ERP system using this platform. I've found your videos incredibly helpful and informative. However, as I delve deeper into the project, I'm starting to have some concerns about the potential costs associated with Dataverse storage. I understand that 1 GB of storage is currently priced at $40 per month, but I'm struggling to grasp how much data that actually represents in practical terms, especially when considering storing invoices and receipts data (not documents), and other relevant information for an entire ERP system. I would greatly appreciate your insights on data usage and cost optimization and tips and I'm particularly interested in your opinion on whether proceeding with Model-Driven Apps for my ERP is the most cost-effective and efficient solution in the long run. Thank you for your time and expertise. I look forward to hearing from you.
Great tutorial! Thanks for that! But .. am I correct in seeing two Application tables? I've found a System table and a Custom one (my own). This caused me some confusion when adding the tables to the app at 1:17:45. I couldn't find an option not to show system tables and the interface has changed a bit when selecting tables. I ended up selecting them both and in the navigation pane removing the one that gave me a blank page instead of the Active Applications view. Also, I couldn't find the icons you are using but that's not an issue at all. Nonetheless a fantastic tutorial! Love to see more.
I’ve checked one of my environments and you’re right; there is a standard Application table. One option if it’s confusing is to change the display name of your table to something like “Job Applications”. So hard to have content that keeps up with the user interface changes but glad you were able to find your way through it.
@@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?
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.
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
@@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.
@@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.
I set up the template in US date format because my environment is in the US. If your environment is in DD/MM/YYYY format then change the dates in the spreadsheet to that format before you import.
Hi Lisa, maybe I oversaw something but on th-cam.com/video/HrILchHvMUA/w-d-xo.html the form "Information" is prepopulated but this form is not created yet in this tutorial or am I wrong?
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)
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.
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 th-cam.com/video/3Lfs5fAc1bU/w-d-xo.html
@@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 ☕
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.
@@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)
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?
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
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') .
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.
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)
Hi Lisa, another one of your fabby guides! Thank you for creating this. I do have a question though, the Appointments button - was the plan to hook that into the data for Interview dates?
Thank you very much Lisa for the tutorial, very informative and clear explanation of all the topics included. Hoping for the further "Solution Deployment"(Pipeline) Tutorial from you
About the 1:41:35, you press the + button and able to call the quick create form (Application) but I cannot see the option for Application. I only have "Contact". Do you know what step I missed?
Hi Lisa, in 1:26:07 when I play my app to create new application the opening screen is totally empty,I cannot create new application. Contacts and Roles work fine.I have followed all steps to create tables, views and forms. Can you help me,why is this happening? Thanks in advance!
hello I have a question. I would like to know how to create a powerapps model-driven app and then connect it to MS Project with data. Can you tell me how?
Please could you do a video dedicated to security.. it’s driving me insane 😂 I can’t wrap my head around it all. Do I set security roles in the Dev and import them to prod.. do assign users in dev and deploy to prod? How does teams work? It just feels like an absolute mine field with no clear guidance anywhere😢
I noticed i could not do the update form and views at my end. I didnt see the update icon. Though i tried creating my own columns and all (There are no forms associated with the selected tables).
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.
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.
hi i want to thank you for all your effort it help me a lot to understand the subject , keep going on that is realy helpfull for people who want to learn the subject
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?
Hi Lisa, great videos - thanks so much for putting them together, they have been really useful for me and my team. Do you have any videos on setting up pipelines (Dev>Test>Prod)?
An excellent video! Thoroughly enjoyed the course, many thanks Lisa! I had a minor issue importing the Applications.csv file, but I realised that is due to the 'Interview Start Time' being in US date format, whereas I needed it to be in dd/mm/yyyy hh:mm (UK format), but once you change the dates to the desired format, it works perfectly! Thanks.
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.
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
Thank you so much. It really helped to understand the Model driven apps. The Copilot search did not work though I have followed all the configurations suggested. Any suggestion on this?
Sorry this isn’t a good forum for troubleshooting. Perhaps post in the Power Apps Community forum or see if anyone else has had a similar problem there.
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
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.
My notes 34:56 - Set up fields for search | Quick Find Active ... 37:50 - Important steps before creating a table (check out the option for 'Creating a new activity') 40:10 - Changing the name of Primary Column of a new table (to preferably make it an autonumber) 49:56 - Creating Relationship between tables 01:20:26 - Enabling Global search bar in the model driven power app, by checking off the option 'Enable offline Classic' 01:24:15 - Setting up timezoe for each user 01:26:02 - HOW THIS APPLICATION IS USED AND WHAT IS TIMELINE 01:29:08 - Import the data from excel 01:33:10 - Log of previous uploads 01:34:10 - Importing a table with relationship to other table 01:39:04 - End user can customize to add or remove fields of their choice in the view 01:41:35 - Quick create form. To quickly add data into a record without actually clicking the record and launching the main form. This should appear side by side of a record just by hovering (check). 01:43:26 - Quick create View. Small window of data to view the records side by side inside a record (read only). Create this on the table inside which records are saved then add it in the other table to show extra RELATED records from another table. e.g. If we want to show candidate's info in the application table, create a quick view form in the candidate table, but show it side by side inside the main form of application table by selecting related items (01:45:58). 01:47:07 - Control what fields of lookup table you want to show in the intellisence drop down (max 3 fields allowed for nice legible view) 01:48:51 - Show sub-grid. i.e. inside a view, show all related records from other table 01:52:19 - PowerApps Grid Control - Beautify with colors 01:54:11 - Aggregation of fields is also allowed. Not covered in this one, try and research more. This can be useful. 01:55:00 - Custom Pages - These are like canvas app design within the Model Driven PowerApps solutions to show as a welcome page or any summary page we want. Basically a functionality to use canvas apps inside model driven solution 02:17:13 - Security Roles and Privileges - Hierarchical organizational level roles and the accesses. Read more about what are they, rather than how are they used. Also find out which environment it should be done at (development or production). 02:19:50 - Share the app with the user. Please not that security role is assigned first before sharing the app. Also find out how can we create groups of people to share the apps at once rather than individually sharing the app.
Hello Lisa, thanks for putting these tutorials together, I have learnt heaps from them so appreciate you sharing your knowledge. I have a question regarding M:M relationships and whether you can store an attribute with this relationship. I'm in a situation where I have project managers related to clients, I would like to store some information about the relationship that exists between these two, for instance the type of relationship. Is this possible or do I need to build the 'cross over' table my self and manage with a M:1 and M:1? Look forward to hearing how this might be done.... and if you looking for another example for a tutorial, a basic CRM would be nice 🙂.
What you’re looking for is called an “intersect” table. If you use the out of the box N:N relationship there is an intersect table automatically created to make it work but you can’t add any fields to it. If you want to store data in that intersect table you need to create 1:N both ways. I’ll add this to my video list but in the meantime this is a really good explanation of the concept (old UI screenshots but the concept is still the same). carldesouza.com/understanding-intersect-entities-and-nn-relationships-in-dynamics-365/
This is a great place to start when you know nothing about Power Apps. Thank you so much for putting this out there Lisa. I watched the complete tutorial and had the working app at the end. In the beginning of the tutorial (~11:10), you talk about packaging the solution and moving it around to test or debugging environments. Do you have a tutorial about how to do that? Again, thank you for making this available.
Amazing work Lisa, I’ve been following you for months and I always learn something new from you on each video. May I suggest a video on using JavaScript for web resources?
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?
Thank you, Lisa, for providing this tutorial at no cost. I must say, I learned a great deal from this two-hour video, which kept me captivated throughout the session. It would be excellent if you could create a video explaining the various security roles, detailing the differences between them, such as the capabilities of a Basic User compared to an Environment Maker, and identifying the highest level of role, among others.
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!💯🏆👍
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.
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.
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. .
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.
Fantastic content Lisa! I'm developing my first model driven app and this is very applicable to the project goals I have. Really appreciate the excellent relational database concepts presented here also. Bravo!! 👏👏👏👏
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
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.
Lisa glad to see you with this course please can you make a full detail video on Microsoft dataverse model driven copilot with full functional app it will help a lot to every body on yt who is following your videos
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/
SUPER NICE THX U SO MUCH!
Thank you so much Lisa for creating this fantastic video. Your explanations is clear, easy to understand, and delivered in a natural way. The content is very accurate, and I've learned a lot from it.
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.
I have been away from power apps for years and needed to get up to speed quick for a clients project. Wow! Your course is amazing. Thanks for saving me days of searching to find something that barely covers any of what you covered.
So happy to have been able to help and good luck
This is superb! Before I can get into the depths of Model-Driven Apps, I wanted a primer, something that covers all the basics end to end. I know I will not remember everything I have learnt here, but this video helps in bringing together all the puzzle pieces and gives you an introduction into the world of Model-Driven Apps, the right way. I am so grateful to you, Lisa. Can't thank you enough. It shows that you have put your heart and soul into creating this tutorial, your hard work speaks for itself, keep them coming! Thanks again.
You are an amazing teacher, thabk you fornexplaining things so simply. Simplicity is the sign of genius
This tutorial has been a game-changer for me (as it seems to have been for others). I feel like I've learned a lot & it has opened my eyes to a few things. Your delivery and the content itself is excellent - thank you!
Lisa, thank you for this guide, I watched in bite-sized chunks while eating lunch! First viewing to take it all in, second will be as I go along and attempt to recreate! Thanks for being comprehensive, understandable and honest, it is much appreciated. One question I've got is could you do a model driven app using Lists rather than Dataverse tables, as that's where all my info lies at the moment?
You can use lists as virtual tables in Dataverse and build your model-driven app on top of that - have a look at this video: th-cam.com/video/mEZSsx8B5HE/w-d-xo.html
This tutorial is fantastic! Lisa's clear explanations and step-by-step guidance make learning Model-driven Power Apps so much easier for beginners. Thank you for sharing your expertise and helping us build our skills! Looking forward to more tutorials from you!
This was a really great experience and gave me a kickstart in building my own app. Thank you so much
hello Ma'am I really loved your videos and keep on uploading such valuable content and you have a wonderful smile .
I have found it incredibly useful. In fact, I have a project to develop, and this course covers 50% of it. The other 50% will involve developing an application for employee management once they have been hired. Do you have any tutorials for this? It would be great to have them; additionally, I need to know how to integrate both systems so that they function as one. This way, a user with the appropriate permissions would only see the recruitment section, while Human Resources would have access to the other section, and the general administrator would be able to see both. I greatly appreciate you taking the time to share your knowledge and help us. Of course, I would be happy to buy you a coffee.😊
I don’t have a tutorial for employee management but you can use the same principles as shown here to create your data model and app. You can use the same environment and create a new app with additional tables and its own navigation for that employee management side, then control the permissions with user roles so only the right users have access to that other app and the tables it uses. Good luck!
I just finished old version yesterday, I missed some points due to version issues. 😂😅😮Great tutorials. 🎉🎉🎉 Thanks 🙏
Thanks so much Lisa... great presentation as usual. I had an issue in that the search bar is replaced by a magnify glass, but I assume that is because of "version" that my company uses... I have seen that this type of view has changed over time that my organisation has been developing their D365 migration
I’ve seen that happen when your browser zoom is high, try dropping that down. It’s a responsive application so things on the screen change to fit.
This is a really good tutorial Lisa, thank you.
Great tutorial!
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..
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.
Hey Lisa, I am a big fan of you in the power platform conference last year..I've been following your tutorials on creating Model-Driven Apps and I'm currently developing an ERP system using this platform. I've found your videos incredibly helpful and informative.
However, as I delve deeper into the project, I'm starting to have some concerns about the potential costs associated with Dataverse storage. I understand that 1 GB of storage is currently priced at $40 per month, but I'm struggling to grasp how much data that actually represents in practical terms, especially when considering storing invoices and receipts data (not documents), and other relevant information for an entire ERP system.
I would greatly appreciate your insights on data usage and cost optimization and tips and I'm particularly interested in your opinion on whether proceeding with Model-Driven Apps for my ERP is the most cost-effective and efficient solution in the long run.
Thank you for your time and expertise. I look forward to hearing from you.
Thanks for your work Lisa, amazing as always
Fantastic tutorial, thanks for sharing this.
Amazing tutorial, Lisa!!
Thanks Thnaks !!
Simplicity is the utmost form of sophistication. When you watch this video which is
Thank you so much, I really appreciate that ☺️
Great tutorial! Thanks for that! But .. am I correct in seeing two Application tables? I've found a System table and a Custom one (my own). This caused me some confusion when adding the tables to the app at 1:17:45. I couldn't find an option not to show system tables and the interface has changed a bit when selecting tables. I ended up selecting them both and in the navigation pane removing the one that gave me a blank page instead of the Active Applications view. Also, I couldn't find the icons you are using but that's not an issue at all. Nonetheless a fantastic tutorial! Love to see more.
I’ve checked one of my environments and you’re right; there is a standard Application table. One option if it’s confusing is to change the display name of your table to something like “Job Applications”. So hard to have content that keeps up with the user interface changes but glad you were able to find your way through it.
Wondering if I could make "Service Request" form approval process using this guide. Much thanks for a tutorial!
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
@@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?
All users will need a premium or per app license for a model driven app.
I love you Lisa Crosbie
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.
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
@@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.
@@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.
I'm stuck with importing application table i noticed the rows which have interview start date do not import
I set up the template in US date format because my environment is in the US. If your environment is in DD/MM/YYYY format then change the dates in the spreadsheet to that format before you import.
Hi Lisa,
maybe I oversaw something but on th-cam.com/video/HrILchHvMUA/w-d-xo.html the form "Information" is prepopulated but this form is not created yet in this tutorial or am I wrong?
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)
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?
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?
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.
Can you help me find a best course for Dynamic 365 CRM ? not much course and content is available on internet.
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
th-cam.com/video/3Lfs5fAc1bU/w-d-xo.html
@@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 ☕
I’m working on it.
@@LisaCrosbie You should create Udemy Course .
unable to upload application file
getting error
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.
@@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)
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?
Do the Brits think the American accent is awesome as I think your accent is?
But I don’t have an accent, you do 😂
This is the most up to date, helpful tutorials on Model Driven Apps on the Power Platform, well done! Thank you!
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
thanks heaps Lisa, I love your pace, your explanations and of course your aussie accent makes me feel right at home :)
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') .
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.
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)
That would help :)
Hi Lisa, another one of your fabby guides! Thank you for creating this.
I do have a question though, the Appointments button - was the plan to hook that into the data for Interview dates?
Thank you very much Lisa for the tutorial, very informative and clear explanation of all the topics included.
Hoping for the further "Solution Deployment"(Pipeline) Tutorial from you
About the 1:41:35, you press the + button and able to call the quick create form (Application) but I cannot see the option for Application. I only have "Contact". Do you know what step I missed?
Lisa, can you please do a video where Power Automate sends a reminder email 2 weeks, 1, weeks, and 1 day before a dataverse due date column?
Hi Lisa, in 1:26:07 when I play my app to create new application the opening screen is totally empty,I cannot create new application. Contacts and Roles work fine.I have followed all steps to create tables, views and forms. Can you help me,why is this happening? Thanks in advance!
hello
I have a question.
I would like to know how to create a powerapps model-driven app and then connect it to MS Project with data.
Can you tell me how?
Please could you do a video dedicated to security.. it’s driving me insane 😂 I can’t wrap my head around it all. Do I set security roles in the Dev and import them to prod.. do assign users in dev and deploy to prod? How does teams work? It just feels like an absolute mine field with no clear guidance anywhere😢
Hey Lisa.. I have a Question: Is there a way to color format a "Formula" field other than a choice field? Thanks a lot!
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🙏
I noticed i could not do the update form and views at my end. I didnt see the update icon. Though i tried creating my own columns and all (There are no forms associated with the selected tables).
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.
I am having difficulties importing csv into dataverse. Anyone with a resource I can read about how to?
Great! I want to’ buy the explanation book you wrote. Is it possibile to pay via PayPal?
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.
Great video. All these selected Audit options, how much space with this new audit recorded data take up?
hi i want to thank you for all your effort it help me a lot to understand the subject , keep going on that is realy helpfull for people who want to learn the subject
Application CSV giving invalid optionset error if candidate field lookup set to email
Thanks alot - worked out perfectly!!🤪
Amazing tutorial, much appreciated, thanks for including the security role concept
Nice and very helpful Thank you very much :)
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?
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)
Hi Lisa, great videos - thanks so much for putting them together, they have been really useful for me and my team. Do you have any videos on setting up pipelines (Dev>Test>Prod)?
thanks - I don't have anything on pipelines and nothing planned in the short term on that.
An excellent video! Thoroughly enjoyed the course, many thanks Lisa! I had a minor issue importing the Applications.csv file, but I realised that is due to the 'Interview Start Time' being in US date format, whereas I needed it to be in dd/mm/yyyy hh:mm (UK format), but once you change the dates to the desired format, it works perfectly! Thanks.
Yes, you're right. Most of my audience is in the US which is why I did it that way, but I work in DD/MM/YYYY in Australia too.
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.
No, I’m not doing any JavaScript content. Thanks for watching.
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
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.
Thank you so much. It really helped to understand the Model driven apps. The Copilot search did not work though I have followed all the configurations suggested. Any suggestion on this?
Sorry this isn’t a good forum for troubleshooting. Perhaps post in the Power Apps Community forum or see if anyone else has had a similar problem there.
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
You can display SQL as a virtual table in model driven apps
I got stuck on Data Step1. In the Data Field drop-down list there was no "Screening call date" option.
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.
Thank you so.much 😊. Can we use this in Dataverse for teams? I will have a look.
No, you need full Dataverse for this.
My notes
34:56 - Set up fields for search | Quick Find Active ...
37:50 - Important steps before creating a table (check out the option for 'Creating a new activity')
40:10 - Changing the name of Primary Column of a new table (to preferably make it an autonumber)
49:56 - Creating Relationship between tables
01:20:26 - Enabling Global search bar in the model driven power app, by checking off the option 'Enable offline Classic'
01:24:15 - Setting up timezoe for each user
01:26:02 - HOW THIS APPLICATION IS USED AND WHAT IS TIMELINE
01:29:08 - Import the data from excel
01:33:10 - Log of previous uploads
01:34:10 - Importing a table with relationship to other table
01:39:04 - End user can customize to add or remove fields of their choice in the view
01:41:35 - Quick create form. To quickly add data into a record without actually clicking the record and launching the main form. This should appear side by side of a record just by hovering (check).
01:43:26 - Quick create View. Small window of data to view the records side by side inside a record (read only). Create this on the table inside which records are saved then add it in the other table to show extra RELATED records from another table. e.g. If we want to show candidate's info in the application table, create a quick view form in the candidate table, but show it side by side inside the main form of application table by selecting related items (01:45:58).
01:47:07 - Control what fields of lookup table you want to show in the intellisence drop down (max 3 fields allowed for nice legible view)
01:48:51 - Show sub-grid. i.e. inside a view, show all related records from other table
01:52:19 - PowerApps Grid Control - Beautify with colors
01:54:11 - Aggregation of fields is also allowed. Not covered in this one, try and research more. This can be useful.
01:55:00 - Custom Pages - These are like canvas app design within the Model Driven PowerApps solutions to show as a welcome page or any summary page we want. Basically a functionality to use canvas apps inside model driven solution
02:17:13 - Security Roles and Privileges - Hierarchical organizational level roles and the accesses. Read more about what are they, rather than how are they used. Also find out which environment it should be done at (development or production).
02:19:50 - Share the app with the user. Please not that security role is assigned first before sharing the app. Also find out how can we create groups of people to share the apps at once rather than individually sharing the app.
Hello Lisa, thanks for putting these tutorials together, I have learnt heaps from them so appreciate you sharing your knowledge. I have a question regarding M:M relationships and whether you can store an attribute with this relationship. I'm in a situation where I have project managers related to clients, I would like to store some information about the relationship that exists between these two, for instance the type of relationship. Is this possible or do I need to build the 'cross over' table my self and manage with a M:1 and M:1? Look forward to hearing how this might be done.... and if you looking for another example for a tutorial, a basic CRM would be nice 🙂.
What you’re looking for is called an “intersect” table. If you use the out of the box N:N relationship there is an intersect table automatically created to make it work but you can’t add any fields to it. If you want to store data in that intersect table you need to create 1:N both ways. I’ll add this to my video list but in the meantime this is a really good explanation of the concept (old UI screenshots but the concept is still the same). carldesouza.com/understanding-intersect-entities-and-nn-relationships-in-dynamics-365/
@@LisaCrosbie Thanks for replying Lisa, I'll definitely take a look, looking forward to your next installment and enjoy the rest of your day.
This is a great place to start when you know nothing about Power Apps. Thank you so much for putting this out there Lisa. I watched the complete tutorial and had the working app at the end. In the beginning of the tutorial (~11:10), you talk about packaging the solution and moving it around to test or debugging environments. Do you have a tutorial about how to do that?
Again, thank you for making this available.
Amazing work Lisa, I’ve been following you for months and I always learn something new from you on each video. May I suggest a video on using JavaScript for web resources?
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?
Hi Lisa, Thank you for this video. It will be a good base for my apps :)Model driven way is much easier for me. First the data base after the face :)
Thank you, Lisa, for providing this tutorial at no cost. I must say, I learned a great deal from this two-hour video, which kept me captivated throughout the session. It would be excellent if you could create a video explaining the various security roles, detailing the differences between them, such as the capabilities of a Basic User compared to an Environment Maker, and identifying the highest level of role, among others.
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!💯🏆👍
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.
Great course, Lisa! This was extremely helpful being able to follow along and build the app as you are building it.
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.
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. .
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.
Simply Amazing! Thank you for all the amazing content that you create Lisa. Absolute Legend!
Fantastic content Lisa! I'm developing my first model driven app and this is very applicable to the project goals I have. Really appreciate the excellent relational database concepts presented here also. Bravo!! 👏👏👏👏
Thank you
Thank You
Your tutorial was incredibly clear and well-organised. Thank you for sharing your expertise with such engaging and thoughtful presentation!
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.
Another quite exceptional course from Lisa - her clarity and delivery are superb. I cannot recommend her more highly!
🥰Wow! you are a very generous person for sharing your knowledge with the community. From Buenos Aires (Argentina) I send you greetings! 🥰
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
This might cover what you need? How to Turn Your Excel Spreadsheets into Power Apps
th-cam.com/video/mnHxS5XD8jc/w-d-xo.html
@@LisaCrosbie thanks, I'll take a look. I'm up to about 6 hours online with MS cust servs and no progress!
@@LisaCrosbie thanks...followed it, only 20 rows :(
This is yet another AWESOME training video, Lisa. You are the best!
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.
Lisa glad to see you with this course
please can you make a full detail video on Microsoft dataverse model driven copilot with full functional app it will help a lot to every body on yt who is following your videos
Highly recommended tutorial with proper content and implementation, waiting for your canvas app tutorials😊
How can I get a Copilot Drink bottle too?
Microsoft had some special giveaways during the AI tours but there weren’t many around, very hard to get I’m afraid!
Really great video. Thank you for putting in the time and effort to make it for us!
I LOVED THIS
Big Big Like
One video to capture all the important components of Model Driven App. Loved it 😊