Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Extract multiple names from a SharePoint People Picker field

Starting a new topic since I think my question has changed.   I had a Power BI report which pulled from a SharePoint list. This list had (among other fields) three People Picker fields. Originally ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hello. Sorry for delayed response. This is solved, but via none of the entries in this thread. I had to go back to my SharePoint list and my Flow and make structural changes to how the names/addresses are handled and that fixed everything.

    As the solution isn't really topic-appropriate to this forum I'll exclude it, but if anyone comes across this with a similar issue and needs an answer don't hesitate to contact me.

trebgatte's avatar
trebgatte
Most Valuable Professional
6 years ago

Hi Daryl,

 

You have to do this in Power Query M, not DAX. The multivalue fields are now located in FieldValuesAsText, which has to be expanded to get to the individual fields. Once that occurs, there's a number of transformations to perform. I'm working on a blog post on how to do this currently. You can use the Split column transform to separate the values.

 

Hope this helps!

--Treb

 

Check out my Power BI blog posts at https://marqueeinsights.com/tag/power-bi/