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

Multiple lines of Text -- "add a row into a table" -- incorrect format

Hi,

 

When I automate my list from sharepoint to an excel file all the columns work fine apart from the "multiple lines of text" columns. 

They always come out with a "<DIV Class= ........ many lines of code, instead of a string" seems like they need to be transferred into a string before they are moved from a list to an excel. 

 

Does anyone know what i'm missing?  what do i need to add to my sequence in order to get the proper text in excel.

 

examples below.

Adomo_1-1612980859571.png

Adomo_2-1612980883547.png

 

 

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
jinivthakkar
Super User
Super User

@Adomo you can turn off enhanced rich text from more options for the column.

 

jinivthakkar_1-1612991148547.png

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

 

 

View solution in original post

2 REPLIES 2
jinivthakkar
Super User
Super User

@Adomo you can turn off enhanced rich text from more options for the column.

 

jinivthakkar_1-1612991148547.png

 

--------------------------------------------------------------------------------
If this post helps answer your question, please click on “Accept as Solution” to help other members find it more quickly. If you thought this post was helpful, please give it a Thumbs Up.

 

 

View solution in original post

Adomo
Frequent Visitor

That worked thank you.

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!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Users online (2,451)