Forum Discussion
Solved
Person/ People Field in SharePoint List - No Split available
Dear Community, I'm fairly new to Power Bi, trying probably something quite basic 🙈. In the SharePoint List, there are several custom fields which are of the type people/person. I crawled t...
ok, I think i solved it, turns out SharePoint List Blank is neither Blank nor null, this causes the issue.
Workaround: Replace Non List Items with null, then it works as expected:1. Add a Step:
2. in Custom Editor, replace the Step with:
#"New Step" = Table.TransformColumns( #"PreviousStep", {{"YourColumn", each if Value.Is(_,type list) then _ else null}} ),
3. Normal Split is now available:
4.
5.
Ejules
Glad you solved yourself, and thanks for sharing this non-list value issue and the resolution.😋
Paul Zheng _ Community Support Team