We have a number of sub-sites that are used to assist with projects and share documents between internal teams (Domain group) and external organisations (SharePoint group).
Each subsite has a business owner who is responsible for the content that is shared and who it is shared with.The site business owners are recorded against each site in a SharePoint list, see attach.
What we would like to do is, on a 6 monthly basis email the business owner and prompt them to review the content and the guest accounts that the content is shared with.
It would be nice if a Flow could be created that emailed the business owner with a list of guest accounts that has access to their sub-site every 6 months.
Has anyone else had this requirement and how have they tackled it?
Thanks for your time,