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

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous So, if I understand correctly, in Power Query Editor, find the diverging arrows in the column header to the right of the column name. Click that icon. Deselect everything and then only select the field that you want, title.

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Greg_Deckler 

 

Please find my screenshot below. There is no diverging icon present in the column to select the required text here.

Also I have tried by creating a Customcolumn to populate the text value with an Index(created New column) which I'm looking for with the below function.

 

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

 

which gives the expected result only for first record where still rest other records shows as an error as below.

 

 

Please throw some insights to move further.

 

Thanks for your efforts to get this solved.