Forum Discussion

NiviPower's avatar
NiviPower
Copper Contributor
May 10, 2020

Access Request Sharepoint Site

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...
SharePoint
RobElliott's avatar
RobElliott
Silver Contributor
May 10, 2020

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.

 

 

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

  • NiviPower's avatar
    NiviPower
    Copper Contributor
    May 10, 2020

    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

     

Resources