
Announcements
Hi
I am Patching a SharePoint Online List.
The New works but the Edit gives me an error.
The specified column 'CompNames' does not exist. The column with the most similar name is 'Comment'.
I don't mention CompNames in my OnSelect.
Thanks
P
The OnSelect of my Add / Update button.
If(Or(
(Len(tbRDTitle.Text) < 3),
(Len(cbRDFirmTitle.Selected.Value) = 0),
(Len(tbRDArticleLink.Text) < 10)
),
Notify("Article Title, Law Firms and Article Link must be entered!", Error),
If(vShowFormRDGallery,
//edit
Patch(
ProjectThamesRecentDevelopments, galRecentDevelopments.Selected,
{
Title:tbRDTitle.Text,
FirmTitle:cbRDFirmTitle.SelectedItems,
PublicationDate:calRDPublicationDate.SelectedDate,
ArticleLink:tbRDArticleLink.Text,
SummaryOrKeyInsight:tbRDSummary.Text,
Sentiment:(sliderSentiment.Value / 100),
Comment:tbRDComment.Text
}
);
Set(vShowFormRDForm, true);
Set(vShowFormRDGallery, true);
Notify( "Article Updated", NotificationType.Success, 5000 )
,
//new
Patch(
ProjectThamesRecentDevelopments, Defaults(ProjectThamesRecentDevelopments),
{
Title:tbRDTitle.Text,
FirmTitle:cbRDFirmTitle.SelectedItems,
PublicationDate:calRDPublicationDate.SelectedDate,
ArticleLink:tbRDArticleLink.Text,
SummaryOrKeyInsight:tbRDSummary.Text,
Sentiment:(sliderSentiment.Value / 100),
Comment:tbRDComment.Text
}
);
Set(vShowFormRDForm, false);
Set(vShowFormRDGallery, true);
Notify( "Articles Added", NotificationType.Success, 5000 )
) //if
) //if
Try
ProjectThamesRecentDevelopments,LookUp(ProjectThamesRecentDevelopments, ID= galRecentDevelopments.Selected.ID),
In the first line of your Edit section. If you comment out this line, does your Patch work when editing?
//Comment:tbRDComment.Text