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 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 🤣
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 ;)
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.
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?
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
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.
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?
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
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
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. 🐶
Does this require the OOTB hierarchy visual that you click on in the views? That is being deprecated now. If not, where do I find how to build this?
Wow, what a fantastic technique utilizing this Power Query function within dataflow! Appreciate you sharing this, the content is excellent 😍
Glad you enjoyed it!
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. 🤩
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. 🤩
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!!!
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 🤩
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!
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
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 :)
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
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.