Copy SharePoint list items into a CSV each week - text cells contain gibberish

[Walker]

Hoping somebody can help! 

I'm using a template flow - "Copy SharePoint list items into a CSV each week" - and it's very useful.

However, in some cells of the Sharepoint list where there is a volume of text, the CSV cell contains a lot of messy code. Here's an extract where I've tried to replace the actual text in the cell with CAPITALS so you get the gist - 

<div class="ExternalClass0DEF393EE6D646A1905C453D595DAF31"><font color="#000000" face="Times New Roman" size="3">

</font><font color="#000000" face="Times New Roman" size="3">

</font></div><p><font color="#000000" face="Times New Roman" size="3">

</font><font color="#000000" face="Times New Roman" size="3">

</font><font color="#000000" face="Times New Roman" size="3">

</font><font color="#000000" face="Times New Roman" size="3">

</font></p><font color="#000000" face="Times New Roman" size="3">
</font><p style="margin&#58;0cm 0cm 0pt;"><span style="font-family&#58;&quot;arial&quot;,sans-serif;font-size&#58;10pt;"><font color="#000000">&#160;THIS IS THE FIRST LINE OF THE CONTENT TEXT&#160;<span style="font-family&#58;&quot;arial&quot;,sans-serif;font-size&#58;10pt;"><font color="#000000">AND THIS IS SOME MORE CONTENT TEXT&#160; AND AS YOU CAN SEE IT'S SURROUNDED BY A LOT OF UNSIGHTLY HTML CODING&#160; </font></span></font></span></p><p style="margin&#58;0cm 0cm 0pt;"><span style="font-family&#58;&quot;arial&quot;,sans-serif;font-size&#58;10pt;"><font color="#000000"><span style="font-family&#58;&quot;arial&quot;,sans-serif;font-size&#58;10pt;"><font color="#000000"></font></span></font></span><br></p><p style="margin&#58;0cm 0cm 0pt;"><span style="font-family&#58;&quot;arial&quot;,sans-serif;font-size&#58;10pt;"><font color="#000000"><span style="font-family&#58;&quot;arial&quot;,sans-serif;font-size&#58;10pt;

Is there a way I can clean this up as part of the flow? (Ultimately I want to be able to automatically forward this data on to business colleagues, and as it currently poresents, that is not acceptable).

Thanks a lot to anyone who can assist.

[ScottShearer]

The screen shot you included indicates that the data is in a rich text column.  Can you set the SharePoint column to be plain text instead of rich text?  That should solve the issue.

Scott

[GabrielStJohn]

Hello, @Walker!

Thank you for posting on the Flow Community Forum! Have you had an opportunity to apply @ScottShearer‘s recommendation to adapt your Flow? If yes, and you find that solution to be satisfactory, please go ahead and click “Accept as Solution” so that this thread will be marked for other users to easily identify!

Thank you for being an active member of the Flow Community!

-Gabriel
Flow Community Manager