Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

SharePoint Online List column with multiple person values

Dear community,

I have two questions for you and I hope you can help me.


1. how can I get both names to be displayed in my table if there are two IDs in one column in my sharepoint list?

When I click in the column under "Transform data", not just one ID appears, but several, i.e. three names should be displayed, separated by a semicolon.

 

 

There should actually be three names below "Title" in 2015-601, but there is nothing.

 

2. Is it possible to have two relationships between two identical sharepoint lists activated at the same time? I always get the error message "There are ambiguous paths"

I would like to access another ID on the same table as you can see above in order to display a new column with a different function, which of course has a different name than the first column in "Title".

Thank you very much in advance!!

 

BR

Sebastian

General Comment
Need Help
Tips and Tricks
  • christinepayton's avatar
    christinepayton
    2 years ago

    I have a tutorial that covers multivalue person fields in Power BI here: https://youtu.be/LYu3wqb2Nx4?si=HrcP36O1IsyCpjVS&t=527 

     

    You can relate data from the list, and that's what I do there - you just relate on the ID field between the two. You can't have more than one relationship active with the same two tables at the same time, but you can have multiple dimensions related to the items table. The relationships for SharePoint data follow the same rules as all the other data sources, so the modeling strategy will be similar to any other data source. 

1 Reply

  • christinepayton's avatar
    christinepayton
    Icon for Most Valuable Professional rankMost Valuable Professional
    2 years ago

    I have a tutorial that covers multivalue person fields in Power BI here: https://youtu.be/LYu3wqb2Nx4?si=HrcP36O1IsyCpjVS&t=527 

     

    You can relate data from the list, and that's what I do there - you just relate on the ID field between the two. You can't have more than one relationship active with the same two tables at the same time, but you can have multiple dimensions related to the items table. The relationships for SharePoint data follow the same rules as all the other data sources, so the modeling strategy will be similar to any other data source.