I'm trying to design a way to use power apps to manage a large library of PDF files. I want to be able to pull a client, see all of their associate documents/PDFs and then select one to open up (not simply view) either in a browser or in the adobe app.
First thought
Create links to a network file share so the document could be retrieved from there. This apparently does not work for security reasons, I realize you would have to be already authenticated on that server.
Second thought
Load the PDFs in SQL and then somehow retrieve them back in Power Apps. The only solution I have found for this is to pull them back into the image viewer and I don't believe this would give allow me to download, print, etc.
Third thought
Use OneDrive as my file share and access via links to each document, but in researching it appears OneDrive is setup for personal use primarily and I would have to share a folder I created under my personal profile with the rest of our organization which sounds sketchy.
Fourth thought
I actually had this running for awhile, create a flow that copies the document from a local file share to OneDrive passing the link back to Power Apps. This was slow and required anyone opening PowerApps to authenticate to our local file server which was a pain.
Fifth thought
Create an internal document server so that the stored links could be pulled from their via an HTTPS link, but it appears this can only be done if you do not need to authenticate into the server, and I would need for the documents to be secured even thought they would only be accessible internally.
I have given this much thought and do not see a clean way to accomplish. I don't believe I have access to a SharePoint server so hoping maybe someone has a better idea. Thanks for any help.
