Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

How do I extract values from List/Rec to text inPowerQuery when extracting data from Sharepoint List

Hello Everyone,   When I tried to extract values from Sharepoint list, one particluar column is having values as list, when I clicked on list - Record. It has the below values wherein wanted to ext...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    5 years ago

    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's avatar
mahoneypat
Microsoft Employee
5 years ago

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

 

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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