You’re offline. This is a read only version of the page.
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 :
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.
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.
Share
Report
All responses (
Answers (
33,181
