Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
My table source is from SharePoint List and the selected column - ParticipantsPickerStringId is showing in "List" by default. After extracted value, it shows the concat IDs. How to lookup the user's info from Sharepoint List- UserInformationList by using ID as key?
Solved! Go to Solution.
@XIOFEN_LIM , not very clear. You should split the list into rows to that each row have one id.
Or use split by delimiter into rows
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
@XIOFEN_LIM , not very clear. You should split the list into rows to that each row have one id.
Or use split by delimiter into rows
https://www.tutorialgateway.org/how-to-split-columns-in-power-bi/
Thanks @amitchandak ,
I get your point. Will try for it.
Before this i was think for a way to direct lookup info from other table based on the list in selected column.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
108 | |
100 | |
78 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |