cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Microsoft
Microsoft

Removing string quotations while saving data to oneNote using msFlow

i am trying to save the table from flow to OneNote but i am getting data with quotation marks, Please see below

" 

Value 

Internal Repath 

Other Repath 

Support Repath 

Acknowledged 

WFS 

Active Icm 

Forms Infra 

1 

0 

0 

1 

0 

1 

" 

also in onenote  not able to get table borders too. Please help.

2 REPLIES 2
Highlighted
Super User II
Super User II

Re: Removing string quotations while saving data to oneNote using msFlow

@Shivang 

Hi there. For the quotes, check out the replace() function.  Something like replace(<dynamic output going into onenote>, '"','')

 

The Dynamic Output part is what you're planning on putting into OneNote (before the HTML, probably), then a comma, single quote, double quote, single quote, then another comma, then two single quotes with nothing in between.  That will replace any instance of double quotes with 'nothing'.

 

For the borders, check out this article from @aprildunnam - Formatting HTML Tables in Flow

 

That should get you in the right direction.

 

Keep us posted.

-Ed

 

 

If you liked this reply, please give it a thumbs up! If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Highlighted
Microsoft
Microsoft

Re: Removing string quotations while saving data to oneNote using msFlow

HI @edgonzales  Thanks for the response and solution.

 

I did found one odd thing i.e. if we add content through flow created from templates doesn't append quotations, while if we add content created through instant flow in OneNote  appends string quotations as shown in my first post.

Difference is of API call in both cases for OneNote, have used workaround for fix.

Power Automate developers must take call on this, i guess its a bug.

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (8,152)