web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Unanswered

Power Automate Flow to e-mail sharepoint site creator via e-mail

(0) ShareShare
ReportReport
Posted on by

I found an article that indicated every time a sharepoint site is created on your tenant, a list item gets added to the DO_NOT_DELETE_SPLIST_TENANTADMIN_AGGREGATED_SITECOLLECTIONS list on your admine site, so that is how I am triggering the flow. The problem I am having is determining the e-mail address for the individual that creates the site. 

It occured to me that creating a sharepoint site also creates an O365 group with the creator as the only initial member, so perhaps I can query the O365 group (the created by for the list item) and use that to get the member's e-mail address. I found this article :

 

https://powerusers.microsoft.com/t5/Building-Flows/Getting-group-members-by-office-365-group-name-in-Flow/td-p/703509

 

But our flow has to execute under a service account that doesn't own the O365 group. Been struggling finding a solution for a couple days so decided it's community posting time. Does anyone know a way in which from power automate I can determine the site creator's e-mail address? It does not come across with the fields of the list item. Thanks for any guidance you can provide.

I have the same question (0)
  • Expiscornovus Profile Picture
    32,869 Most Valuable Professional on at
    Re: Power Automate Flow to e-mail sharepoint site creator via e-mail

    Hi @Anonymous,

     

    I would look into using either the List owners and Add owners methods of the Graph API. You could register a app in Azure AD for this with the correct permissions for Groups.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 647 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 350 Moderator

#3
developerAJ Profile Picture

developerAJ 256

Last 30 days Overall leaderboard