Skip to main content

Notifications

Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id : ncb7/wEnbr8s2BIwArc0RQ
Power Platform Community / Forums / Power Automate - General Discussion / Parse JSON action is a...
Power Automate - General Discussion
Answered

Parse JSON action is adding line breaks

Like (0) ShareShare
ReportReport
Posted on 14 Jan 2019 19:55:54 by mboonie 164

Hi. I am using the Parse JSON action to work with a data file of >13k rows (if that's important) which then updates the information in a SharePoint list.

Unfortunately, I am finding that the results that are returned seem to have random line breaks added between words for no apparent reason. For example, in the screen shot shown here, you can see that the output of the simple, short string "Phase 2" ends up with a newline instead of a space. (Of course, I checked the input file and there are no line-breaks found there.) To compound the issue, there are rules in the list itself that use this data in other calculations and JS link formatting, but which now don't recognize the data as "valid" (i.e. "Phase\n2" <> "Phase 2"!) I find that I need to go into the list and edit out the line-breaks (which appear as an HTML "<br>") manually, even from Single Line of Text fields.

1-9-2019 11-02-09 AM.png

Does anyone else experience this? And what can be done? I tried using string substitutions, but Flow acts like the break isn't there; yet it still returns it with a break in-between the two words! This workflow already takes well over two hours to run, so I'd rather not do too much text manipulation if I don't have to.

Help!

 

Categories:
General Questions
  • Community Power Platform Member Profile Picture
    Community Power Pla... on 01 Apr 2019 at 23:01:18
    Re: Parse JSON action is adding line breaks

    thanks for the idea! tried it but did not work in my context, the output of the html to text function does not recognize the /n as a break line. 

  • mboonie Profile Picture
    mboonie 164 on 01 Apr 2019 at 19:59:06
    Re: Parse JSON action is adding line breaks

    I haven't tried it myself, but have you tried the Replace function (Replace( String, OldString, NewString )? Use '\n' for the OldString, and empty quotes '' as NewString). Here I'm using it in a Compose action, to clean the TeamName string:

    functionReplace.png

     

  • Community Power Platform Member Profile Picture
    Community Power Pla... on 01 Apr 2019 at 18:52:24
    Re: Parse JSON action is adding line breaks

    thank you for the replay. i am not as lucky as you are with my text, as am having substring function after the conversion that is throwing errors when the break lines are entered.  

  • mboonie Profile Picture
    mboonie 164 on 01 Apr 2019 at 18:20:54
    Re: Parse JSON action is adding line breaks

    Honestly, I couldn't find any way to clean it up, so I just accepted the HTML formatting as it was and made sure the destination columns were Rich Text, so the information could be pasted in without extranneous tags.

     

    Most of my data was from an unformatted source, so I was fortunate enough that most of the data was fine (in fact, BETTER than "fine") without trying to use the HTML to Text conversion. I just run my JSON through a Word VBA function to convert other things (like changing underlined Greater-Than sybmols into proper Greater-Than-Or-Equal-To, i.e. replace <u>&gt;</u> with &ge;, or replace &#34; with a JSON quote \")

     

    I could find no rhyme nor reason for the random line-breaks. It wasn't always after a set number of characters, nor did it only happen in a particular kind of JSON object. If it weren't for that, it would have been a sweet tool to use.

  • Community Power Platform Member Profile Picture
    Community Power Pla... on 01 Apr 2019 at 17:20:20
    Re: Parse JSON action is adding line breaks

    @mboonie : i am facing the same issue, how did you manage to solve the line breaks ? 

  • mboonie Profile Picture
    mboonie 164 on 17 Jan 2019 at 15:53:07
    Re: Parse JSON action is adding line breaks

    The data and schema are definitely both properly formatted. There is nothing in the content to make anything think a line break was needed at any place; each new line-break replaced a standard asc(32) space. The JSON files are 250-300kb, with the longest line of data (<=800 characters). As I mentioned, the first break is inserted exactly at position 256. Coincidence? I think not.

    As I mentioned above, if I don't use the HTML to Text converter, things come in as they should (albeit with HTML tags in the source's rich-text fields.)

    I actually used JSON Formatter (https://jsonformatter.curiousconcept.com/) to check the data, and then used the Parse JSON "Use payload to generate schema" feature to get the initial schema, which I then verified and tidied up in Notepad++.

    Yep, it's the HTML to Text that's the culprit. 

  • irisp Profile Picture
    irisp 6 on 16 Jan 2019 at 09:00:43
    Re: Parse JSON action is adding line breaks

    are you passing correct JSON data, you can test it using https://jsonformatter.org

  • mboonie Profile Picture
    mboonie 164 on 15 Jan 2019 at 14:54:13
    Re: Parse JSON action is adding line breaks

    My apologies! I stand very much corrected: it is the HTML to Text action that is introducing the line breaks, not Parse JSON, which is using the results as input.

    As an example, my test JSON file is 247,506 characters long (including asc(13) line-breaks where appropriate), and is an export from a proprietary database. Some of the data contains HTML-encoded formatting (because the database contains a number of rich-text fields, with bulleted lists, etc.) To have cleaner data, I chose to use the HTML to Text action.

    And therein lies the rub.

    That action appears to ignore the original line breaks, adding its own seemingly at random. While the first line break it adds is at position 256 (as one might expect when dealing with strings), the rest are added seemingly at random. For example, the next line is 46 characters long; the one after that is 122 characters long, etc.

    The break is never in the middle of a word, however, but always replaces a space between words. There is definitely no pattern to WHICH words or phrases are fair game, though.

    Using the "body" of the HTML to Text action, the Parse JSON action has no choice except to add the "\n" new-line character to make it legitimate JSON data. So, that action is off the hook.

    At this point, I'm just going to change the SharePoint columns to rich-text Multi-Line columns (to accomodate the user-formatted input), and tell the stakeholders that "cleaning" their verbose, formatted input is not practical at this point. (Maybe I'll try to "clean" it further downstream when displaying it; InfoPath comes to mind.)

    Nonetheless, it would be nice if that but could be addressed.

    -Boonie

     

  • Verified answer
    mboonie Profile Picture
    mboonie 164 on 15 Jan 2019 at 14:51:09
    Re: Parse JSON action is adding line breaks

    My apologies! I stand very much corrected: it is the HTML to Text action that is introducing the line breaks, not Parse JSON, which is using the results as input.

    As an example, my test JSON file is 247,506 characters long (including asc(13) line-breaks where appropriate), and is an export from a proprietary database. Some of the data contains HTML-encoded formatting (because the database contains a number of rich-text fields, with bulleted lists, etc.) To have cleaner data, I chose to use the HTML to Text action.

    And therein lies the rub.

    That action appears to ignore the original line breaks, adding its own seemingly at random. While the first line break it adds is at position 256 (as one might expect when dealing with strings), the rest are added seemingly at random. For example, the next line is 46 characters long; the one after that is 122 characters long, etc.

    The break is never in the middle of a word, however, but always replaces a space between words. There is definitely no pattern to WHICH words or phrases are fair game, though.

    Using the "body" of the HTML to Text action, the Parse JSON action has no choice except to add the "\n" new-line character to make it legitimate JSON data. So, that action is off the hook.

    At this point, I'm just going to change the SharePoint columns to rich-text Multi-Line columns (to accomodate the user-formatted input), and tell the stakeholders that "cleaning" their verbose, formatted input is not practical at this point. (Maybe I'll try to "clean" it further downstream when displaying it; InfoPath comes to mind.)

    Nonetheless, it would be nice if that but could be addressed.

    -Boonie

     

  • v-bacao-msft Profile Picture
    v-bacao-msft on 15 Jan 2019 at 09:33:39
    Re: Parse JSON action is adding line breaks

    Hi @mboonie,

     

    Could you provide specific details of your Flow configuration?

    I don't know how to rebuild your Flow like this.

    I am currently thinking about some attributes in your schema that contain spaces and the like.

    Please provide more details and we would provide suitable workaround for you.

     

    Best Regards,

    Barry

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

News and Announcements

Replay: Power Platform Community AMA - Copilot Studio | April
Welcome to the Power Platform Communities

Quick Links

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Markus Franz – Community Spotlight

We are honored to recognize Markus Franz as our April 2025 Community…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,670 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,011 Most Valuable Professional

Leaderboard

Featured topics

How to Ask for Help with Your Power Automate Workflow

Product updates

Microsoft Power Platform Community release plans