Hello, I have a problem with making a patch from the gallery to SharePoint.
This is my app and gallery:
This is SP List:
I would like to update all the elements entered in the gallery, if I do not change the values, then they will remain the same as they were saved in SP.I have this code but it doesn't work properly, I don't know why. It changes only one line of code, usually the first one. Does anyone of you know why and can help me?
With(
{SelectedItem2: Gallery5.AllItems},
ForAll(
SelectedItem2 As Item2,
Patch(
ev_List_Sharepoint_Milestone,
LookUp(
ev_List_Sharepoint_Milestone,
'Contract Number' = Item2.'Contract Number' && 'Responsible Persons'.Value = Label7.Text
),
{
'Project Owner': If(
Len(TextInput1.Text) > 0,
TextInput1.Text,
LookUp(
ev_List_Sharepoint_Milestone,
'Contract Number' = Item2.'Contract Number' && 'Responsible Persons'.Value = Label7.Text
).'Project Owner'
),
'Reporiting Month': Text(
Date(
Year(
DateAdd(
Today(),
-1,
TimeUnit.Months
)
),
Month(
DateAdd(
Today(),
-1,
TimeUnit.Months
)
),
1
),
"dd.mm.yyyy"
),
'Partner 1': If(
Len(TextInput1_1.Text) > 0,
TextInput1_1.Text,
LookUp(
ev_List_Sharepoint_Milestone,
'Contract Number' = Item2.'Contract Number' && 'Responsible Persons'.Value = Label7.Text
).'Partner 1'
),
'Partner 2': If(
Len(TextInput1_2.Text) > 0,
TextInput1_2.Text,
LookUp(
ev_List_Sharepoint_Milestone,
'Contract Number' = Item2.'Contract Number' && 'Responsible Persons'.Value = Label7.Text
).'Partner 2'
),
'Partner 3': If(
Len(TextInput1_3.Text) > 0,
TextInput1_3.Text,
LookUp(
ev_List_Sharepoint_Milestone,
'Contract Number' = Item2.'Contract Number' && 'Responsible Persons'.Value = Label7.Text
).'Partner 3'
)
}
)
)
),
Label7 is the label under the Responsible Person column in the application
