cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Jdriele Advocate V
Advocate V

Concat formula return artefact

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 ?

 

Helpful resources

Announcements
secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (6,950)