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 have similar requirement. I need to upload as well as retrieve files from SQL Server database. What are the steps to do this in PowerApps?
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?
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
We are excited for the next Super User season.
Check out whats happening in Power Apps
FIll out a quick form to claim your community user group member badge today!
Features releasing from October 2020 through March 2021