Forum Discussion
NiviPower
May 10, 2020Copper Contributor
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...
Ashish_Kohale
May 26, 2020Iron Contributor
NiviPower : Yes, this seems to be possible. Once the request get approved, at the back end you have to do some parallel operation filter a query based on (Country->Region->State->City) and pass it to the SharePoint view so that SharePoint view gets filtered according the query. You can then either user to export this data for the reporting purpose.
Or else same can be achieved through PowerBI to which you have to use Power Automate and PowerBI connectors.