Тёмный

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

Tiny Technical Tutorials
Подписаться 52 тыс.
Просмотров 39 тыс.
50% 1

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

Наука

Опубликовано:

 

22 июл 2024

Поделиться:

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист
Посмотреть позже
Комментарии : 96   
@TinyTechnicalTutorials
@TinyTechnicalTutorials 2 года назад
What other kinds of Power Apps videos do you want to see? Let me know below in the comments!
@aparnamohan3448
@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
@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
@steventhawe1598 2 года назад
A requisition model driven PowerApp
@TinyTechnicalTutorials
@TinyTechnicalTutorials 2 года назад
I've added it to my list for future videos. Thanks for the suggestion, Steven! :)
@steventhawe1598
@steventhawe1598 2 года назад
@@TinyTechnicalTutorials I've managed to create a model driven requisition app. would love to get your insights on where to improve!
@EuroWin
@EuroWin 2 года назад
High quality information presented in a such effective manner. Great job!
@TinyTechnicalTutorials
@TinyTechnicalTutorials 2 года назад
Thank you for such a nice comment! Made my day! :)
@mikesmith2315
@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
@TinyTechnicalTutorials 2 года назад
Welcome aboard, Mike, and thanks for such a nice comment! :)
@billyprater3361
@billyprater3361 Год назад
Brilliant video! to the point and very effective :)
@TinyTechnicalTutorials
@TinyTechnicalTutorials Год назад
Yay! So glad you liked it! :)
@pravinshingadia7337
@pravinshingadia7337 18 дней назад
Really good - love you keep these short
@TinyTechnicalTutorials
@TinyTechnicalTutorials 18 дней назад
I'm so glad you enjoyed it! Thanks for watching!! 🙏🤓🌟
@chrisyleenz
@chrisyleenz 2 года назад
Subscribed!!! Not just because your well structured explanations, but the fact you used the Office characters!!!!!!! Lol, loving it
@TinyTechnicalTutorials
@TinyTechnicalTutorials 2 года назад
Ha! A fellow fan of The Office! Welcome! :)
@kola740
@kola740 Год назад
Definitely interested in a video about relationship in Power Apps!
@TinyTechnicalTutorials
@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-RQbEeEv7dL0.html.
@shivashishastrology-easyjy3207
Wow. Beautifully and easily explained. And I thought that I was the only good teacher. Just kidding...Subscribed.
@TinyTechnicalTutorials
@TinyTechnicalTutorials Год назад
Ha! 😂 Thank you, Parvesh! Welcome to the channel!
@rikkers258
@rikkers258 2 года назад
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
@TinyTechnicalTutorials 2 года назад
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! :)
@itubeHirschberg
@itubeHirschberg 2 года назад
Danke sehr gut 👍
@TinyTechnicalTutorials
@TinyTechnicalTutorials 2 года назад
Gern geschehen! :)
@vijay_
@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
@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-IpuztObUNDM.html. Hope it helps! :)
@SmartLearningAI
@SmartLearningAI 6 месяцев назад
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
@TinyTechnicalTutorials 6 месяцев назад
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! 😊
@matiasfolonier159
@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
@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
@matiasfolonier159 2 года назад
@@TinyTechnicalTutorials Oh thanks for your answer !
@douglas_martins
@douglas_martins 2 года назад
I didn't find the link for the full course, can you please add here? Thanks for the content.
@TinyTechnicalTutorials
@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
@jennytumay Год назад
this was so helpful thank you :)
@TinyTechnicalTutorials
@TinyTechnicalTutorials Год назад
I'm so glad! Thanks for watching!
@jegaveerpandian
@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
@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
@jegaveerpandian 2 года назад
@@TinyTechnicalTutorials Thank you so much for your quick response! That worked! really appreciate your help.
@TinyTechnicalTutorials
@TinyTechnicalTutorials 2 года назад
Yay! Great to hear!
@jegaveerpandian
@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
@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! :)
@swarakiduniya9192
@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
@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
@swarakiduniya9192 2 года назад
@@TinyTechnicalTutorials Thank you so much for your quick reply, I will check this link
@sultanSurya
@sultanSurya Год назад
Good content. Subscribed 😀
@TinyTechnicalTutorials
@TinyTechnicalTutorials Год назад
Thanks so much, Vidya!! :) Welcome to the channel!
@dougydoe
@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
@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
@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
@TinyTechnicalTutorials Год назад
Well, with a request like that, I guess I'll have to prioritize this one! :D Stay tuned!
@dougydoe
@dougydoe Год назад
@@TinyTechnicalTutorials I look forward to it so staying very tuned in. 😀
@TinyTechnicalTutorials
@TinyTechnicalTutorials Год назад
Hey @Douglas Doe - The wait is over! A video about data modeling/ERDs: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-RQbEeEv7dL0.html. First video of 2023. :) Enjoy!
@user-vu2dj5uz8w
@user-vu2dj5uz8w Год назад
Hello Tiny. I always watch videos well and click like to your RU-vid in Korea. I have a question. How do I insert an image into the PowerApp dataverse? I've searched and watched a lot of RU-vid videos, but I'm struggling because I haven't solved them yet. Please answer
@TinyTechnicalTutorials
@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: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-D_1n23P-AaU.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
@user-vu2dj5uz8w Год назад
​@@TinyTechnicalTutorials Thank you very much for your reply. I'm looking forward to your video.
@Elprise1
@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
@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! :)
@amanchourasia1870
@amanchourasia1870 2 года назад
yes some advance topics too, and yes make video on relationships.
@TinyTechnicalTutorials
@TinyTechnicalTutorials 2 года назад
Thanks for the suggestions, Aman! I've added them to my list for future videos. :)
@amanchourasia1870
@amanchourasia1870 2 года назад
@@TinyTechnicalTutorials do u hv linkedin profile
@TinyTechnicalTutorials
@TinyTechnicalTutorials 2 года назад
You can find me at www.linkedin.com/in/amberisraelsen. :)
@somjadek
@somjadek Год назад
Can o365 standard plan do this? Current I use dataverse for Ms team
@TinyTechnicalTutorials
@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
@caseypustelnik4116
@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
@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
@caseypustelnik4116 Год назад
thank you so much for your consideration@@TinyTechnicalTutorials
@yamzychimomboh7790
@yamzychimomboh7790 2 года назад
aww yu good at it
@TinyTechnicalTutorials
@TinyTechnicalTutorials 2 года назад
Thank you! :)
@JasonHuang-rt3mw
@JasonHuang-rt3mw Год назад
Very good. Only the question is in my Power Apps, data type has only choice no choices, not sure why?
@TinyTechnicalTutorials
@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
@JasonHuang-rt3mw Год назад
@@TinyTechnicalTutorials thank you very much. Your tutorial is very helpful
@felicianomanguele6428
@felicianomanguele6428 2 года назад
i want to know how can i do generalization in dataverse
@TinyTechnicalTutorials
@TinyTechnicalTutorials 2 года назад
Hi Feliciano! I want to make sure I understand what you mean by "generalization." Can you give me an example?
@DebayanKar7
@DebayanKar7 2 года назад
how to add a custom font in my App?
@TinyTechnicalTutorials
@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. :)
@mr.arthur5776
@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
@TinyTechnicalTutorials Год назад
Hi mr.arthur5776! 😊 Can you explain MAP and subMAP? I'm not familiar with those abbreviations. 🤔
@mr.arthur5776
@mr.arthur5776 Год назад
@@TinyTechnicalTutorials sorry I ment Folder en subFolder
@TinyTechnicalTutorials
@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
@mr.arthur5776 Год назад
Thanks for your reply. Are you familiar with the concept of container and sharepoint? In relation to the PowerPlatform?
@mr.arthur5776
@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?
@frenamakenson9844
@frenamakenson9844 2 года назад
Dam ! So we’ll explain
@TinyTechnicalTutorials
@TinyTechnicalTutorials 2 года назад
Ah, shucks! Thank you, Frena! Glad you found it helpful. :)
@frenamakenson9844
@frenamakenson9844 2 года назад
I take your Full model driven apps as refresh to to my pl100 exam… i m impress How Good you explain
@TinyTechnicalTutorials
@TinyTechnicalTutorials 2 года назад
Thank you so much!! And good luck on your exam!
@busyshah
@busyshah 11 месяцев назад
My Bookmarks 11:40 subgrids
@TinyTechnicalTutorials
@TinyTechnicalTutorials 11 месяцев назад
Thank you! 💪
Далее
Everything you need to build a Model-driven Power App
40:34
Microsoft Dataverse Intro in 20 Minutes #Dataverse
19:46
Power Apps Canvas vs Model Driven vs Portals Explained
18:00
We Had a UX Designer Fix Our Power App Part 1
22:10
Просмотров 55 тыс.
Samsung laughing on iPhone #techbyakram
0:12
Просмотров 676 тыс.
Красиво, но телефон жаль
0:32
Просмотров 1,4 млн