Expanding Lists with Nulls

[MCornish]

I have a dataset coming from Sharepoint that is giving me a column with lists in. 

On one column some of the rows are null and it won't let me expand it.

I would imagine the correct way to do this would be to add conditional logic but my M syntax isn't that great. 

Any help would be appreciated 

[MCornish · Accepted solution]

Found the answer here

https://community.powerbi.com/t5/Power-Query/SharePoint-List-and-null-values/m-p/1763308#M53191

[Greg_Deckler]

@MCornish Even though the interface doesn't give you the option, try adding a line like this in Advanced Editor:

Table.ExpandListColumn("Previous Step", "Assigned to")

[MCornish]

Yeah I tried that too. It gets to the first null row and then shows error and won't load any more rows