[Jan 7, 2021] Gordon Hu from WeGalvanize posted:
Hello Pros!
I would like to see how other pros maintain the organization’s O365 Cloud Distribution Groups. As Microsoft points out in the KB, it’s not supported by Graph API.
![uploaded by user](https://groups.google.com/a/workato.com/group/automation-pros/attach/3e1eb6d4b4bb/image001.png?part=0.1&view=1)
Background:
- We are an Okta customer. Okta support O365 Group Push. Unfortunately, it does not support distribution group.
- We have AD-imported users in Okta – from 4 different ADs due to acquisition and rebranding. There is no direct connection between AD and O365. Okta is sitting in between.
What we are doing now is via On-Prem Agent:
- Extract information such as department, location, emails, etc. from HR system. Then compose a CSV file to send to the On-Prem Agent location.
- Then execute a PowerShell Script to use the CSV file and place users in the right groups.
Challenge:
- I am not a fan of anything on-prem 😊 .
- PowerShell Script violate the low-code motto.
- Sometimes I noticed that not all the users are added properly due to unknown reason on Microsoft end. I have to set up another recipe to monitor the result + check if there is any consistency.
Workato’s role in this workflow is primarily getting data from HR. It doesn’t play an important role in adding people to distribution groups.
I am wondering how others do it. Thank you for your time in sharing your ideas.