Hello,
Need anyone helps to fix my error. I have 7 columns in gallery: 2 Date fields, 3 dropdown box, 1 combo box and 1 text.
I have setup all of them as per in youtube. However, I noticed when I tried to make changes to the data, the dates, combo box and 2 of the dropdowns are not being updated. Below is how i setup them, please review and see if I make any mistakes.
Their DefaultSelectedItems/SelectedDate/Value as below:
-------------
ThisItem.TeacherName
ThisItem.'Start Date'
ThisItem.'End Date'
{Value:ThisItem.'Subject'}
{Value:ThisItem.'Course'}
{Value:ThisItem.'StudentsName'} *I use 365 people picker, select multiple value
ThisItem.Remarks
I put codes in hidden button called 'buttoncanvas1' as below:
---------------
UpdateIf(
colGridUpdates,
ID = ThisItem.ID,
{
TeacherName: Name.Selected,
'Start Date': StartDate,
'End Date': EndDate,
'Subject': DrpS.Selected.Value,
'Course': DrpCourse.Selected.Value,
'StudentsName': ComboboxCanvas1.SearchText,
Remarks: TextRemarks.Value
}
)
Every fields I put on OnChange value
-----------------------------
select(buttoncanvas1)
For save button as below:
-----------------------------
Patch(
'School Records',
ShowColumns(
colGridUpdates,
"TeachersName",
"StartDate",
"EndDate",
"Subject",
"Course",
"StudentsName",
"Remarks",
"ID"
)
);
Notify(
"Records successfully submitted/saved",
NotificationType.Success,
4000
);
Clear(colGridUpdates);
Set(
varReset,
false
);
Set(
varReset,
true
)
