Build it and they will come: Create Dataverse tables with relationships for your apps EP2

Рет қаралды 15,995

Күн бұрын

Welcome back to our 10-part series comparing Model-driven and Canvas apps! In this second episode, we're going to dive into creating two Dataverse tables that will be used by both apps. We'll also create relationships between these tables and one of the CDM tables.
Before we start building, we'll show you the drawing we came up with to guide our development process. Don't worry, it's nothing complicated, just a simple sketch on a whiteboard desk. But, if you prefer a more proper solution, you can use tools like Lucid Chart, Visio, or even Excel.
Now, let's get started! We'll create these tables with a variety of columns, including choices and images, and we'll set up some lookup columns by creating relationships. And, of course, we'll be doing it all inside of a solution because that's the right way to do it.
So, if you're ready to have some fun building Dataverse tables, come join us in this episode. It shouldn't be a complicated video, and we promise to make it both informative and engaging.
Remember, this is episode 2 of our series, and we have much more in store for you. So, make sure to subscribe to our channel to get notified when the next episode drops. We can't wait to see you there!
Link to complete playlist😎
• Model driven vs. Canva...
0:00 Create Dataverse Tables with Relationships
0:39 Tools for visualizing your Tables you plan to build
1:10 Columns we plan to use in our Table
1:58 New Table in our Dataverse Solution for Vendors
2:58 Creating a Choice column in Dataverse
4:45 Add a true Date Only column
5:40 Creating a Lookup column to Contact
6:26 Using a File Image column and setting Primary Image
7:30 Create the Product table
8:12 Add a currency column
9:22 Adding a Multiple lines of Text column
10:37 Create a Lookup to Vendor
Episode 1 Overview and Creating the Solution • Model driven vs. Canva...
Episode 2 Creating the Dataverse Tables • Build it and they will...
Episode 3 Making a Model-drive app • Create a Model driven ...
Episode 4 Build a Canvas app with Canva and Containers • Build a Canvas App: Cr...
Episode 5 Galleries • Adding and Designing G...
Episode 6 Forms • Forms to view and edit...
Episode 7 Better filtering of Galleries • Filtering your Gallery...
Episode 8 Security Roles and Solution Export • Create a Security Role...
Episode 9 Import your solution, environments, and Sharing your app • Import your Managed So...
Episode 10 Dare 2 Compare the two apps! • Comparing Model driven...
Power Apps Consulting and training at www.PowerApps911.com

Пікірлер: 31

@CuriousJo1122 Жыл бұрын

This video is so good. It shows me what I need to see and in the most efficient, straightforward way!

@ShanesCows Жыл бұрын

Thanks for the kind words 😎

@juandavila4035 Жыл бұрын

Thanks for your videos, I like improving with you

@ShanesCows Жыл бұрын

Appreciate that Juan. Hopefully you enjoy the full series. 😎

@ThePete1775 Жыл бұрын

Hi Shane. Love your videos. Getting into powerapps from an extensive Access background. For items like "Region" on your vendors table, why use a choice instead of a lookup to another table? Also, I've noticed that powerapps does not like lookups to tables that then have other lookups (cannot do multilevel...). any good way of handling these?

@ShanesCows Жыл бұрын

You could do the other table. Really choice sets are just that, just Dataverse manages it all for you. The polymorphic stuff doesn't work for grand children, kind of annoying. I understand why but still annoying. No easy answer there other than use a LookUp function.

@AntonioOliveira68 Жыл бұрын

this is the BEST PApps channel. :D

@ShanesCows Жыл бұрын

Thank you Antonio. Little comments like this mean a lot to me. 😎

@boldottoman Жыл бұрын

Thanks Shane for all the content. Can you please put the number of the episode in the thumbnail, always in the top corner? The lower right corner gets under the time duration of the video that KZfaq overlays on all videos (on mobile at least). Having the numbering visible and consistently positioned would be very helpful as we visit your feed and go back and forth through the videos over the course of a few days.

