Forum Discussion
MCornish
Responsive Resident
5 years agoExpanding Lists with Nulls
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
3 Replies
- Greg_Deckler
Community Champion
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
Responsive Resident
Yeah I tried that too. It gets to the first null row and then shows error and won't load any more rows
- MCornish
Responsive Resident