Answered

Patch rich text editor to Sharepoint to add to existing text

(0) Share

Report

Posted on by Alderney

105

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 @Anonymous 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.

powerapps richtext editor patch issue.png

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

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!
@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

Was this reply helpful? Yes No
Alderney 105 on at

Like (0)

Report
Copy link

Link copied!
@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

Was this reply helpful? Yes No
EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!
@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}" } )

Was this reply helpful? Yes No
Alderney 105 on at

Like (0)

Report
Copy link

Link copied!

@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 )

Was this reply helpful? Yes No
Verified answer

EddieE 4,641 Moderator on at

Like (0)

Report
Copy link

Link copied!
@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.

Was this reply helpful? Yes No
Alderney 105 on at

Like (1)

Report
Copy link

Link copied!

@EddieE Thanks so much!

Was this reply helpful? Yes No