Share
ReportI 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.
All responses (
Answers (
32,869
