Storing files as bytes in SQL Server through Power Apps without using Azure

(0) Share

Report

Posted on by gikido

986

Hello everyone,

I have an application in Power Apps, and among the services, there is an option to upload files using the attachment control (not the add image control).

The database is in SQL Server, and the client does not want to use Azure, so I want to store the file in the database as bytes, with the option to view the file afterward.

Thank you in advance.

I have the same question (0)

All responses (4)

Answers (0)

Power Platform 1919 1,660 on at

Like (0)

Report

Storing files as bytes in SQL Server through Power Apps without using Azure

Hi @gikido,

You can store the file content as a Base64-encoded string in a SQL table. However, this approach can lead to performance issues if the files are large, because transferring and decoding the data on the client side, such as in Power Apps, takes more time and resources.

If you are dealing with large files or multiple attachments, it is better to use dedicated storage options such as Dataverse file or image columns, SharePoint document libraries, or Azure Blob Storage. These are optimized for handling file data efficiently and reduce the load on your app’s performance.

Was this reply helpful? Yes No
developerAJ 4,611 on at

Like (0)

Report

Storing files as bytes in SQL Server through Power Apps without using Azure

sql does have byte datatype you can use it.

use power automate to add the record instead of directly from powerapps

Was this reply helpful? Yes No
developerAJ 4,611 on at

Like (1)

Report

Storing files as bytes in SQL Server through Power Apps without using Azure

but better way is to use Sharepoint or blob storage as file stoage system and use the reference of file in SQL

Was this reply helpful? Yes No
Suggested answer

developerAJ 4,611 on at

Like (0)

Report

Storing files as bytes in SQL Server through Power Apps without using Azure

If this solution helped you resolve your issue, kindly mark it as accepted — it makes it easier for others to find and also closes the discussion.

🏷️ Please tag me @developerAJ if you still have any queries or issue persists

🤝 Let’s connect on LinkedIn

📘 Explore more on my articles

🐱‍💻 Github Link

💼👥 Looking for Jobs Power Platform & Microsoft Jobs Network

Was this reply helpful? Yes No