Forum Discussion
Organisation Chart in O365/ SharePoint
We also need an org chart web part and have currently decided to build it as a replica of the one in the people card using SharePoint Framework.
It's relatively simple so shouldn't be too much of an effort to build it but it would be nice to have it as an out-of-the-box web part.
- Raymond LittleJan 24, 2019Copper ContributorI've recently built something similar with SPFx. It uses a daily Azure function to generate a JSON file of the structure and then a SPFx web part consumes the JSON to create a full organisation chart
- Paul MitchellAug 25, 2020Brass Contributor
Raymond Little would you be prepared to share any details?
- Raymond LittleAug 25, 2020Copper Contributor
Paul Mitchell we created a custom solution to handle this. Basically used a back end job to generate a full org hierarchy once a day and then created a custom SharePoint web part to display that. It was developed for internal use and it was tricky to get a good layout with a lot of users but it was possible.
- Thomas BakJan 31, 2019Brass Contributor
I suppose that makes it faster than if you have to load on-the-fly although I do think the supported endpoints are performing quite well.
How many employees do you have in the JSON?
How versatile did you build your web part, i.e. can the user expand levels to get a bigger org chart?
Would you mind sharing a screenshot?
- Raymond LittleJan 31, 2019Copper Contributor
Hey,
We have 140 employees in our organisation and the chart shows all employees on one page using the SharePoint Online single application page. I can't really show the chart as it contains our organisation data but if I get time I'll try and swap it for dummy data.
I don't think its possible to do real time as it involves a significant amount of calls to the graph, about 3 per user, so I wouldn't want to put that kind of load of a users browser.
Cheers,
Ray