When we approve a external access request to our site we want to send an email to that user.
I want to create an automatic flow to detect when a new row is added within the Sharepoint site permission group to then fetch that users email and send an email to them welcoming them to the site.
Looking at automate there is no trigger for this, they all reference lists/folders etc. Nothing to do with security groups. Ive found I could do something like this but with a manual trigger then get HTTP request but this is not what we want as we want to to be automatic upon us approving access to the site.
Is this possible ?