Skip to main content

Notifications

Power Automate - Using Connectors
Answered

Parse JSON receiving but not returning ALL Values

(0) ShareShare
ReportReport
Posted on by 23

Hey Awesome People - Need some help and looking forward to hearing about any potential solutions or experience with Parsing JSON not returning all values. The flow starts when a file is created in SharePoint folder. Then use Encodian to parse the csv file and return the JSON array. The action prior to updating a row in a table, "Parse JSON", returns most of the fields appropriately, but is returning an empty string ("") where there was actually a value. It is also moving around the order of the array but only on the Output side of the action.

On the input side of the "Parse JSON" action  the below image shows the column "Tags" with a value of "Touchscreen". It is located after the column "Customer Interactions". You can see in the below image '...interactions":"35","Tags":"Touchscreen"...'. You can see the output side of the same row showing a value of "" in the Tags column.

 

twaluk_0-1665747268515.png

Tags is the 16th column in the array when it is inputted, but on the output side of the Parse JSON action, it becomes the 57th column value of the array and returns as an empty string for the value. All other values are in the same position on the input side as the output side (I know it doesn't matter because I can just return them wherever I need to after, but it is weird that it moves and then becomes an empty string).

twaluk_1-1665747414446.png

 

I have tried to recreate the entire flow with no luck returning that one field "Tags". It is a csv file received from our support service about ticket submissions and this field, "Tags", is tied to some KPIs we are trying to track, but unsuccessfully thanks to the Parse JSON action not working. Anyone have any experience with this sort of behavior, or have any ideas how to solve it so as to retrieve ALL values? Looking forward to some awesomeness from all you awesome people.

  • twaluk Profile Picture
    twaluk 23 on at
    Re: Parse JSON not receiving but not returning ALL Values

    @Sundeep_Malik- Thanks so much for your reply!

  • Verified answer
    Sundeep_Malik Profile Picture
    Sundeep_Malik 6,480 on at
    Re: Parse JSON not receiving but not returning ALL Values

    @twaluk 

     

    I have never used that parse csv action.

    Can you try using this:

     

    Use a compose action, 

    And write:

    Split(data,',')

    This will make an array of your data.

    After that just use parse JSON.

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

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard

Featured topics