Hi @DG1000 ,
Do you want to save image along with other fields data back to your SQL Table?
Do you use the collection to store the image for each record in your SQL Table?
Based on the screenshot and formulas you provided, I think there is something wrong with it. Firstly, if you want to store the images for each record in a collection, I afraid that there is no way to achieve your needs.
The collection is a temporary table data within canvas app, which would be destroyed when you close your canvas app. And you could save single one image data back to the IMAGE field in your SQL Table from your canvas app.
In addition, when you edit an existing record in your SQL Table, the standard format should be like below:
Patch(
'[dbo].[SQLTable]',
LookUp('[dbo].[SQLTable]', PrimaryKey = "xxxxx"), // Find the record you want to update
{
CREATOR: txtCREATOR_1.Text,
PRIORITY: cmbPRIORITY_1.Selected.Value,
...
...
}
)
As an fixed solution, you could create another SQL table (called "[dbo].[TicketsITImages]") to store the images for each record in your current SQL Table ('[dbo].[tblTicketsIT]'). Within the '[dbo].[TicketsITImages]' table, you need to add the following columns:
TicketID int primary key not null,
ImageData varchar(max)
Note: The TicketID column is used to store the ID column value of the Ticket record in your '[dbo].[tblTicketsIT]' table.
Within your UploadImageNewScreen, set the OnSelect property of the "Upload" button to following:
Collect(
MyCam,
{
IMAGE: UploadedImage2.Image
}
)
Within your New Record Screen, set the OnSelect property of the "Save" button to following:
Set(
CurrentItem,
Patch(
'[dbo].[tblTicketsIT]',
Defaults('[dbo].[tblTicketsIT]'),
{
CREATOR: txtCREATOR_1.Text,
PRIORITY: cmbPRIORITY_1.Selected.Value,
DEPARTMENT: txtDEPARTMENT_1.Text,
LOCATION: txtLocation_1.Text,
ISSUE: txtISSUE_1.Text
}
)
);
ForAll( // add formula here to upload image back to new added SQL Table for above submitted Ticket record
MyCam,
Patch(
'[dbo].[TicketsITImages]',
Defaults('[dbo].[TicketsITImages]'),
{
TicketID: CurrentItem.ID,
ImageData: IMAGE // IMAGE column value is from MyCam collectino
}
)
);
Set(CurrentItem, Blank());
Reset(...);
....
Clear(MyCam);
Nvigate(GalleryScreen)
Within your GalleryScreen, set the OnSelect property of the ">" icon to following:
Set(CurrentItem, ThisItem);
Clear(MyCam);
ForAll(
Filter('[dbo].[TicketsITImages]', TicketID = CurrentItem.ID),
Collect(
MyCam,
{
ID: TicketID,
IMAGE: ImageData
}
)
);
Navigate(EditScreen)
Within your UploadedImageEditScreen, set the OnSelect property of the "Upload" button to following:
Collect(
MyCam,
{
IMAGE：UploadedImage2_1.Image
}
)
Within your Edit Record Screen, set the Items property of the Vertical Gallery to following:
MyCam
set the Image property of the Image control within this Vertical Gallery to following:
ThisItem.IMAGE
Set the OnSelect property of the "Save" button to following:
Patch(
'[dbo].[tblTicketsIT]',
LookUp('[dbo].[tblTicketsIT]', ID = CurrentItem.ID), // Find the record you want to update
{
CREATOR: txtCREATOR_1.Text,
PRIORITY: cmbPRIORITY_1.Selected.Value,
DEPARTMENT: txtDEPARTMENT_1.Text,
LOCATION: txtLocation_1.Text,
ISSUE: txtISSUE_1.Text
}
);
ForAll(
Filter(MyCam, IsBlank(ID)), // Find these new appending image data
Patch(
'[dbo].[TicketsITImages]',
Defaults('[dbo].[TicketsITImages]'),
{
TicketID: CurrentItem.ID,
ImageData: IMAGE // IMAGE column value is from MyCam collectino
}
)
);
Set(CurrentItem, Blank());
Reset(...);
...
...;
Clear(MyCam);
Navigate(GalleryScreen)
Please take a try with above solution, check if the issue is solved.
Best regards,
Community Support Team _ Kris Dai
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
