Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Auto converted columns into table

Hi Expert, Is there any possible to convert the table into list as i can see connect the data from Sharepoint and it auto convert the column into table. I want Owner name in that column. In sharepoint the column type is PERSON. 
Power Query 

7 Replies

  • Try clicking the little icon top right with the two arrows.

    Then you can select the columns you want to see from the merged table...

    • Anonymous's avatar
      Anonymous
      Not applicable

      Hi PwerQueryKees Thanks for suggest. I have tried the same. When it expand No columns found. Is there any possible to convert into LIST this coloumn. So then may be i can select column i felt.

  • If you click in any cell, to the right of the word table, what does the bottom of your screen say? Can you post a screenshot?

  • Converting to a list will probably fail as well, so let's find out why expand does not work first....

    • Anonymous's avatar
      Anonymous
      Not applicable

      When click on the cell it saying as below screenshot.

      • PwerQueryKees's avatar
        PwerQueryKees
        Super User

        There's your answer. Next question is why you get an internal sever error, but that is beyond my area of expertise...