Forum Discussion

nicv's avatar
nicv
New Member
10 years ago

Multiple choice column from SharePoint Lists

Hi. I am using a SharePoint List from Office 365 as a data source. One column I created in this list is a multiple choice one. The problem is that when I pull the data from the SharePoint List, the r...
Tips and Tricks
Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

See those little arrows pointing in opposite directions in your column? Click on that button and expand your Table in order to get the value.

  • drclowes's avatar
    drclowes
    New Member
    9 years ago

    I am trying to test Power BI analysis over a SharePoint list, and my fields also allow multiple responses (from a seperate sub list).

     

    When I query the primary table, the fields return ' [list] ' in every row regardless of what is in the actual list. How do I relate this back to the sub-list tables, or expose the responses?

     

     

     

    ID.1

    RoleID

    9

    [List]

    5

    [List]

    6

    [List]

    8

    [List]

    • Elevy's avatar
      Elevy
      New Member
      8 years ago

      Hi, 

      dealing with the same here. anyone got a solution for it?

      • docarmoc's avatar
        docarmoc
        New Member
        8 years ago

        Hello, 

        I'm facing the same problem with the multiple choices element, anyone get a solution for it?

    • docarmoc's avatar
      docarmoc
      New Member
      8 years ago

      Hlello,

      I'm facing the same problem with the multiple choices element, anyone got a solution for it?

      • christaylor3's avatar
        christaylor3
        New Member
        7 years ago

        edit query > field value as text > select columns