Hi @sakleboe,
Could you please share a bit more about the SP_CommentsHistory column in your SP list? Is it a Multiple line of text type column?
Based on the formula that you provided, I think there is something wrong with it. I have made a test on my side, and don't have the issue that you mentioned, please take a try with the following workaround:
Set the OnEdit property of the SharePointIntegration control to following:
Refresh('20190102_case3'); /* Add formula here */
Set(varComment, "");
Set(varCommentsHistory, ""); /* Add formula here */
Set(varCommentsHistory, SharePointIntegration.Selected.SP_CommentsHistory); /* <--Modify your formula here */
EditForm(SharePointForm1)
On your side, you should type:
Refresh('YourSPList'); /* <-- Add formula here */
Set(varComment, "");
Set(varCommentsHistory, ""); /* <--Add formula here */
Set(varCommentsHistory, SharePointIntegration.Selected.SP_CommentsHistory); /* <--Modify your formula here */
EditForm(SharePointForm1)
Set the OnSave property of the SharePointIntegration control to following:
If(
Not(IsBlank(DataCardValue6.Text)),
Set(varCommentsHistory, User().FullName & "("&Now()&"): "&DataCardValue6.Text&Char(10)&varCommentsHistory),
Set(varCommentsHistory, "")
);
SubmitForm(SharePointForm1)
On your side, it is:
If(
Not(IsBlank(DataCardValue17.Text)),
Set(varCommentsHistory, User().FullName & "("&Now()&"): "& DataCardValue17.Text&Char(10)& varCommentsHistory),
Set(varCommentsHistory, "")
);
SubmitForm(SharePointForm1)
Set the OnView property of the SharePointIntegration control to following:
Refresh('YourSPList');
Set(varCommentsHistory, SharePointIntegration.Selected.SP_CommentsHistory);
ViewForm(SharePointForm1)
Set the Default proeprty of the SP_CommentsHistory Data Card to following:
varCommentsHistory
Set the Default property of the SP_Comment Data Card to following:
varComment
Note: The SP_CommentsHistory column is a Multiple lines of text type column, which enables "Append changes to existing text" option. The SP_Comment column is also a Multiple lines of text type column.
Please check the attached GIF screenshot for more details:
Best regards,
Kris
