web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / @odata.type multi line...
Power Automate
Unanswered

@odata.type multi line of text is formated wrong

(0) ShareShare
ReportReport
Posted on by 92

Hi folks,

 

I am dealing again with a SharePoint column that is formatted incorrectly by using it and trying to put it into a CSV format. This time I have a multiline of text that is formatted as @OData.type bla bla bla......

I just like to add the value of this column to my csv export.

 

Here is my very simple flow:

AndreRadtke_0-1719859144942.png

as you can see I used a formular for "Schadensart" because this was exact the same Problem (but it was a multiple choice) and I found the solution on a blog. But for multiline of text I found nothing.

 

Does anyone have an idea how to get my text in a clean format out of this colum into my csv?

 

Thanks!

Andre

Categories:
  • creativeopinion Profile Picture
    10,508 Moderator on at

    @Andre-Radtke Are you sure your multi-line text column isn't a multi-choice column?

    creativeopinion_1-1719860237307.png

     

    The multi-line text filed will output as html and the multi-choice text field will output as JSON.

    creativeopinion_2-1719860270702.png

     

     

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution .
    Consider giving me a 👍 if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram
  • Andre-Radtke Profile Picture
    92 on at

    I am very sure, yes! It is multiline. The problem with mulit choice field is finally solved, I had the same issue with that one but got a solution. Now I have the problem with multi line of text. I have the probelm that the DIV tags are transported to the csv file I am creating with the flow and that is not what I want, I just want the values.

  • Andre-Radtke Profile Picture
    92 on at

    sorry @creativeopinion  I used the expression "odata" and that is in fact wrong. My error is with the DIV tag... my output in the excel is like 

    <div class="ExternalClassDE3B8EFA35C24BD1A85839CF8C7053F5"><p><div class="ExternalClassA106B74B640D44E3865A20E67875B3BF">Defektes Kabel</div></p></div>

     

    And I just need the VALUE "Defektes Kabel" of this field. The question is what formular I need for this?!

    Thank you 😉 

  • creativeopinion Profile Picture
    10,508 Moderator on at

    @Andre-Radtke Because the multi-text column outputs HTML, you will need to use the Html to Text action. 

    creativeopinion_0-1719930105532.png

    This action will convert the HTML to plain text.

    creativeopinion_1-1719930142920.png

     

    Use the output from this action in subsequent actions.

     

    Hope this helps!

    If I helped you solve your problem—please mark my post as a solution .
    Consider giving me a 👍 if you liked my response!

    👉 Level up your Power Automate skills by checking out my tutorials on YouTube
    👉 Tips and Tricks on TikTok and Instagram
  • Andre-Radtke Profile Picture
    92 on at

    Thank you @creativeopinion I tried it with html-to-text yesterday but I had no luck. I will try it again today. I want to export SPO List to excel and I have to iterate through several lines in the sharepoint List und of course there are multiple lines in the textfield. I don´t know exactly how to build the flow actions one by one but I will try again today.

  • Andre-Radtke Profile Picture
    92 on at

    I tried to covert and to use the output. It is OK so far, I get the content copied to my excel but there is one last problem. The output is not formatted as before. as you can see the text has no linebreaks as in HTML format. How can I achieve to keep the format with linebreaks?

    AndreRadtke_0-1719995606010.png

     

  • creativeopinion Profile Picture
    10,508 Moderator on at

    @Andre-Radtke In order for the HTML to text action to recognize and preserve these line breaks, there needs to be HTML tags such as <br> at the end of each line or for each line to be wrapped in a <p></p>.

     

    Unfortunately in the screenshot you've shared above, although it might look like there are line breaks separating each line of text—there isn't any html that marks the end of a line. 

     

    For example, it should look something like this:

    <p>2023-M008 Projectstart<br>
    2023-M009 Defining project scope<br>
    2024-M002 End of preparation work<br>
    ....

    or

    <p>2023-M008 Projectstart</p>
    <p>2023-M009 Defining project scope</p>
    <p>2024-M002 End of preparation work</p>
    ....

    In a previous post, you indicated the output was:

    <div class="ExternalClassDE3B8EFA35C24BD1A85839CF8C7053F5"><p><div class="ExternalClassA106B74B640D44E3865A20E67875B3BF">Defektes Kabel</div></p></div>

    The HTML to Text action should output:

    Defektes Kabel

    In SharePoint do you have this toggle set to Yes or No?

    creativeopinion_0-1720018039047.png

    If set to no, the output of the Multi-Line text field will be a single paragraph (<p></p>) tag.

    creativeopinion_1-1720018096309.png

     

    However, if you have the toggle set to Yes, the output may look like this. Keep in mind, this also depends on how the text is entered into the multi-line text field. 

    creativeopinion_2-1720018138222.png

    Hope this helps.

  • Andre-Radtke Profile Picture
    92 on at

    @creativeopinion thank you for your hint and advise. The toggle was switched to "NO" I tried to set it now to "YES" and I will try it again....if I can use it to get what I need 😉

     

    CHeers and have a great weekend

  • Andre-Radtke Profile Picture
    92 on at

    @creativeopinion  I am having trouble to wrap this thing into my appl to each (apply to each gets automatically created by PA). I am getting this error: 

    AndreRadtke_0-1720434033604.png

    My column is called "zubehoerfreitext" and is configured as follows: 

    AndreRadtke_1-1720434110517.png

     

    I am getting this column by get items of the sharepoint list. Then I try to "html to text" this column. PA instantly wraps a apply to each around it.

     

    I try to use it with my select statement:

    AndreRadtke_2-1720434205714.png

    I only have current item from the apply to each for use in select statement. I cannot choose any other element from dynamic content.

     

    The result is the error message is stated earlier.

     

    What am I doing wrong?

     

  • Andre-Radtke Profile Picture
    92 on at
    No  it isn't a multi-choice. It is definitely a multi line...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 229 Super User 2026 Season 2

#2
11manish Profile Picture

11manish 223 Super User 2026 Season 2

#3
Valantis Profile Picture

Valantis 136 Super User 2026 Season 2

Last 30 days Overall leaderboard