1

Is there any web hook or Power Automate trigger available when a new site is created in SharePoint Online?

Goal is to send a customized email to site owners when the new site is created.

Newly created sites will be Modern SharePoint Online sites (Communication site).

I could not find any trigger for this.

Improve this question

1 Answer 1

Reset to default
2

As per Get all site collections listed in SharePoint Admin center using Rest / Search / Graph api, all site collections created in tenant are stored in list "DO_NOT_DELETE_SPLIST_TENANTADMIN_AGGREGATED_SITECOLLECTIONS".

So, you can create a simple flow like below using tenant admin account to notify user on new site creation:

enter image description here

Where Site Address is SP admin site URL like: https://<tenant>-admin.sharepoint.com/ & List Name is DO_NOT_DELETE_SPLIST_TENANTADMIN_ALL_SITES_AGGREGATED_SITECOLLECTIONS.

Output:

enter image description here

Update from comments:

I just tried creating new communication site in my tenant & received email like:

enter image description here

Improve this answer
6
  • I created the flow and then created the new site but the flow is not triggered. I can see the new site name using REST API
    – Dhruvil Prajapati
    Commented Nov 19, 2021 at 9:38
  • Are you able to access the mentioned list from https://tenant-admin.sharepoint.com/_layouts/15/viewlsts.aspx page? Did you use the correct list name in flow (just to make sure as there are few lists with similar names)? How much time you waited after creating a new site?
    – Ganesh Sanap - MVP
    Commented Nov 19, 2021 at 10:00
  • Yes I am able to see the list. I waited for around 2 hours. This is the list name. DO_NOT_DELETE_SPLIST_TENANTADMIN_ALL_SITES_AGGREGATED_SITECOLLECTIONS
    – Dhruvil Prajapati
    Commented Nov 19, 2021 at 11:39
  • 1
    Yes, I can see the new site name. I will check again after some time. but thanks for the help
    – Dhruvil Prajapati
    Commented Nov 19, 2021 at 11:46
  • 1
    I just tried creating a new site & received an email. check screenshot in updated answer. Try creating flow & using connection with SharePoint tenant administrator user account once.
    – Ganesh Sanap - MVP
    Commented Nov 19, 2021 at 11:51

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.