Forum Discussion
How do I extract values from List/Rec to text inPowerQuery when extracting data from Sharepoint List
Hi Pat,
Thanks for your response and time to look into the error. I have fixed this error this morning by just using the {0} in the existing function to extract the title alone from the list.
Record.Field([Manager]{0}, "title")
It working as expected with Lastname, Firstname in all the rows.
Thanks again for your time.
Regards
Janaa
mahoneypat Thanks for your time to look into the issue.
I have used the below function to extract only the "title". This particular column Manager is a List with 6 records 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 till end:
Column in PowerQuery:
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 function in the above or we need to use some other function to get the expected results for all the records.
Your help would be highly appreciated, Thanks in Advance.
Regards
Janaa
Not sure what's going on. A couple questions
1. Does your Index column start at 0. If not, it should (or -1 from your index) to potentially avoid the not enough elements error.
2. Have you confirmed the List in the rows that error are not empty (click to the right of the work List to preview contents). I'm guessing that's the case. You could wrap your expression in try ... otherwise to avoid the error, but that won't fix the issue (of missing data potentially).
Pat
Hi Pat,
Thanks for your response and time to look into the error. I have fixed this error this morning by just using the {0} in the existing function to extract the title alone from the list.
Record.Field([Manager]{0}, "title")
It working as expected with Lastname, Firstname in all the rows.
Thanks again for your time.
Regards
Janaa