How can i get object items from json variable?

[emreserperjp]

Hi,

In the Sharepoint list, I keep the json in the multiline of text column as in the example.

[

{"currentUserName":"Serper, Emre(Contractor)","currentTime":"6/12/2021 - 16:42","currentUserComment":"Congrats!"},{"currentUserName":"Test, Test(Contractor)","currentTime":"6/12/2021 - 16:42","currentUserComment":"Congrats!"}

]

I have this json in the CommentsJson.

I want to pass the user name and comment inside in this json file to the variables.

-I am adding the json field into compose as array.

-I'm returning in compose with apply to each. And I'm trying to add to variables.

But it gives the error in the last picture. Can you help me?

[Paulie78]

You don't need to use the array() function in your top compose action - because the item you are extracting is already an array. So you have made an array of one element which contains a string representation of inner array. Try using the same expression without wrapping it in the array() function.

[emreserperjp]

Hi @Paulie78 , when I do as you said it gives this error.

[Paulie78 · Accepted solution]

Try wrapping it in the json() function

[emreserperjp]

@Paulie78 

Great, this worked!
Thank you so much.

Can I ask one more question?

There will be more than one object in this json and they will all be returned.
If I want to get only the last object in this file, how do I go about it?

Since it will return all its objects, it will be the last in the variables, but is there a different way to do this?