Access Request Sharepoint Site

%3CLINGO-SUB%20id%3D%22lingo-sub-1377922%22%20slang%3D%22en-US%22%3EAccess%20Request%20Sharepoint%20Site%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1377922%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Experts%2C%3C%2FP%3E%3CP%3EI%20am%20looking%20for%20a%20SharePoint%20functionality%20to%20implement%20in%20our%20reporting%20project.%3C%2FP%3E%3CP%3EI%20have%20a%20SQL%20server%20database%20table%20which%20has%20City%20Hierarchy%20data.%20Now%20I%20want%20to%20build%20a%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EReports%20Access%20Site%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ewhich%20should%20have%20the%20City%20arranged%20in%20hierarchical%20order%20(Country-%26gt%3BRegion-%26gt%3BState-%26gt%3BCity).In%20order%20to%20view%20the%20data%20for%20respective%20cities%2C%20the%20user%20need%20to%20go%20to%20this%20site%20and%20create%20an%20access%20request%20by%20selecting%20the%20cities%2Fstate%2Fregion%2Fcountry%20he%20needs%20access%20to%20and%20then%20submit%20for%20approval.%3C%2FP%3E%3CP%3EThis%20request%20should%20then%20go%20through%20various%20approval%20levels%20and%20then%20store%20this%20request%20along%20with%20approval%20details%2Fstatus%20in%20another%20database%20table%20in%20SQL%20SERVER%20so%20that%20it%20can%20be%20used%20by%20system%20to%20provide%20access.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20this%20doable%20and%20if%20yes%20then%20is%20there%20any%20links%2Fvideos%20which%20can%20guide%20me%20on%20how%20to%20do%20it.%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3ENivi%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1377922%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1378012%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Request%20Sharepoint%20Site%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1378012%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F662408%22%20target%3D%22_blank%22%3E%40NiviPower%3C%2FA%3E%26nbsp%3Byou%20could%20do%20this%20with%20a%20flow%20in%20Power%20Automate.%20The%20SQL%20Server%20connector%20is%20premium%20so%20will%20cost%20something.%20Once%20you've%20got%20the%20relevant%20licence%20you%20could%20create%20a%20flow%20and%20have%20a%20button%20on%20each%20item%20of%20your%20SharePoint%20list%20which%20would%20trigger%20it%20to%20request%20access.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22RequestAccess.png%22%20style%3D%22width%3A%20313px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190447i6F03649EB756BC45%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22RequestAccess.png%22%20alt%3D%22RequestAccess.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20your%20flow%20you%20would%20use%20a%20Start%20and%20Wait%20for%20approval%20action%20for%20each%20of%20the%20levels%20of%20approval.%20After%20everyone%20has%20approved%2C%20the%20flow%20would%20save%20the%20request%20and%20all%20the%20approval%20details%20(decision%2C%20date%20approved%2C%20comments)%20to%20a%20new%20row%20in%20SQL%20Server%2C%20so%20you'd%20need%20fields%20for%20everything.%20An%20email%20could%20then%20be%20sent%20automatically%20as%20the%20last%20action%20in%20the%20flow%20to%20the%20original%20requestor%20with%20the%20details%20of%20the%20approval.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20don't%20have%20SQL%20Server%20or%20the%20connector%20so%20can't%20do%20a%20demo%2C%20but%20it's%20certainly%20do-able%20in%20Power%20Automate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1378074%22%20slang%3D%22en-US%22%3ERe%3A%20Access%20Request%20Sharepoint%20Site%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1378074%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40Rob%20Elliott%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20the%20reply.%3C%2FP%3E%3CP%3ECan%20you%20direct%20me%20to%20a%20link%2Fvideo%20demo%20where%20the%20source%20and%20destination%20will%20be%20a%20CSV%20file%2FExcel%20file.%20I%20can%20have%20an%20idea%20and%20can%20replicate%20it%20with%20SQL%20server.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi Experts,

I am looking for a SharePoint functionality to implement in our reporting project.

I have a SQL server database table which has City Hierarchy data. Now I want to build a Reports Access Site which should have the City arranged in hierarchical order (Country->Region->State->City).In order to view the data for respective cities, the user need to go to this site and create an access request by selecting the cities/state/region/country he needs access to and then submit for approval.

This request should then go through various approval levels and then store this request along with approval details/status in another database table in SQL SERVER so that it can be used by system to provide access.

 

Is this doable and if yes then is there any links/videos which can guide me on how to do it.

Thanks

Nivi

2 Replies

@NiviPower you could do this with a flow in Power Automate. The SQL Server connector is premium so will cost something. Once you've got the relevant licence you could create a flow and have a button on each item of your SharePoint list which would trigger it to request access.

 

RequestAccess.png

 

In your flow you would use a Start and Wait for approval action for each of the levels of approval. After everyone has approved, the flow would save the request and all the approval details (decision, date approved, comments) to a new row in SQL Server, so you'd need fields for everything. An email could then be sent automatically as the last action in the flow to the original requestor with the details of the approval.

 

I don't have SQL Server or the connector so can't do a demo, but it's certainly do-able in Power Automate.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

@RobElliott ,

 

Thanks for the reply.

Can you direct me to a link/video demo where the source and destination will be a CSV file/Excel file. I can have an idea and can replicate it with SQL server.

 

Thanks