Patch rich text editor to Sharepoint to add to existing text

[Alderney]

Hi

I have an app connected to a Sharepoint contacts list.  I am wanting to add to the notes section in this list, which already has information in some cases.  I have made that column (notes (comments) ) an enhanced rich text column.

In my app I have a gallery with populated information from the sharepoint contacts list.  I have an HTML text box to show the information already in the notes(comments) column.  I added a rich text editor into the gallery, so information can be added to this column.

The first image shows the screen set up

The second image shows the patch formula I used first.  This works, however, it just changes the information not add to it. 

the third image I tried @shane Young's videos showing this formula, however, I had no joy with that either. just tells me requires title and then when I add it doesn't recognise it.

Can anyone direct me as to where i'm going wrong

[EddieE]

@Alderney 

For the notes column you should be able to just add this

Patch(
   ...
   { ...
     'Notes (Comments)': $"{ThisItem.'Notes (Comments)'}   RichTextEditor1.HtmlText"
   }
// I haven't added all of your code but hopefully this makes sense?
// You can add anything extra you want inside of the "" above but if you are using data point place them inside of {...} like I've done above

[Alderney]

@EddieEthanks for your help!

I tried your coding, and it works, however, it just puts in the last part ie RichTextEditor.HtmlText, and it put it below.

Here is my code

---

Patch(
   'NZ Schools Contacts', 
   {ID: Gallery1.Selected.ID},
   {
      Title: ThisItem.'Full Name'}, 
     {'Notes (Comments)': $"{ThisItem.'Notes (Comments)'}  RichTextEditor1.HtmlText"
   }
)

​

Result on test screen

[EddieE]

@Alderney 

Whoops, my bad, should've been this

Patch(
   'NZ Schools Contacts', 
   {ID: Gallery1.Selected.ID},
   {
      Title: ThisItem.'Full Name'}, 
     {'Notes (Comments)': $"{ThisItem.'Notes (Comments)'}  {RichTextEditor1.HtmlText}"
   }
)

​

[Alderney]

@EddieE 

Great Thanks Eddie, It's working, is there a way of doing it so it goes on the top of existing information not the bottom? Any ideas how to reset the editor, adding Reset(RichTextEditor1) doesn't work after the last )

[EddieE · Accepted solution]

@Alderney 

To show them in reverse order just reverse the way they are Patched, ie

Patch(
   'NZ Schools Contacts', 
   {ID: Gallery1.Selected.ID},
   {
      Title: ThisItem.'Full Name'}, 
     {'Notes (Comments)': $"{RichTextEditor1.HtmlText}  {ThisItem.'Notes (Comments)'}"
   }
)

To clear the RichText Editor, if you set its Default property to "" then use Reset(RichTextEditor1) this will work.

[Alderney]

@EddieE  Thanks so much!