Skip to main content

Notifications

Power Automate - General Discussion
Answered

Parsing JSON to string?

(0) ShareShare
ReportReport
Posted on by 74

Hello all,

 

I'm trying to create a flow that gets data from our BC environment, loops over each record getting the required data, and then puts it in to a variable for use later. Here's a snippit:

smw356239_0-1678821735095.png

It fails when it gets to the apply to each:

smw356239_1-1678821774149.png

I can confirm that it is returning JSON data, and that each field I'm looking for in the JSON output does have data in it. Any thoughts?

 

I've tried running this in incognito mode as one forum post suggested, but haven't had any success.

  • Verified answer
    swebb111 Profile Picture
    swebb111 74 on at
    Re: Parsing JSON to string?

    @SudeepGhatakNZ Sorry, it was user error. The JSON schema sample I was using was incorrect. Did an API call to the data, got another sample, replaced it, and it began working. Thanks for the quick response.

  • SudeepGhatakNZ Profile Picture
    SudeepGhatakNZ 14,231 on at
    Re: Parsing JSON to string?

    @smw356239 Are you able to provide the output of Parse JSON Belgium Production action?

     

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,567

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard