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

[minyoungchoe]

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

[Nived_Nambiar]

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! 🙌

[minyoungchoe]

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"

  }

]

[minyoungchoe]

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

[Nived_Nambiar]

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! 🙌

[minyoungchoe]

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

[Nived_Nambiar]

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! 🙌

[minyoungchoe]

What about the one that set variables with Parse Json?

[Nived_Nambiar]

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! 🙌

[minyoungchoe]

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

[minyoungchoe]

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

[Nived_Nambiar]

Hi @minyoungchoe 

Just share screenshot of your flow 

Also if your requirement is to convert few SharePoint columns data to csv table format then use my approach 

It would be helpful 

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! 🙌

[minyoungchoe]

Okay,
May I ask you how do you handle this?

I want to the 'Value' of Analytical Categories only and Dynamic Value never give me only value

[Nived_Nambiar]

I think there would be a dynamic content having value of Analytical Categories with name like Analytical Categories Value 

check for that 

Else in select action while specifying the Value property , specify it's value like this 

item()?['Analytical Categories']?['Value']

Hope this helps !

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! 🙌

[minyoungchoe]

No, it does not exist that is why I was thinking like "Oh I should parse json!"... Please see below.
I really need you help 😢

[minyoungchoe]

[minyoungchoe]

I did this way and it has null

[Nived_Nambiar]

Hi @minyoungchoe 

What I meant is 

See you are using get items right ?

In the get items you have used key value pairs to select required property from the value dynamic content right ?

Then in key value corresponding to Analytical Categories, in its value section provide the above expression which I have provided in my above response.

This will help to extract the value from Analytical property  directly 🙂 

Hope this helps 

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! 🙌

[minyoungchoe]

Thank you so much...
The thing is there is nothing.

[minyoungchoe]

Hey this is how first row look like if I create a csv table without select action

[{"@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"}]