Fixed: Power Query Shows [List] for a SharePoint Choice Column
· 6 min read
Power Query showed [List] in every cell of a SharePoint Status column, where I expected Approved, Rejected or Submitted. In SharePoint, the column turned out to be a Choice column with Allow multiple selections on, and no choices defined. Turning multiple selections off, and adding the three choices, made Power Query read it as text.
