I have never used flow before but have to create the following workflow. I am also considering Sharepoint Designer but wanted to see if flow can do it easier/quicker:
Users put a request in to say they want authorisation and why they want it, in order to download files. I was thinking of using Infopath to create this form..
The Request is then reviewed by an IT Team/person who can see what the person has access to and edit/view
The IT team then send this form to a managing director who will say Yes or No
Form then goes back to IT Team who give the authorisation or not
Form sent back to the User or just Authorisation turned on/off and user notified
So it looks like I need an Input form, a database to store user info and this 5 step Workflow
Please could anyone help with resources/guides or if this is the best simple yet efficient approach to this task? I am looking at guides etc in the meantime or if all this is possible using flow!
P.s. If i wanted users who submit the form not to be able see or edit the column say 'Approved', would I have to create different views? I would like say the IT Team to be able to edit and add info to a column but everyday users not be able to see or edit these.
Thank you for your time and I appreciate any replies!
I would appreciate any replies.
I assume that your scenario could be achieved by a flow likes below.
1.From your description, it seems that requesters will submit their requests in a list. Add the trigger When an item is created in SharePoint list.
2.The request will be reviewed by an IT team, add an action Start an approval for the first approval.
3.IT team send the request to director, add second Start an approval action.
4.Form then goes back to IT Team. If the approval response is equal to Approve, send an email to IT team to give authorization, then send another email back to the requestors to notify them.
A screenshot for your reference.
Thank you very much for the informative reply! It is very helpful
I was wondering if you knew how I would set up the SharePoint site? Would I just need a new list called say 'download authorisation requests' and have columns such as Title, Date, and Approved?
Users can then fill in a template word form and upload it to here? Also I was struggling to find the 'TO Email' in the first flow step.
Can it be done so the file uploaded is attached to the authorisation email sent to say the IT Team?
Unfortunately it is my first time designing a sharepoint site as well! If you have any useful guides or tips to do this, much appreciated!
Before creating the flow, we need to create a SharePoint site and create a proper connection to it. Besides, when using the SharePoint triggers/connections, a list is required. You could create a custom list and add columns of different type based on your scenario, add columns such as Title, Date, etc.
The following doc on Create a team site in SharePoint Online could be your reference:
And following docs on list and columns for your reference:
About the dynamic content To Email in the first flow step, it is a column of type Person or group and named as To which contains the email address of the user to whom I want to send an email.
A screenshot of my list:
Thank you once again for the informative reply.
Quick question if you havnt mentioned already.
EDIT - I have had a go at the flow but just wanted to confirm the above 🙂
Keep up to date with current events and community announcements in the Power Automate community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!