Forum Discussion
Multiple Values from Lookup column on SharePoint List
Hello everyone,
I am trying to set up a report that displays fields from a SharePoint List.
One of the columns is a Lookup that pulls information from a separate list.
The report will show the value of an entry if only a single value is selected for the Lookup column but will read as (Blank) for entires that have multiple selections.
Is there a way to have the report read the multy selected entries?
Hi, HXM001
Thanks lbendlin . Maybe you can follow this article below:
SharePoint Online List Lookup Column - Enjoy SharePoint
In addition, you can try the following workarounds:
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
let's assume yes. Then what? Concatenate, explode to new rows?
Hi, HXM001
Thanks lbendlin . Maybe you can follow this article below:
SharePoint Online List Lookup Column - Enjoy SharePoint
In addition, you can try the following workarounds:
How to Get Your Question Answered Quickly
If it does not help, please provide more details with your desired output and pbix file without privacy information (or some sample data) .
Best Regards
Jianpeng Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
