Hello,
I have the following rich text content with the following formula
"<table border='0' cellpadding='0' cellspacing='0' width='829'>" &
Concat(
galleryTopics.AllItems,
"<tr><td style='background-color:#eaedef;border:0px'><h2>" & Title & "</h2></td></tr>
<tr><td style='background-color:white;border:0px'>" &
If(IsBlank(Body),"","<b>Description:</b>" & Body) &
If(IsBlank(Feedback),"","<b>Outcome:</b> " & Feedback) &
"</td></tr><tr><td></tr></td>"
) &
"</table>"Then I merge with other data and send to onenote with that script
'OneNote(Business)'.CreatePageInSection(
If(
varNotebookVisible = false,
"newNB_created_viaTeams|$|https://aaa/teams/aaa_ING_IT/Shared Documents/General/newNB_created_viaTeams",
DropdownOneNoteNotebook.Selected.Key
),
If(
varNotebookVisible = false,
"https://www.onenote.com/api/v1.0/myOrganization/siteCollections/55d15b96-5e66-4a39-8304-e5bd9487db84/sites/e2d4aeb9-7928-4c15-a6a5-e3dfbc9b26fc/notes/sections/1-5f4d2426-5cc2-46fd-b009-b67f389004ad/pages",
DropdownOneNoteSection.Selected.pagesUrl
)
,
"<!DOCTYPE html><html><head><title>" & TextInput2.Text & "</title></head>
<body><div data-id='_default' style='position:absolute;left:48px;top:120px;width:829px;'>" & "<h3>Participants:</h3>" & GalleryMeeting.Selected.RequiredAttendees &
"<h3>Date:</h3>" & GalleryMeeting.Selected.Start &
RichTextEditor1_2.HtmlText &
"</div></body></html>"
);At the end, I have in my OneNote the following artefact \n , one for each items of my gallery before the table
I have also a quote at the beginning and the end of the note.
with this modification on the first code
aaa<table ..... I have aaa\n\n\n\n\n then my table.
How can I clean the data ?
