Create a Model-Driven App with Dataverse, Start to Finish

Create a Model-Driven App with Dataverse, Start to Finish | Power Apps for Beginners

Рет қаралды 38,283

Күн бұрын

You’ve been put in charge of party planning for your office, and you need an app that lets you create events. No problem!
In this hands-on tutorial, I’ll show you from beginning to end how to build out a model-driven app to handle your requirements. We’ll set up a new solution, build out a data model in Dataverse (tables and columns), customize forms, and then pull it all together in a new model-driven app.
To learn more about creating a data model/entity-relationship diagram, check out this video: • Create an Entity-Relat...
If you’re interested in learning more, I’ve partnered with Pluralsight to build out a full 2-hour course about how to get started with model-driven apps in Power Apps: pluralsight.pxf.io/7mVor5
00:00 - Video intro
00:12 - Previewing the model-driven app we’re building
00:30 - Overviewing Dataverse
01:01 - Understanding tables and columns in Dataverse
02:39 - Creating a solution in Power Apps to hold customizations
03:45 - Creating a new table in Power Apps
04:15 - Creating new columns in a table
06:29 - Understanding relationships between tables in Power Apps
07:43 - Creating relationships in Power Apps
08:35 - Creating a many-to-one relationship using a lookup column
09:26 - Creating a many-to-many relationship manually
09:46 - Customizing a form in Power Apps
10:45 - Adding a subgrid to a form
12:16 - Composing/creating a new model-driven app
12:49 - Editing a site map/navigation
14:15 - Entering new records in Power Apps
14:45 - Working with the final Party Planning app
If you want to set up a free 30-day trial of Power Apps, check out another one of my videos: • Set up a Free Power Ap... .

Пікірлер: 94

@TinyTechnicalTutorials 2 жыл бұрын

What other kinds of Power Apps videos do you want to see? Let me know below in the comments!

@aparnamohan3448 2 жыл бұрын

Hi new subscriber here. I am trying to build a logistic tracker for my company for internal purpose. Am new to MS power platform. Is there an option to upload documents and use trigger actions for selected fields?

@TinyTechnicalTutorials 2 жыл бұрын

Hi @Aparna Mohan! Welcome to the channel! :) Without knowing all the details, I think you could accomplish something like this using Power Automate and SharePoint. I don't have any videos for Power Automate at the moment, but this might be a good place for you to start: docs.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/guidance/require-doc-approval

@steventhawe1598 2 жыл бұрын

A requisition model driven PowerApp

@TinyTechnicalTutorials 2 жыл бұрын

I've added it to my list for future videos. Thanks for the suggestion, Steven! :)

@steventhawe1598 2 жыл бұрын

@@TinyTechnicalTutorials I've managed to create a model driven requisition app. would love to get your insights on where to improve!

@EuroWin 2 жыл бұрын

High quality information presented in a such effective manner. Great job!

@TinyTechnicalTutorials 2 жыл бұрын

Thank you for such a nice comment! Made my day! :)

@billyprater3361 Жыл бұрын

Brilliant video! to the point and very effective :)

@TinyTechnicalTutorials Жыл бұрын

Yay! So glad you liked it! :)

@mikesmith2315 2 жыл бұрын

excellent. 2 minutes in and I knew this was going to be very good. I have subscribed and I am both azure and power automate architect, this material is beautifully covered I really like overviews which explain basics well.

@TinyTechnicalTutorials 2 жыл бұрын

Welcome aboard, Mike, and thanks for such a nice comment! :)

@chrisyleenz 2 жыл бұрын

Subscribed!!! Not just because your well structured explanations, but the fact you used the Office characters!!!!!!! Lol, loving it

@TinyTechnicalTutorials 2 жыл бұрын

Ha! A fellow fan of The Office! Welcome! :)

@kola740 Жыл бұрын

Definitely interested in a video about relationship in Power Apps!

@TinyTechnicalTutorials Жыл бұрын

Hi Florent! Thanks for watching! 😊 I do have a video about how to create a data model/entity relationship diagram for Power Apps. It's not ALL about relationships, but is a pretty good start: kzfaq.info/get/bejne/iLeSeMh2253IfGQ.html.

