Forum Discussion

mzeppieri's avatar
mzeppieri
Regular Visitor
10 years ago
Solved

Importing Multiple Lines of Text field from SharePoint list

I have a process where my project teams fill out an InfoPath web form that then publishes their responses on the form into a SharePoint list.  The list is a mix of numerical fields, single line text ...
  • mzeppieri's avatar
    mzeppieri
    10 years ago

    There are two solutions to this issue.

     

    I was able to switch the source field in SharePoint to plain text, and in doing so, stopped the additional text from rendering in PowerBI.  This is a quick fix solution that solved my immediate need.

     

    However, the other recommended solution posted above is a more robust approach if you need to retain rich text.  I can see a scenario where I may want to retain text bullets, so I will experiment with the other approach as a long term fix to evolving my dashboard.

     

    Thank you!!!

AaronBator's avatar
AaronBator
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

Sdjensen's approach I think is the correct one. I just wanted to make sure it was clear why you were getting the div tags and other HTML elements in your data: The field that you're pulling from in SharePoint is set as Rich Text.

 

The original poster mentioned that the other fields came across fine, but the multiple lines of text field did not. It's not because it's multiple lines of text, I suspect, but because the SharePoint column definition is set to allow for Rich Text.

 

It may be completely out of your control, but if the original form/SharePoint site is something in your control, and if there's not a business need to keep the field as rich text, you might simplify things by modifying the original field.

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi Aaron,

I am facing the same issue but in my case there is a requirement for the field to be rich text as it contains web-links. Is it not possible to have an option in Power BI to convert rich text to plain text? Like a menu option under Transform. I believe it's time for that. Many thanks.