Forum Discussion
How to use the Html.Table function to add a column that converts a HTML column into plain text
Hello,
I have a column with HTML :
And I need to add a column that converts this Column1.1 into plain text.
Is it possible to do that with the function Html.Table?
And How?
Thanks in advance
Hi pruvieros ,
Yes, please try
Html.Table([Column1.1] , {{"text",":root"}})You can also deal with error by usng try ... otherwise like so
try Html.Table([Column1.1] , {{"text",":root"}}) otherwise nullSo if you encounter an error at this point, Power Query will just return null and the query won't stop at this step.
Reference: Solved: Convert HTML to Text - Microsoft Power BI Community
Convert Data From HTML To Plain Text In Power BI (c-sharpcorner.com)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi pruvieros ,
Yes, please try
Html.Table([Column1.1] , {{"text",":root"}})You can also deal with error by usng try ... otherwise like so
try Html.Table([Column1.1] , {{"text",":root"}}) otherwise nullSo if you encounter an error at this point, Power Query will just return null and the query won't stop at this step.
Reference: Solved: Convert HTML to Text - Microsoft Power BI Community
Convert Data From HTML To Plain Text In Power BI (c-sharpcorner.com)
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.