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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Anonymous Everyone,

 

Any help on this thread would be highly appreciated.