Forum Discussion
How can I format a Table vaue in a column
Most Valuable ProfessionalIt's because your lookup should be another dimension in your data model. When you have any multi-value field, you'll typically have two tables and relate them 1:many - that's why on the SharePoint end you have two lists, too - it's just dynamically showing the lookup values for you.
You can do the same thing in Power BI, where you have two tables and show concatenated values in your main table but the data itself actually "lives" in a separate table. I did a tutorial on how to set this up with SharePoint lists here if it helps - conceptually you do the exact same thing for multivalue person columns too because the person values are a lookup to a user profiles table on the back end essentially. Mentioning this because I think the tutorial example is with multivalue people but the concept is the same.
Hello christinepayton ,
I see ur vidéo and I'm not sure to iunderstand your process.
In my SP list y have the same column type as your "Request status" column but mine can contain multiple choices, that the main problème. How can I retrieve all the selected choices and display them in un cell and int a single row...
Thank you for your advices !- christinepayton
There's a bookmark for dealing with multivalue fields in the video, here is a link to the spot. I think I used a people column but the concept is the same for choice: https://www.youtube.com/watch?v=LYu3wqb2Nx4&t=525s