@ShanesCows Жыл бұрын

That seems like a fair request. Let me see what I can do.

@boldottoman Жыл бұрын

Just checked on desktop, it's the same issue.

@boldottoman Жыл бұрын

@@ShanesCows Btw, lower left corner also works fine. Like you have on episode 3, at the moment. It's only the lower right corner that should be avoided.

@ShanesCows Жыл бұрын

@@boldottoman I updated all 10 thumbnails to put them all in the top right. Probably take a bit for YT cache to see the change but thanks to you they are all fixed. Thanks 😎😎

@boldottoman Жыл бұрын

I can see the new thumbs! Thank you 🙏

@filipwinski4219 Жыл бұрын

Great Video, Thank you Shane. If you create tables within a solution, will the tables be recreated automatically in other environments too? In other words: will the whole soluton be just "copy paste" or you have to do some part of the job again?

@ShanesCows Жыл бұрын

They are part of the solution so they will just move. 😎 Video 9 shows that I am pretty sure. The sample data is the only thing that doesn't go in the Solution.

@oluwatobipaul6171 Жыл бұрын

Following up with the series now

@ShanesCows Жыл бұрын

Enjoy. It is fun stuff.

@icodeint2780 Жыл бұрын

Hey Shane, I do need your help or if you have the video to direct me to it. On my application the End user have the possibility to do over 130 relationship relate() using a ForAll with a collection, it takes over 2 to 5minuts, am trying to figure out how to use power Automate but can't get the hang of it. Any help please

@rolando2742 9 ай бұрын

Hello Shane, Do you know how to create a table where the primary column is automatically fills with the combination/concatenation of values of two or more columns.

@ShanesCows 9 ай бұрын

I do not believe that is possible. Well maybe. In DV you can create a calculated column, that will give you the combination, and then maybe you can make it a second key. I haven't tried befor.

@rolando2742 9 ай бұрын

@@ShanesCows Thanks for your reply. I have a follow up question, Dataverse has tables ready to use, and one of them is the Contact table, that table has a mechanism I want to understand where the values containing the FirstName and LastName fields automatically appear concatenated in the FullName field (Primary field). I want to understand how that works. Do you know what is configuration allows it to work like this?

@munkybutler1 Жыл бұрын

Thanks for another great video Shane. I'm surprised there is no out-of-the-box 'Vendor' table as part of the Common Data Model. I've had a look around online and I can't see if there is any other out-of-the-box table that could be used as a vendor/supplier table? Are you aware of anything? Thanks!

@ShanesCows Жыл бұрын

I think the idea is that Contacts is the universal table for that scenario. Though admittedly I haven't thought about it much so don't take my words are more than a guess. 😎 Okay. For giggles I fed ChatGPT the context of your question. Check out this response: Hi Sean, Thank you for your kind words and for reaching out with your question! I'm glad you found the video helpful. You're right that there isn't a specific out-of-the-box 'Vendor' table as part of the Common Data Model. However, there is an alternative approach you could consider. You can leverage the existing 'Account' entity (table) in Dataverse, which is designed to store information about both customers and vendors/suppliers. By using the 'Account' entity, you can store vendor-related data and apply custom filters or create custom views to differentiate between customers and vendors/suppliers. Additionally, you can create custom fields or even a custom option set to further categorize and manage vendor-specific information if needed. This approach is quite common and flexible, as it allows you to manage both customers and vendors/suppliers within a single table while still being able to differentiate between the two when necessary. I hope this helps! If you have any further questions or need clarification, please don't hesitate to ask. Best regards, Shane I feel like that is a solid answer. 😎

@munkybutler1 Жыл бұрын

@@ShanesCows Haha, you must be a better ChatGPT prompter than me. I tried ChatGPT before I asked you and couldn't get a straight answer😂. I am actually using the Accounts table currently but I wanted to check if there was a better way! Thank you again as always Shane, if you are coming to Dublin in June for the European Power Platform Conference I owe you a few pints!