Hello everyone,
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?
Hi @AMannan,
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:
https://powerapps.microsoft.com/en-us/blog/add-attachments-to-sharepoint-lists/
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:
https://powerapps.microsoft.com/en-us/blog/upload-files-from-powerapps-to-sql-server/
Best regards,
Kris
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?
Any update on this? I am also looking for similar functions.
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?
One more for retrieving / uploading files to SQL server in Powerapps.
On I know, I was looking for an intermediate fix, but now we are going to use Yardly and Sharepoint in conjunction with PowerApps.