@shivashishastrology-easyjy3207 Жыл бұрын

Wow. Beautifully and easily explained. And I thought that I was the only good teacher. Just kidding...Subscribed.

@TinyTechnicalTutorials Жыл бұрын

Ha! 😂 Thank you, Parvesh! Welcome to the channel!

@itubeHirschberg 2 жыл бұрын

Danke sehr gut 👍

@TinyTechnicalTutorials 2 жыл бұрын

Gern geschehen! :)

@amanchourasia1870 Жыл бұрын

yes some advance topics too, and yes make video on relationships.

@TinyTechnicalTutorials Жыл бұрын

Thanks for the suggestions, Aman! I've added them to my list for future videos. :)

@amanchourasia1870 Жыл бұрын

@@TinyTechnicalTutorials do u hv linkedin profile

@TinyTechnicalTutorials Жыл бұрын

You can find me at www.linkedin.com/in/amberisraelsen. :)

@dougydoe Жыл бұрын

Just subscribed!! Wondering if you have a video or videos on Table relationships/ERD's on Dataverse. Quite experienced around the Power Platform in general but want to sharpen my skills around Data Modelling especially.

@TinyTechnicalTutorials Жыл бұрын

Welcome to the channel, Douglas! :) That's a great suggestion for a tables/ERD video. I unfortunately don't have any dedicated content for that (just the tiny bit in this video above), but I'll add it to my list. I think it's a struggle for a lot of people. In the meantime, Microsoft Learn has a data modeling lab: microsoftlearning.github.io/PL-900-Microsoft-Power-Platform-Fundamentals/Instructions/Labs/LAB%5BPL-900%5D_M02Lab01_Data_Model.html. It doesn't explain HOW they came up with the data model (which would be super helpful), but it might help?

@dougydoe Жыл бұрын

@@TinyTechnicalTutorials Thanks for being willing to do something on this. I've been searching for quite a while but I haven't seen anything very thorough and dedicated to that as yet. I realise that understanding data modelling and how to create ERD's is Key to effective Model Driven App creations. You have no idea how your brief explanation in this video brought some useful clarification to me about relationships in tables (e.g., the lookup field goes into the "many" side of the table, 1-N and N-1 is essentially the same but reversed etc). I guess doing that often, just like anything else, brings the experience but knowing the HOW is the key. I look forward to this video hopefully, it will be the first video you do in 2023. Thank You🙏 🤣😆

@TinyTechnicalTutorials Жыл бұрын

Well, with a request like that, I guess I'll have to prioritize this one! :D Stay tuned!

@dougydoe Жыл бұрын

@@TinyTechnicalTutorials I look forward to it so staying very tuned in. 😀

@TinyTechnicalTutorials Жыл бұрын

Hey @Douglas Doe - The wait is over! A video about data modeling/ERDs: kzfaq.info/get/bejne/iLeSeMh2253IfGQ.html. First video of 2023. :) Enjoy!

@douglas_martins 2 жыл бұрын

I didn't find the link for the full course, can you please add here? Thanks for the content.

@TinyTechnicalTutorials 2 жыл бұрын

Hey Douglas! You bet! You can find it here (you should be able to get a 30-day free trial if you need it): app.pluralsight.com/library/courses/model-driven-apps-power-apps-getting-started/table-of-contents

@jennytumay Жыл бұрын

this was so helpful thank you :)

@TinyTechnicalTutorials Жыл бұрын

I'm so glad! Thanks for watching!

@jegaveerpandian 2 жыл бұрын

Thanks for this amazing video! Is it possible to change the 'Owner' info of a record in a column? May be like 5 different owners for 5 records in a table. I would like to create a table to implement row level security and test it. Thanks again for sharing this content.

@TinyTechnicalTutorials 2 жыл бұрын

Thanks, Jegaveerpandian! :) Yes, you can definitely change the Owner of a record. If you click into that field, you'll be able to select a user or a group to own the record. If you haven't already, you can set up users through the Microsoft Admin Center at admin.microsoft.com, then you can select them to be Owners of records. Hope it helps!

