cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cf_amart
Frequent Visitor

Automate to create a table in OneNote

I am wanting a table to be created in OneNote from the data entered in my SharePoint site. I have my HTML set up, but when the flow runs, the table is not correct in OneNote.  

My flow looks like this:

flow1.jpg

Here is my Page Content:

 

 

<table width="100%">
   <tr>
       <td><b>Name: </b></td>
       <td>@{triggerOutputs()?['body/Client_x0020_Name']}  @{triggerOutputs()?['body/Date']} </td>
   </tr>
</table>
<br>
<strong>Notes:</strong>
<table style="padding: 5; border: 3px double solid; border-collapse: collapse; width: 100%;">
   <tr>
       <b>
           <th>Subjective</th>
           <th>Objective</th>
           <th>Assessment</th>
           <th>Plan</th>
           <th>Diagram</th>
       </b>
   </tr>
   <tr>
       <td>@{triggerOutputs()?['body/Subjective']}</td>
       <td>@{triggerOutputs()?['body/Objective']}</td>
       <td>@{triggerOutputs()?['body/Assessment']}</td>
       <td>@{triggerOutputs()?['body/Plan']}</td>
       <td><img src="https://www.myimagelinkhere.com" alt="diagram"/></td>
   </tr>
</table>

 

 

 This is what the table output looks like in OneNote:

table1.jpg

1 ACCEPTED SOLUTION

Accepted Solutions
v-bofeng-msft
Community Support
Community Support

Hi @cf_amart :

Firstly, let me explain why you encountered this problem.

The key is that the carriage return you typed is also recognized as the content in the note

Secondly, simply eliminate the carriage return in the HTML text to solve the problem. Ive made a test for your reference:

v-bofeng-msft_0-1607652915713.png

 

Reference Expression:

uriComponentToString(replace(uriComponent(outputs('Compose')), '%0A', ''))

The Result:

v-bofeng-msft_1-1607652915713.png

 

Best Regards,

Bof

View solution in original post

1 REPLY 1
v-bofeng-msft
Community Support
Community Support

Hi @cf_amart :

Firstly, let me explain why you encountered this problem.

The key is that the carriage return you typed is also recognized as the content in the note

Secondly, simply eliminate the carriage return in the HTML text to solve the problem. Ive made a test for your reference:

v-bofeng-msft_0-1607652915713.png

 

Reference Expression:

uriComponentToString(replace(uriComponent(outputs('Compose')), '%0A', ''))

The Result:

v-bofeng-msft_1-1607652915713.png

 

Best Regards,

Bof

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,376)