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 ?
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
208 | |
204 | |
84 | |
57 | |
35 |