@jegaveerpandian 2 жыл бұрын

@@TinyTechnicalTutorials Thank you so much for your quick response! That worked! really appreciate your help.

@TinyTechnicalTutorials 2 жыл бұрын

Yay! Great to hear!

@jegaveerpandian 2 жыл бұрын

@@TinyTechnicalTutorials A quick follow up question, I am wondering how do we change the owner of a record for a huge table ( let's say half a million records). Or like a bulk re-assigning of ownership to a 'team' and still able to achieve the use case that each member of the team can see only his/ her record. Also, do you have any dedicated training session/ course for dataverse in pluralsight? Thank you so much for your support! Please keep up the good work!

@TinyTechnicalTutorials 2 жыл бұрын

Hey Jegaveerpandian! To do a bulk update of owners, a few things come to mind: -Export the data to Excel, update it in Excel, then import it back in (I suspect this may be a struggle with half a million records, though) -The XrmToolBox has a bulk updater feature: www.xrmtoolbox.com/plugins/Cinteros.XrmToolBox.BulkDataUpdater (I haven't worked with this particular feature, but in general I'm a fan of XrmToolBox) -Write a Power Automate flow to do the update. You'll have to play with this to see if it'll work for your case. This example updates a different field, but you might be able to modify it to work for Owner: microsoftdynamics.in/2021/03/13/bulk-edit-multiselect-optionset-choices-fields-using-microsoft-power-automate/ As far as the team ownership, you can set the owner to be the team, but all members of the team will have full access to the record: docs.microsoft.com/en-us/power-apps/developer/data-platform/use-access-teams-owner-teams-collaborate-share-information. And on Pluralsight, the closest thing I have to a "Dataverse" course would be this one about customizing Power Apps: app.pluralsight.com/library/courses/microsoft-dynamics-365-customizing-power-apps. Feel free to "follow" me to be notified of new things (I'm working on a Canvas Apps course now). Thanks for asking! :)

@yamzychimomboh7790 2 жыл бұрын

aww yu good at it

@TinyTechnicalTutorials 2 жыл бұрын

Thank you! :)

@swarakiduniya9192 2 жыл бұрын

Thank you for this information - I have one question - If we are upgrading the Teams Dataverse to Dataverse then how much costing/pricing per user will applicable?

@TinyTechnicalTutorials 2 жыл бұрын

Hi Swara Ki! Glad you enjoyed the video! I'm definitely not an expert on licensing/pricing, and it can vary a lot with different plans. But this might get you started: docs.microsoft.com/en-us/power-platform/admin/about-teams-environment#licensing-and-restrictions

@swarakiduniya9192 2 жыл бұрын

@@TinyTechnicalTutorials Thank you so much for your quick reply, I will check this link

@SmartLearningAI 5 ай бұрын

Unrelated question: What annotation tool and recording software did you use to record this? I like OBS but have not yet found a nice live box annotation tool? Any advice?

@TinyTechnicalTutorials 5 ай бұрын

Hi @SmartLearningAI! 👋 I've used TechSmith's Camtasia for years and years, including for this video. Overall, I'm happy with it. I recently started running my audio through Adobe Podcast Enhance (an AI tool) that does a better job with noise removal and such, but for annotations and so on, Camtasia is everything I need. I haven't tried OBS before, though, so not sure how it compares, but hope that helps! 😊

@rikkers258 Жыл бұрын

I noticed the contacts table suddenly appeared did you use system fields or create new is there any pro and cons using system pre configured vrs creating your own ie prefixes etc. Thanks

@TinyTechnicalTutorials Жыл бұрын

Hi Rikkers! The Contacts table is one that you get for "free" when you create a new environment for Power Apps (along with some others, like Account, Appointment, Task, Catalog, etc.). It has tons of fields/columns built in: docs.microsoft.com/en-us/power-apps/developer/data-platform/reference/entities/contact In general, if a built-in table has *most* of what you need, it's best to use it and then just add in custom fields for your specific use case. This is because all the other "stuff" is done for you: forms, views, reports, etc. But there's nothing wrong with/no "penalty" for creating custom tables/fields (in a lot of cases, you'll have to). I guess the summary would be: do your best to leverage what's available out-of-the-box, and then add on top as needed. Hope that helps! :)

@matiasfolonier159 2 жыл бұрын

Hi TTT, I was wondering if it is possible to use this data table (e.g. this event) and automatically push it into a calendar in another entity. how to do that? Thank you very much.

@TinyTechnicalTutorials 2 жыл бұрын

Hey Matias! I haven't played with the latest version of the calendar control, but I believe (??) it can only be used to display Activities (not custom entities like the Event I built in this video). I suppose you could customize the built-in Activity table to add columns (essentially making it like the Event) and then use a calendar with it? Maybe this will help? docs.microsoft.com/en-us/powerapps/maker/model-driven-apps/add-calendar-control

@matiasfolonier159 2 жыл бұрын

@@TinyTechnicalTutorials Oh thanks for your answer !

@user-vu2dj5uz8w Жыл бұрын

Hello Tiny. I always watch videos well and click like to your KZfaq in Korea. I have a question. How do I insert an image into the PowerApp dataverse? I've searched and watched a lot of KZfaq videos, but I'm struggling because I haven't solved them yet. Please answer

@TinyTechnicalTutorials Жыл бұрын

Thanks for the nice comment! :) In Dataverse, a picture is just a type of column (just like a column for a number or text or something else). I briefly cover it in this video, around 02:57: kzfaq.info/get/bejne/esVhoZVktZOlkYk.html. That video only covers how to create the column. To upload an actual picture, just navigate to the record (the record will need to be saved initially), and then you'll click on the circle icon at the top of the record (just to the left of the name of the record). That will launch a dialog that lets you browse for/upload a picture. Hope that helps!

