Get value from field from within a For Each loop

(0) Share

Report

Posted on by Rosie

301

Hello,

I want to get the first value from a field within a For each loop so I can use for a value in a json file. I have tried so many things now and none work, I thought this would be really simple.

I have tried using first() it tried to create a For Each loop within the existing loop which I don't want.

I have then created a variable to put the value into and moved that out of the generated for each loop but I still get an error. I don't think really need to put it into a variable though.

I have mulitple json objects within a For Each loop they repeat the same values in some of the fields, I want to get the value of one of these fields.

Booking Ref.

This is the output from the Filter Array step, I want to get the Booking Ref value.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

CFernandes 8,504 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Hey, Why don't you try using PARSE JSON. I generated the schema using the JSON output of you Filter array

Full Flow

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Does this answer your question?

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.

Was this reply helpful? Yes No
Rosie 301 on at

Like (0)

Report
Copy link

Link copied!

@CFernandes,

First I have to split the original json objects into different sales orders which is what I am doing in the For Each 3 loop.

The Filter array then contains all the json objects for one sales order.

Regards

Rosie

Was this reply helpful? Yes No
Verified answer

Rosie 301 on at

Like (0)

Report
Copy link

Link copied!

I finally got the right format to get to the value in the json from the 'Filter array' step

first(body('Filter_array'))?['Booking Ref']

I didn't need the set variable step.

I had tried using Select which worked and was the catalyst for getting the structure of the expression correct.

Was this reply helpful? Yes No