HI @iwonder ,
Do you want to use the Attachments control to attach multiple files, and then save them back to your SQL Server Table?
Regarding the needs that you mentioned, I think the Attachments control could achieve your needs. Firstly, you need to add a varchar(max) type column in your SQL Table to store the binary format data of these uploaded files in your Attachments.
Please check and see if the following video resource could help in your scenario:
https://www.youtube.com/watch?v=kQVYid1p_vA
https://www.youtube.com/watch?v=UYK7yruBHDM
If you just want upload image files from your canvas app into your SQL Table, I think it is not necessary to set up a Power Automate flow to help you achieve your needs along with the canvas app. You just need to save these images files attached in the Attachments control into a collection, then add a Gallery control in your app to display these image data stored in this collection using Image control. After that, you could use the JSON function to convert the image blob data into a actual base64 encoded data, then use the Patch function to save the base64 encoded data back to your SQL Table.
You may need to use the following formula to save your Gallery image data back to your SQL Table:
ForAll(
ImageGallery.AllItems,
Patch(
'[dbo].[SQLTable]',
Defaults('[dbo].[SQLTable]'),
{
ImageColumn: Substitute(JSON(Image1.Image, JSONFormat.IncludeBinaryData), """", ""),
...
...
}
)
)
Note: The ImageColumn represents the varchar(max) type column in your SQL Table.
Also please check if the following video resource could help in your scenario:
https://www.youtube.com/watch?v=QnDD7jleHME
Regards,
