Skip to main content

11 posts tagged with "Power Query"

Power Query for Getting and Shaping Data, with Its Steps and M Formulas, in Power BI and Excel

View All Tags

Fixed: Power Query Shows [List] for a SharePoint Choice Column

· 6 min read
Jagdish Kumawat
Founder @ Dewiride

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.