@user-vu2dj5uz8w Жыл бұрын

@@TinyTechnicalTutorials Thank you very much for your reply. I'm looking forward to your video.

@vijay_ 2 жыл бұрын

I am just trying to create an model driven app with CRUD where people can register and login and view the data! any hint how to create a register and login and CRUD in model driven!

@TinyTechnicalTutorials 2 жыл бұрын

Hi Vijay! I'm not aware of a way for users to do registration/login themselves with a model-driven app. The users/security roles have to be set up behind the scenes. Here's some info on that: docs.microsoft.com/en-us/power-apps/maker/model-driven-apps/app-visibility-privileges. I wonder if a Portal app is more what you need? This allows users to register and use a variety of authentication providers (Facebook, LinkedIn, etc.). More on that option: docs.microsoft.com/en-us/power-apps/maker/portals/configure/configure-portal-authentication As far as CRUD operations, if you DO use a model-driven app, you get CRUD "for free" when you create a custom entity/table (or use any of the built-in entities/tables). You'll just need to build out the forms to allow them to do this. I have a video about the basics of forms here: kzfaq.info/get/bejne/f9alrdeAx7uydIE.html. Hope it helps! :)

@JasonHuang-rt3mw Жыл бұрын

Very good. Only the question is in my Power Apps, data type has only choice no choices, not sure why?

@TinyTechnicalTutorials Жыл бұрын

Hi Jason! There have been some small UI updates since I made this video. It's now "Choice," with options under that for "Choice" (where you can enter as many items as you'd like) and then "Yes/No," which gives you just two options (Yes/No, True/False, etc.). Hope that helps! Thanks for watching! 🙏

@JasonHuang-rt3mw Жыл бұрын

@@TinyTechnicalTutorials thank you very much. Your tutorial is very helpful

@somjadek Жыл бұрын

Can o365 standard plan do this? Current I use dataverse for Ms team

@TinyTechnicalTutorials Жыл бұрын

Hi Somjade! :) I'm definitely not an expert on Microsoft licensing, but maybe this will help? docs.microsoft.com/en-us/power-platform/admin/pricing-billing-skus

@Elprise1 2 жыл бұрын

