So I have an On-Prem SharePoint contract management app that has a bunch of custom webparts that talk to a custom back-end On-Prem SQL database. Its runs on SharePoint 2016. The app creates a new subsiite for each contract whenever the user creates a new contract. The subsite has a Document library where users can store documents related to the contract. The app stores the WebID of the subsite in the custom back-end database, along with all the metadata associated with the contract. The SharePint app is a sibgle Site Collection with a subweb for each contrct.
I have PowerApp that connects to custom back-end database using the On-Prem gateway. It can read all the all the metadata associated with the contract, including the WebID.
I need the PowerApp to fetch and display documents from the On-Prem SharePoint site with the given ID. I could connect directly to the SharePoint Content Database from the PowerApp and get the data that way, but I know this is not supported.
Is there a way to dynamically connect a PowerApp to a site using a WebID? Can I somehow configure a flow to call into my On-Prem sharepoint farn to get the documents?

Report
All responses (
Answers (