Forum Discussion
SharePoint Access Approvals with Flow
Thanks for the info. These images appear to already be approved to access the Site Pages but I think I get the gist of what you are saying.
Have you thought about going down a different road and use Microsoft Forms to source the initial request?
Example:
Step 1: Fill in some fields in the Microsoft Form
e.g. Might be a drop down list of folder names within the site that people may need to access. The user will select the appropriate file. It may even only be this one field.
Step 2: User submits the form.
Step 3: Microsoft Flow picks up the form submission and sources the users manager
(a) Use 'When a new response is submitted' as the trigger.
(b) Use 'Get response details' to retrieve the forms info.
(c) Use 'Get manager (V2)' using the responders email address (found in step b). This should bring up their managers details.
(d) You can extract the managers email address to use for the approvals process (use something like 'Start and wait for an approval (V2)'.
(e) Manager reviews the approval and hits approve/reject.
(f) Use a Condition to then say If:
- Approve, then sends you an email to say so with the appropriate user details, manager details, etc to action.
- Reject then send a message to the requester saying that their access has been denied by their manager (I assume that you don't want to be bothered to know if someone has been denied).
Check out below, I've mocked up the first part of the process that I've just described.
You could embed the form into a SharePoint page that users can access when they need to make their request and/or just send them the link to the form.
This might be a better way to go given the challenges with the SharePoint no-reply emails?
Cheers and best wishes
Damien
Dear Damien_Rosario ,
Thank you for your message! I've tried your method but failed unfortunately. Access requests come from a common email address (no-reply@sharepointonline.com) for every request. Therefore, setting a flow trigger with new mail won't work as I need this flow to be active only for 1 library but not whole site. Also, I will need user name to be used on "Get Manager" action and it couldn't extract the user information from the email. But thank you anyway, I appreciate your support!
Out of curiosity, are you able to please provide a redacted email (just hide the username or any other sensitive info) so I can see the content of the request that you receive?
I'm curious to see the roadblocks in the email and perhaps maybe come up with a creative solution depending on what's in it!
Cheers
Damien
Hello Again Damien_Rosario,
It look like the attached. I've tried to exract information from the subject to "Get User" function but it didn't work unfortunately. Your support is appreciated!
Best Regards,
YigitThanks for the info. These images appear to already be approved to access the Site Pages but I think I get the gist of what you are saying.
Have you thought about going down a different road and use Microsoft Forms to source the initial request?
Example:
Step 1: Fill in some fields in the Microsoft Form
e.g. Might be a drop down list of folder names within the site that people may need to access. The user will select the appropriate file. It may even only be this one field.
Step 2: User submits the form.
Step 3: Microsoft Flow picks up the form submission and sources the users manager
(a) Use 'When a new response is submitted' as the trigger.
(b) Use 'Get response details' to retrieve the forms info.
(c) Use 'Get manager (V2)' using the responders email address (found in step b). This should bring up their managers details.
(d) You can extract the managers email address to use for the approvals process (use something like 'Start and wait for an approval (V2)'.
(e) Manager reviews the approval and hits approve/reject.
(f) Use a Condition to then say If:
- Approve, then sends you an email to say so with the appropriate user details, manager details, etc to action.
- Reject then send a message to the requester saying that their access has been denied by their manager (I assume that you don't want to be bothered to know if someone has been denied).
Check out below, I've mocked up the first part of the process that I've just described.
You could embed the form into a SharePoint page that users can access when they need to make their request and/or just send them the link to the form.
This might be a better way to go given the challenges with the SharePoint no-reply emails?
Cheers and best wishes
Damien
Hello Again Damien_Rosario,
It look like the attached. I've tried to exract information from the subject to "Get User" function but it didn't work unfortunately. Your support is appreciated!
Best Regards,
Yigit