I'm confused about the initial description of Dataverse as a set of APIs. My understanding is that APIs process requests from the service making the request (say an end user in PowerApps) and sends that request to another service to have it processed. What is that service? Is it not a database?

@TinyTechnicalTutorials 2 жыл бұрын

Hi Clifford! It's a good question! I think the point I was trying to convey is that Dataverse is a cloud-based data service, and not just a direct connection to a database. It can combine data from a variety of sources (relational, non-relational, files, images, etc.), and also incorporates things like security, analytics and so on. So as you're interacting with it, you're making API calls (as opposed to, say, a T-SQL command like "SELECT * FROM Contacts"), and then it (Dataverse) is making various other calls on the backend to fulfill the request. Here are a couple useful articles that provide some more detail: docs.microsoft.com/en-us/power-apps/maker/data-platform/why-dataverse-overview www.codelessplatforms.com/blog/what-is-microsoft-dataverse/ Hope it helps! :)

@caseypustelnik4116 Жыл бұрын

Can you do a video on how to update the project online data verse table and link the task to a project? Updating the task table is easy, creating the link to the project not easy. using the dataverse premium connector add row. Basic problem, users can add tasks to a online project (not project for web) via a power app intake form,

@TinyTechnicalTutorials Жыл бұрын

Hi Casey! 😊 I haven't done too much with the Project Online and Power Apps yet, but I'll add this to my list for future videos. Thanks for watching and for the suggestion!

@caseypustelnik4116 Жыл бұрын

thank you so much for your consideration@@TinyTechnicalTutorials

@felicianomanguele6428 2 жыл бұрын

i want to know how can i do generalization in dataverse

@TinyTechnicalTutorials 2 жыл бұрын

Hi Feliciano! I want to make sure I understand what you mean by "generalization." Can you give me an example?

@busyshah 10 ай бұрын

My Bookmarks 11:40 subgrids

@TinyTechnicalTutorials 10 ай бұрын

Thank you! 💪

@DebayanKar7 2 жыл бұрын

how to add a custom font in my App?

@TinyTechnicalTutorials 2 жыл бұрын

Hi Debayan! I'm not aware of an "easy" way to use a custom font in a Model-driven app. You could probably write some JavaScript to do it, but I haven't personally tried. If you need more control over the UI, generally the recommendation is to use a Canvas app instead. If you find a way, though, feel free to post it here in the comments for others to reference. :)

@sultanSurya Жыл бұрын

Good content. Subscribed 😀

@TinyTechnicalTutorials Жыл бұрын

Thanks so much, Vidya!! :) Welcome to the channel!

@mr.arthur5776 Жыл бұрын

What is better to work with, dataverse or sharepoint library, when my data are files of 100 buildings, each building contains 100 MAPs and 200 subMAPs. Example: Building: Empire State MAP: contracts, lisense, architect drawing.... Etc Sub MAP: License/Fire, Licence/Health etc. 100 buildings x 100 MAPs x 200 subMAPs with new, updated information. So Dataverse or SP libraries

@TinyTechnicalTutorials Жыл бұрын

Hi mr.arthur5776! 😊 Can you explain MAP and subMAP? I'm not familiar with those abbreviations. 🤔

@mr.arthur5776 Жыл бұрын

@@TinyTechnicalTutorials sorry I ment Folder en subFolder

@TinyTechnicalTutorials Жыл бұрын

Oh, gotcha. In that case, Dataverse probably isn't the greatest option, since a "File" is sort of treated like an attachment to the record. There wouldn't be a concept of a folder or relationships between files. I'm not 100% sure you can achieve what you want with a SharePoint library either, but since it DOES have a hierarchical folder structure, it seems like the better way to go.

@mr.arthur5776 Жыл бұрын

Thanks for your reply. Are you familiar with the concept of container and sharepoint? In relation to the PowerPlatform?

@mr.arthur5776 Жыл бұрын

@@TinyTechnicalTutorials if working with metadata: building, classification and type 1 and type 2, there will be a relations. Furthermore, but when I have 100000 records en work with powerapps, how do I work with the max 2000 records delegation in a search?