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

[@TinyTechnicalTutorials]

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

[@aparnamohan3448]

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]

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]

A requisition model driven PowerApp

[@TinyTechnicalTutorials]

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

[@steventhawe1598]

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

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

[@pravinshingadia7337]

Really good - love you keep these short

[@TinyTechnicalTutorials]

I'm so glad you enjoyed it! Thanks for watching!! 🙏🤓🌟

[@chrisyleenz]

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

[@TinyTechnicalTutorials]

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

[@EuroWin]

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

[@TinyTechnicalTutorials]

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

[@mikesmith2315]

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]

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

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

[@billyprater3361]

Brilliant video! to the point and very effective :)

[@TinyTechnicalTutorials]

Yay! So glad you liked it! :)

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

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

[@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: kzbin.info/www/bejne/iILFdph7q5yXgpI. First video of 2023. :) Enjoy!

[@SmartLearningAI]

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]

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! 😊

[@jegaveerpandian]

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]

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]

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

[@TinyTechnicalTutorials]

Yay! Great to hear!

[@jegaveerpandian]

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

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]

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]

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]

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

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

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

[@Elprise1]

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]

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! :)

[@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! :)

[@douglas_martins]

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

[@TinyTechnicalTutorials]

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

[@송나우도]

Hello Tiny. I always watch videos well and click like to your KZbin in Korea. I have a question. How do I insert an image into the PowerApp dataverse? I've searched and watched a lot of KZbin 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: kzbin.info/www/bejne/epCUn2VphZJ0l7c. 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!

[@송나우도]

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

[@matiasfolonier159]

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]

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]

@@TinyTechnicalTutorials Oh thanks for your answer !

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

[@itubeHirschberg]

Danke sehr gut 👍

[@TinyTechnicalTutorials]

Gern geschehen! :)

[@vijay_]

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]

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: kzbin.info/www/bejne/f6HYq6eFl7qBeq8. Hope it helps! :)

[@felicianomanguele6428]

i want to know how can i do generalization in dataverse

[@TinyTechnicalTutorials]

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

[@jennytumay]

this was so helpful thank you :)

[@TinyTechnicalTutorials]

I'm so glad! Thanks for watching!

[@busyshah]

My Bookmarks 11:40 subgrids

[@TinyTechnicalTutorials]

Thank you! 💪

[@sultanSurya]

Good content. Subscribed 😀

[@TinyTechnicalTutorials]

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

[@DebayanKar7]

how to add a custom font in my App?

[@TinyTechnicalTutorials]

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

[@yamzychimomboh7790]

aww yu good at it

[@TinyTechnicalTutorials]

Thank you! :)

[@frenamakenson9844]

Dam ! So we’ll explain

[@TinyTechnicalTutorials]

Ah, shucks! Thank you, Frena! Glad you found it helpful. :)

[@frenamakenson9844]

I take your Full model driven apps as refresh to to my pl100 exam… i m impress How Good you explain

[@TinyTechnicalTutorials]

Thank you so much!! And good luck on your exam!