Hello, I need to update multiple fields in one record in a SharePoint list when the user clicks a submit button in a Gallery: It works fine for one field, but when I try to add any others I get errors, and it also gives errors when I try to simply update any of the other fields. I may be starting from the wrong place. Your help will save me a ton of time, thanks in advance!
This works great and updates the SP list with the person's name from the people picker:
Patch(
'My SharePoint list',
LookUp('My SharePoint list', ID = My_Customer_BrowseGallery.Selected.MyrecordID),
{
'PersonsName': ChooseName_Request_Box.Selected
}
)
This gives errors - when I try to add the text update into other fields:
Patch(
'My SharePoint list',
LookUp('My SharePoint list', ID = My_BrowseGallery.Selected.MyrecordID),
{
'PersonsName': ChooseName_Request_Box.Selected,
'MatchStatus': "Response required",
'Followups': "Send email"
}
)
)
Curiously, the following also gives an error (when I try to update one text entry, without including the people picker) :
Patch(
'My SharePoint list',
LookUp('My SharePoint list', ID = Customer_BrowseGallery.Selected.MyrecordID),
{
'MatchStatus': "Response required",
}
)
)
Thank you again!