Unanswered

Please help!!! Problem with setting a variable with JSON Parse

(0) Share

Report

Posted on by minyoungchoe

112

Once Parse JSON done, It goes Set variable action as above.
However, 'Apply to each' loop 100 times as I expected but 'Apply to each2' loop only 4 times.

"Value": "Statistical/Forecasting"

"Value": "Insights/Descriptive"

"Value": "Classification"

"Value": "Machine Learning/Predictive"

The values of first row should be as above, but once 'Apply to each2' done result below.

"Value": "Statistical/Forecasting"

@jsonparse

Categories:

General topics

I have the same question (0)

All responses (20)

Answers (0)

Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @minyoungchoe

Need a quick confirmation, is it the below should be the come as first iteration value/set variable value ?

  "Value": "Statistical/Forecasting"

  "Value": "Insights/Descriptive"

  "Value": "Classification"

"Value": "Machine Learning/Predictive"

Also show me the result of parse json as well 🙂

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
minyoungchoe 112 on at

Like (0)

Report
Copy link

Link copied!

The below is the parsed JSON of first row.
YES! -> Need a quick confirmation, is it the below should be the come as first iteration value/set variable value ?
I really need your help.
[
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 3,
"Value": "Statistical/Forecasting"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 4,
"Value": "Insights/Descriptive"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 10,
"Value": "Classification"
},
{
"@odata.type": "#Microsoft.Azure.Connectors.SharePoint.SPListExpandedReference",
"Id": 5,
"Value": "Machine Learning/Predictive"
}
]

Was this reply helpful? Yes No
minyoungchoe 112 on at

Like (0)

Report
Copy link

Link copied!

@Nived_Nambiar
My final goal is create csv file with parsed JSON

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

So that csv should contain only Value property ?

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
minyoungchoe 112 on at

Like (0)

Report
Copy link

Link copied!

No there are many.
But I do that part to store parsed json

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Hi @minyoungchoe

I see you are trying to select the values from get items output.

So give a try with this approach

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
minyoungchoe 112 on at

Like (0)

Report
Copy link

Link copied!

What about the one that set variables with Parse Json?

Was this reply helpful? Yes No
Nived_Nambiar 18,136 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

I am not sure why you are using parse json action , could you share me a complete flow design, that would help me to understand things !

Thanks & Regards,
Nived N 🚀

LinkedIn: Nived N's LinkedIn
YouTube: Nived N's YouTube Channel

🔍 Found my answer helpful? Please consider marking it as the solution!
Your appreciation keeps me motivated. Thank you! 🙌

Was this reply helpful? Yes No
minyoungchoe 112 on at

Like (0)

Report
Copy link

Link copied!

Is there any way that I can share my screen ? Since this is my first time to use PowerAuutomate, I really need a help 😞

Was this reply helpful? Yes No
minyoungchoe 112 on at

Like (0)

Report
Copy link

Link copied!

If I create table and file, it saved as JSON file since the structure looks above.

Was this reply helpful? Yes No