File Attachment Functionality With On Premises SQL Server in PowerApps

[AMannan]

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?

[v-xida-msft]

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

[AMannan]

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.

[RustyNails]

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?

[AthenaDepper]

Any update on this? I am also looking for similar functions.

[atte]

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?

[Anonymous]

adding in @GregLi to review and assist

@Anonymous

[pepeday]

One more for retrieving / uploading files to SQL server in Powerapps.

[Shanescows]

SQL is the slowest possible solution for storing files. You should really consider Azure Blob Storage. 😀 https://youtu.be/wF0MmiaGO_o

[AthenaDepper]

On I know, I was looking for an intermediate fix, but now we are going to use Yardly and Sharepoint in conjunction with PowerApps.