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.
Check out new user group experience and if you are a leader please create your group
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Participate in the Power Virtual Agents Community Challenge
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.