Hierarchies and Self-Joins in Power Apps [Dataverse Relationships Part 2]

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

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

50% 1

Learn how to create self-joins to reflect a data hierarchy in Power Apps and Dataverse. In this video, you'll see how to turn on hierarchies at a table level in Dataverse and then how to visualize that hierarchy in a Model-Driven app page. You can also use these in canvas app styles in Power FX. This video series contains information needed for the PL-100, PL-200 and PL-400 certification exams.
Part 1: Creation and Enforcement of Relationships: • Creation and Enforceme...
Part 2: Hierarchy Relationships: • Hierarchies and Self-J...
Part 3: Many to Many Relationships and Relate and Unrelate: • Many to Many Relations...
-- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -
Next step on your journey:
👉 On-Demand Learning - Start With The FREE Community Plan: tinyurl.com/2ujujsb5
🔗Pragmatic Works On-Demand Learning Packages: pragmaticworks.com/pricing/
🔗Pragmatic Works Boot Camps: pragmaticworks.com/boot-camps/
🔗Pragmatic Works Hackathons: pragmaticworks.com/private-tr...
🔗Pragmatic Works Virtual Mentoring: pragmaticworks.com/virtual-me...
🔗Pragmatic Works Enterprise Private Training: pragmaticworks.com/private-tr...
🔗Pragmatic Works Blog: blog.pragmaticworks.com/

Let's connect:
✔️Twitter: / pragmaticworks
✔️Facebook: / pragmaticworks
✔️Instagram: / pragmatic.works
✔️LinkedIn: / pragmaticworks
✔️RU-vid: / pragmaticworks
Pragmatic Works
7175 Hwy 17, Suite 2 Fleming Island, FL 32003
Phone: (904) 638-5743
Email: training@pragmaticworks.com
~-~~-~~~-~~-~
Please watch: "(275) Free Pragmatic Works Power Apps Component Library "
• Free Power Apps Compon...
~-~~-~~~-~~-~

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

23 июл 2024

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

Комментарии : 25

@meganleecy4658 2 года назад

Great lecture!!! love it!

@PragmaticWorks 2 года назад

Glad you enjoyed it!

@berggrog1 2 года назад

Brian! Thank you so much these are some deep subjects but I really appreciate your help on this one. Still using classic editor for the this option. Keep up the good work. Great subject

@PragmaticWorks 2 года назад

Glad it was helpful! - Brian

@taar 8 месяцев назад

Thank you Brian. very clear explanation.

@PragmaticWorks 8 месяцев назад

Glad it was helpful!

@alexbanzay1519 2 года назад

good job. thank you

@TheOmegaAlfa Год назад

Thank you for this video! I have only to figure out how to set query/filter on the records that have ~ 'can be parent:yes' and other filters just to see the much less numerous records in the lookups.

@HatFullOfData123 2 года назад

Great video, really helped in a solution I'm building. Is there anyway to hide Inactive items in the hierarchy?

@LandscapeInMotion 3 года назад

Excellent showcase mate! What columns represent the hierarchy relationship? And how many sub branches can you have?

@capitanmelanito Год назад

Hello! thanks for the video! I was wondering how to do the opposite, to select a potential parent, and then to add the multiple children in the lookup column,. I see we cannot add multiple values in the lookup, I wish I could do this in canvas too. Thank you!

Год назад

Hi Brian, Really appreciate all the good content. I am really stuck on this one. In the modern view the Hierarchical checkbox is simply missing. In the classic view it is not enabled. What is missing? I am trying to do as in your second example: Principlals have teachers, teachers have students. I am trying to do a rollup on the number of students per principal, but it seems I can only do one level (students per teacher).

@maliarismendi4858 2 года назад

Hi! Great example!! Can this hierarchy be consumed from a Power BI report?

@mkavo 2 года назад

Hi Brian, this is very cool. Say if the Parent project had certain attributes the child doesn't have and vice versa is it still ok to manage it all in one table? Would you have a lot of blank fields then for the different types of projects depending on your hierarchy or does that matter? And lastly if you wanted to propagate some of the attributes from a Parent through to the Child you probably don't need to right because it exists already against the Parent record so you can show it in Views anyway by virtue of the lookup?

@oysterhoys Год назад

Thanx Brian, great stuff. It is still neccesary to switch to Classic today for the final setting. It seems also that only the first 3 columns of the Quick form can be shown in de Hyrarchy view. Never the less, nice functionality !

@PragmaticWorks Год назад

Hi there, it's no longer necessary to open the classic mode.

@oysterhoys Год назад

@@PragmaticWorks The step to create the scheme for the quickform seemed still neccessary. Could you maybe point to where ist can be set in the modern interface ?

@ramiromatos1899 Год назад

excellente Brian!!, you can indicate an example where only the rows are displayed according to their hierarchy.

@PragmaticWorks Год назад

You'll see these a number of ways but a common one is a project that has sub-projects.

@bankswalshie913 3 года назад

Great stuff as always! I'm wondering how to get the total value of used relationships. Example: Parent table is "Office", Child table is Staff (1:N). I want to make a database Chart showing All offices on the Axis with Bars showing the number of Staff for each office on the Series(Vert). I was thinking of using a calculation column that pulls the number of staff entries using the relationship, but I'm unsure how to get that data. Thanks again as always.

@PragmaticWorks 3 года назад

There's quite a few ways you can implement that. You can use the built in charting to count to build the bar chart you're looking at and counting the rows or you can get a more boring view by doing a rollup column that respects the hierarchy. You can also use a custom PCF component to visualize that. You can find those components at pcf.galleries

@bankswalshie913 3 года назад

@@PragmaticWorks The Charting was very simple, I think I was pulling the wrong data to begin with. All working now, thank you.

@martinnoah9716 Год назад

How do you only show the Parent Project on the main view?

@THEMASTERTM 2 года назад

But how do you do this with multiple tables? say for example Table A= Building, table B = floor and table C = offices one being the parent of the next respectively as oppose oh having them all in the same table?

@owenwetherow Год назад

Hi Raul I was thinking about the same problem. Unfortunately when you do a lookup to a table that is not the source table there is no option in the "Relationship" to create a hierarchy. The one option I could think of was to create different views/forms for the same table so that you could use the hierarchy. Did you find a solution?