How to extract specific value from list/record using Custom functions in PowerQuery

[Anonymous]

@ImkeF 

Hello,

Thanks in advance for your help.

My Source is Sharepoint Online List extracting using 2.0 Beta(Required columns from default view). About 20 columns needed, all 18 columns're fine. Only 2 columns named Manager, Supervisor having the issue. I have used the below function to extract only the "title" from both the columns. These columns Manager & Supervisor showing as a list. List->Record-> with 6 rows from Sharepoint List like id, title, title, sip, email, picture, jobtitle and dept. Using the below function with created Index, I'm able to see only the value populating for first record wherein other remaining rows 're showing error.

Function used:

Record.Field([Manager]{[Index]}, "title")

Error screenshot from 2nd row:

Manager Column in PowerQuery after using the function:

Only First record values extrcated from list as Last Name, First Name(as per Sharepoint List values). I have tried changing the Datatype to text evenafter getting the same error.

Please let me know how to apply the changes, if any in the function used or we need to use some other function to get the expected results for all the records. 

Your insights would be highly appreciated, Thanks again.

Regards

Janaa

[wdx223_Daniel · Accepted solution]

Record.Field([Manager]{0}, "title")

[wdx223_Daniel · Accepted solution]

Record.Field([Manager]{0}, "title")

[Anonymous · Accepted solution]

@wdx223_Daniel : Thank you for your time. It is working as expected. I have tried with creating an index earlier which is not giving the values for all the records, now with {0} giving expected results for all records.

Record.Field([Manager]{0}, "title")

Your help & insights 're highly appreciated Daniel 🙂