Hello everyone, I have a canvas application in which the user uploads files using the attachment control. How can I store the file in binary

Storing file in sql server table

Happy to help.

As for @ronaldwalcott they are looking for you to explain how as they do not know, so whatever approach you be teach them is what they need.

Upload Files from PowerApps to SQL Server - Microsoft Power Platform Blog

and

Example

Certainly! Saving an image to SQL Server directly from a Power Apps Canvas app without using Power Automate involves a few steps. Here's a concise guide to help you achieve this:

Step 1: Prepare Your SQL Server

Create a Table: Ensure you have a table in your SQL Server database to store the image. The table should have a column of type VARBINARY(MAX) to store the image data.
```
CREATE TABLE Images (
    Id INT PRIMARY KEY IDENTITY(1,1),
    ImageData VARBINARY(MAX)
);
```

Step 2: Set Up Power Apps

Create a Canvas App: Open Power Apps and create a new Canvas app.

Add SQL Server Connection: Go to the Data tab, click on "Add data," and select SQL Server. Connect to your database.

Step 3: Add Controls to Your App

Add an Image Control: Insert an Image control to capture or display the image.

Add a Camera Control: Insert a Camera control to take pictures.

Add a Button: Insert a Button control to trigger the save action.

Step 4: Write the Code

Capture the Image: Use the Camera control to capture the image and store it in a variable.
```
Set(capturedImage, Camera1.Photo)
```

Convert Image to Binary: Power Apps does not directly support binary conversion, so you need to use a workaround by converting the image to a data URI and then to binary.
```
Set(imageDataUri, JSON(capturedImage, JSONFormat.IncludeBinaryData))
```

Save Image to SQL Server: Use the Patch function to save the image data to SQL Server.

Patch(
    '[dbo].[Images]',
    Defaults('[dbo].[Images]'),
    {
        ImageData: Mid(imageDataUri, Find(",", imageDataUri) + 1)
    }
)

Step 5: Test Your App

Run the App: Test the app by capturing an image and clicking the save button.

Verify Data: Check your SQL Server table to ensure the image data is saved correctly.

Notes

Performance: Be mindful of the image size as large images can impact performance.

Security: Ensure your SQL Server connection is secure and follow best practices for handling binary data.

By following these steps, you can save images directly to SQL Server from a Power Apps Canvas app without needing Power Automate. If you encounter any issues or need further customization, feel free to ask!

I hope this helps and if so, please Mark as such and maybe a like

Quick Links

Leaderboard