how to get only specific list items in power M query

[vijaykaali811]

Hi  i am import json which comments as list column 

this list has 

totalcount number ,

comments record  and record has  following fields 

    id number 

   context text 

now i dont want multiple rows , but i extract value of context only for id=3 . how to get it. i have written getcommenttxt with list as argument and then return only text . 

but it throws errors says cannot convert from type list to type function 

How to achieve this 

[Omid_Motamedise]

The result usually in type list and you can add {2} add the end of ofrmula to reached the 3rd item. 

If it doesnt work, please provide the sample data I can provide you specific solution.

[vijaykaali811 · Accepted solution]

yes i got the answer by using recordfield funcation. thanks for your response 

[lbendlin]

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...