How to integrate SNOW and M365 for distribution list creation

[vishalsal]

Respected Team,

I want to integrate SNOW and M365 for automating distribution list creation. Your guidance will be helpful.
SNOW catalogue is used for requesting a new DL or updating a DL. 
M365 team has their own script for DL creation.

Need some to ingrate them so that once user submits a request for a new DL or updating a DL once approved in the catalogue SNOW should trigger the M365 script. 

[palanikumar]

Hi @vishalsal ,

As per my knowledge, Microsoft don't have graph APIs for Distribution List. Since all the integration spokes are based on Graph API, there is no direct spoke available to manage Distribution List.

However, you can achieve this by executing PowerShell Script from flow designer.

[vishalsal]

@palanikumar  Thank you sharing this.

I am new to SNOW and  learning some technical parts so can you guide me on how this can be achieved?
1) Clue of creating this PowerShell script 
2) Some guidance on how to implement in flow designer?
3) Any video/doc that can be as guidance ?

I can ask one of the SNOW developer to work as you guide 

[Dr Atul G- LNG]

Hi @vishalsal 

1st thing, it is not SNOW, it is SN or ServiceNow not SNOW.

Agree with @palanikumar  there is no OOTB spoke available which menas, you need to create a custom spoke to do you work. Did you search in google ?

[palanikumar]

Hello @vishalsal ,

You can refer below URL for basic details:

https://www.servicenow.com/docs/bundle/yokohama-build-workflows/page/administer/flow-designer/refere...

https://support.servicenow.com/kb?id=kb_article_view&sysparm_article=KB0995390

Please note: You reach to your M365 or Exchange Online team for the PowerShell script as this community member may not help you on PowerShell Scripts