I had a requirement that using On Premises SQL server i want the attachment functionality in PowerApps edit form so that i can attach any file such as Pdf,Word,excel etc and stored it in SQL table and display against the same record whenever i browse the app.
After doing alot of research i didn't find a way to do this except for storing and displaying image as it is the only supported feature with On premises SQL server. I also found that Sharepoint has a functionality to attach any file with records and it can also integrate with powerapps but i want to use both SQL and Sharepoint in the app.
Is it possible to save file on Sharepoint and its public URL in SQL table record so that whenever i open the app and browse for that record considering sql as datasource, it should load the attachment from sharepoint through that public URL?
Do you want to save files into your SQL table using PowerApps app?
If you want to save attachments to your SharePoint list, please check the following blog:
In addition, if you want to upload files into your SQL table, please check and see if the following blog would help in your scenario:
I had already checked the second link provided by you, its not helpful in my scenario. I want to save and retrive files from SQL server into PowerApps which is not currently happening as most of the PowerApps user has reported the same issue on the post.
I also would need to retrieve files from on-premises sql to PowerApps. Any tips how to do it with current version or is there some new functionality expected?
On I know, I was looking for an intermediate fix, but now we are going to use Yardly and Sharepoint in conjunction with PowerApps.
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.