Unanswered

OneNote and the "\n" issue that I cannot seem to solve! Help!

(1) Share

Report

Posted on by PlantBasedCajun

So I have a "Ticket System" which uses a Microsoft Form which then makes decision based on what the user needs and ultimately creates a OneNote Page where I can make notes and work on the ticket. For some reason, when I use Outlook -> OneNote, the formatting is perfect. But if I use forms to OneNote by template it is perfect as well... UNTIL you change the OneNote to HTML. In order to create a Page Title I have to use HTML or I get all of these "Untitled" OneNote Pages. Here is what I got:

One we choose whether the Form has Uploads, then it Create an "Add Page to a Section of OneNote using the Variables. Let me show you the Variable WITHOUT uploads:

I also created a Variable for Page Title:

One it decides to go through the choice of "If the Form has an Uploaded File" (which works great) it then heads towards updating the Excel Table and then creating the OneNote:

So here is what the "Create page in a section Medium No Attachments" looks like:

OK, so the "<title>" code needs to be there because I need the Page Title in OneNote to look correct and the rest is pretty simple...

This is how I typed in the Description blank on the form. You can see in the example below the "\n" is the return characters and I get a big jumble of characters.

OneNote Was Created with the Proper Title and here is the Body and Title of the OneNote Page.

Results:

So... I have tried:

Using OneNote with Formatting and not "</>" which works sometimes and sometimes not. If I do that I cannot a page title. Even if I add and UPDATE PAGE and add the title there and "REPLACE" which I end up getting a title of ""
I tried email to OneNote, but it just doesn't work right for my Flow

Help. This system is ALMOST perfect. I really need these OneNote Files to look formatted.

Some other easier Questions:

If you have Multiple Uploads of a Form, which I do... Can I have multiple files names in the Excel sheet show up like this: "upload.docx,upload2.docx,nextfile.docx..."? All I have been able to do is to get a huge list of text upload code which I have not been able to parse out.
I see in "Office 365 Options" you can display a picture of the user. Can that fall into OneNote?
Lastly, can you get the uploaded links from the Form Uploads (Which are in OneDrive) and possibly add them to your Planner Card? (See Below)

Any help I can get would be huge. Thank you in advance.

Categories:

Building flows

I have the same question (0)

All responses (14)

Answers (2)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@PlantBasedCajun

I believe you need to format your body with Div and Paragraphs/Span Tags as below:

<div style="position:absolute;left:48px;top:115px;width:624px">
Email: Text
Name:Test 2
 
</div>

Hope this Helps!

Was this reply helpful? Yes No
PlantBasedCajun 58 on at

Like (0)

Report

So basically I need to do a DIV for each line?

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@PlantBasedCajun

No One Div

and many 

Was this reply helpful? Yes No
PlantBasedCajun 58 on at

Like (0)

Report

Got it... I will try it tomorrow and let you know. Thank you!

Was this reply helpful? Yes No
PlantBasedCajun 58 on at

Like (0)

Report

So we made progress... Here is my code in my Variable:

Here is my Code in My OneNote Action:
So the Variable sits inside the Code of the OneNote Action. If I dont have the <title>TITLE</title> I cannot get a Title to show up on the OneNote Card... Which works great like this. Now that I have change the code to the DIV I get this OneNote Page:

As you can, you solved the "\n" between the Code for each Field. I am still Getting them in my Code between the and the next . I had them spaced with a return before and I got "\n\n"

Clearly the code in the OneNote is affecting this. Can I modify that? Thoughts? You are a huge help by the way.

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (1)

Report
I haven't followed this thread closely, just skimmed over it. But it seems to me that while your variable does contain valid HTML, it does still contain new lines, which OneNote is interpreting. So why not just remove them all before applying the Create Page action.

So where you are putting your variable into action, try changing it to this expression:

replace(variables('noteSubject-DIV'), decodeUriComponent('%0A'), '' )

or perhaps:

replace(variables('noteSubject-DIV'), decodeUriComponent('%0A'), ' ' )

HTML line breaks might work better.

As I said I didn't read the thread in detail, but I think this could work for you.

Was this reply helpful? Yes No
PlantBasedCajun 58 on at

Like (0)

Report
So this worked very well:
replace(variables('noteSubject-DIV'), decodeUriComponent('%0A'), '' )

So here is what it looks like now:
That made a huge Difference. Any way to remove the "\n" from the HTML in the OneNote Action:

What do you think? This code has its own "\n" as well.

Was this reply helpful? Yes No
Verified answer

Paulie78 8,422 Moderator on at

Like (1)

Report
It makes total sense, you are literally (perhaps without knowing it) inserting the newlines into your action. Change your code which is currently like:

<html> <head> <title>something</title> </head> <body> stuff here </body> </html>

To be like:

<html><head><title>something</title></head><body>stuff here</body></html>

Do you know what I mean?

Was this reply helpful? Yes No
Verified answer

PlantBasedCajun 58 on at

Like (0)

Report
I edited noteSubject-WITH-ATTACHMENT to include the <html> & <title> code:

Then used your code with that Variable in the OneNote Action:
replace(variables('noteSubject-WITH-ATTACHMENT'), decodeUriComponent('%0A'), '' )
Like so:
That did it! You were right. Thank you!

Was this reply helpful? Yes No
Paulie78 8,422 Moderator on at

Like (0)

Report

Well done, would have been nice if you marked one of my answers as your solution though!

Was this reply helpful? Yes No