Append Text for a Gallery Lookup

[sajarac]

Hi there.

I am looking for some help here:

I am trying to append text to a multi line column in my share point list.

The List name = NotesComments

I have that list as a datasource in my gallery with a Lookup formula:

Sort(Split(LookUp(NotesComments, Title =varRecord.Title).Notes, "***"),Result,Descending)

Also, I have a RichTextEditor1

And to Patch the values in my SPL I have a button with the onselect=

Patch(NotesComments, Gallery3.Selected, {Notes:Gallery3.Selected.Notes & "***" & CurrentUserName.FullName & " - " & Now() & ":<br>" & RichTextEditor1.HtmlText}); Reset(RichTextEditor1)

In my Gallery 3 I have a HTMLText = ThisItem.Result

I would like to see the notes separated in my Gallery even if they are in a single cell in my column. that's why the Split Function.

But the Patch function is not working because the specific column Result" does not exist.

Could someone please point me in the right direction?

Thanks in advance

[v-xiaochen-msft]

Hi @sajarac ,

The root cause is that the second parameter of patch function is wrong.

The second parameter of the patch function requires the updated record in your NotesComments list.

Obviously, the record selected by gallery is not the record that exists in NotesComments list.

So , you could use lookup function instead of Gallery3.Selected here.

Something like this:

Patch(NotesComments, LooUp(NotesComments,<your column> = Gallery3.Selected.<column name>), {Notes:Gallery3.Selected.Notes & "***" & CurrentUserName.FullName & " - " & Now() & ":<br>" & RichTextEditor1.HtmlText}); Reset(RichTextEditor1)

Best Regards,

Wearsky

[Ramon031]

The second part of your formula refers to the result collumn of the Split function. So your Onselect button should be something like:

Patch(NotesComments,LookUp(NotesComments,ID = varRecord.ID), {Notes:Gallery3.Selected.Notes & "***" & CurrentUserName.FullName & " - " & Now() & ":
" & RichTextEditor1.HtmlText}); Reset(RichTextEditor1)

This is assuming that the varRecord variable has the SharePoint list as it source.

[sajarac]

Good morning and thank you very much both @Ramon031 and @v-xiaochen-msft . 

I have tried your solution and for some reason the formula still complaining. Now I am able to patch My NotesComments Share point list but it only keeps the last two notes.

This is what I have:

[Ramon031]

With gallery3.selected it selects only one record in the patch next to the new one. So what happens when tou try this:

Patch(NotesComments,LookUp(NotesComments,Title = varRecord.Title), {Notes:varRecord.Notes & "***" & CurrentUserName.FullName & " - " & Now() & ":
" & RichTextEditor1.HtmlText}); Reset(RichTextEditor1)

This way you have the notes collumn in a property. 

[sajarac]

Error =  Name is not valid. 'Notes' isn't recognized.

[Ramon031]

I assumed that your varRecord had all of the properties form you list. 

then we need a little workaround:

Patch(NotesComments,LookUp(NotesComments,Title = varRecord.Title), {Notes:LookUp(NotesComments,Title = varRecord.Title,Notes) & "***" & CurrentUserName.FullName & " - " & Now() & ":
" & RichTextEditor1.HtmlText}); Reset(RichTextEditor1)

[sajarac]

GREAT!!!!!

Thank you very much. I will never figure out that formula by myself. And I still don't get it but it's working now.

Last question?

I noticed an empty row at the end for. Is there a way to remove it?

If not. Now worries I am happy with the solution.

Thanks again!

🙂

[Ramon031 · Accepted solution]

A little bit of a stratch but does it help if you build the formula like this:

Patch(NotesComments,LookUp(NotesComments,Title = varRecord.Title), {Notes:LookUp(NotesComments,Title = varRecord.Title,Notes)  & CurrentUserName.FullName & " - " & Now() & ":
" & RichTextEditor1.HtmlText& "***"}); Reset(RichTextEditor1)

Cause the split function sees the delimeter at the start of your tekst, and your tekst looks like: *** Note1 *** Note2 *** Note 3.

With above formula the reuslt should be: Note1 *** Note2 *** Note 3 ***