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

Подписаться 163 тыс.

Просмотров 16 тыс.

50% 1

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

Наука

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

23 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 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. 😎

@AntonioOliveira68 Год назад

this is the BEST PApps channel. :D

@ShanesCows Год назад

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

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

@oluwatobipaul6171 Год назад

Following up with the series now

@ShanesCows Год назад

Enjoy. It is fun stuff.

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

@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

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

@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 RU-vid 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 🙏

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