Dataverse Driven Org Chart for Power Apps - Dataflows and Model-driven
Vložit
- čas přidán 25. 07. 2024
- #powerapps #PowerPlatform #ModelDriven
Model-driven and Dataverse training classes
training.powerapps911.com/col...
Explore the power of Microsoft Power Apps as we dive into creating dynamic organizational charts using Dataverse and Azure ID. This tutorial walks you through the process of leveraging Dataverse to pull in your organization's data from Azure ID, shaping it with Power Query, and then visualizing it in a model-driven app.
Discover how to use the out-of-the-box users table in Dataverse to create an interactive organizational chart, demonstrating the parent-child relationships within your team. Learn how to use the Graph API to fetch users and their managers from Active Directory, and how to create a Power Query function to loop through all users and bring in their managers.
This video also guides you through the process of using a data flow to update the users table in Dataverse with the manager information from Active Directory. We use the email address as a natural primary key to find and update records, ensuring your organizational chart is always up-to-date.
Whether you're a seasoned Power Apps user or just getting started, this tutorial provides valuable insights into creating dynamic, interactive organizational charts. You'll also get a sneak peek into how this process can be replicated in a canvas app.
Don't forget to subscribe to our channel for more Power Apps tutorials and to download the solution used in this video. Stay tuned for our upcoming video where we'll be creating a more detailed organizational chart app.
0:00 Start
1:09 Demo the Organizational Chart
2:05 User Table Configuration and Hierarchical Lookup
3:35 How the Model-driven app connects the dots
4:28 Explaining the Dataverse Dataflow querying Azure AD with the Graph API
10:30 Creating an additional key in a Dataverse Table
12:20 Quick Canvas App demo using the data
Need some help on something you are working on, contact us!
www.powerapps911.com/contact
PowerApps911
www.powerapps911.com/
Let's connect on social!
Twitter: / shanescows
Facebook: / powerapps911
Instagram: / shaneyoung911
LinkedIn: / cincyshane - Věda a technologie
Very cool! My brain played background tropical music every time Shane jumped in to discuss things.
Man, if I was a better editor I would have done that. 💖
Awesome use of Graph API. Thank you Shane Young
Happy to help. Have a great day. 🐶
Thanks fellas. Can i put in a cheeky request for a slower canvas App sequel 😅, my brain just exploded!!!! Lots of components so next time i'll watch 1st thing Monday after breakfast instead of last thing Friday after a beer 🤣
Yes, when I do the canvas app one we will be a bit slower. Not going to be Monday's video but it is on the short list. 🤩
Wow, what a fantastic technique utilizing this Power Query function within dataflow! Appreciate you sharing this, the content is excellent 😍
Glad you enjoyed it!
Great video. I think the Graph API/dataflow portion could have been covered better and in greater detail as that isn't something that has been covered much. I think the same thing could have been done by using Power Automate and that might be a little easier since people are more familiar with that tool. Graph API is a great tool that isn't leveraged enough, but Power Automate is more intuitive to most folks. Maybe a solo video that explores both options would be good.
Great suggestion!
I have done this without Graph API and with lots of different filters for search aswell as different functions such as call user,teams chat,emailing etc. Awesome video Shane ;)
Thanks 🤩
Shane, I hope your frozen drinks were delicious and you enjoyed your vaca. Glad to see the new vid.
So yummy! Thanks I appreciate the kind words. 😎
Agreed and well deserved. Have fun!!!
Love this Shane, can't wait to try it out and to see the canvass app video. You and Reza are famous at my company's dept because I talk about you so much 😂. Thank you!!
Thanks for the support Sara. 🤩
Hi Shane,
Thanks a lot for all your great videos, I truly enjoy them and learn a lot.
I think you might have forgotten to createthe video you talked about creating in this video, where you Bild the canvas app?
You are right, I haven't done it yet. I will try to get to that one. :)
This looks useful. Can't wait to try it. I have been tasked to create an HR group of apps. Will your course cover any of that sort of thing?
I want to say yes but I am going to get Juan to chime in here also. Or you can email training at powerapps911.com and we can connect you that way. Thanks
No the course doesn't go into any HR apps. I teach the core concepts so you can build any sort of app you want by understanding DV components through a practical vet crm example. We do cover hierarchical security which helps in HR apps though
Hi Shane, do you know of a way to record video in a canvas app? I love your tutorials and was hoping to find one for this situation but I can’t!
Not possible best I know. 🫤
@@ShanesCows I actually just found a solution but it uses a third party API! Would be great if we could do this in app!
Cool video! I was wondering what the advantages of this Users table vs the existing AAD Users table since that external table already syncs from AD? I think the AAD table doesn't contain the Manager field (for whatever reason) by default so in theory could you do the same with this table instead?
Good question! I am trying to get Juan to chime in. 🤩
No the AAD is actually a virtual table so you won't be able to modify any data in it. The AAD shows all users in your AAD vs the users table might only show the users who have access to the dataverse environment. if you don't have a security group in your DV environment technically the users table will have all the users
Brilliant Video, thank you. Could you apply this to something other than users? I have a model driven app which relates different tables. I'd like to visualise this like an org chart but can't for the life of me figure out a way of doing it.
Not that I know of, you can try going to www.powerapps911.com and throwing this question in the free help contact us form. See if Juan or one of the other Model-driven experts has any thoughts. But I got nada.
Thanks @@ShanesCows request sent, fingers crossed :)
I'm getting the following error in the data flow "Unable to retrieve attribute=businessunitid for entityLogicalName=systemuser" any ideas?
I think the issue is the graph call returns ALL users but in my case not ALL users are in Dataverse, for some reason they have not all synced across and would need to be added. I have made a power automate to force the sync but the logic seems flawed outside a Proof of Concept
At 6:46 you do not need to make separate Graph API calls to get users' managers. You can get manager information directly in your first Graph API call to get users: /v1.0/users?$expand=manager
Interesting. I sent this over to Juan for his thoughts.