Multiple Values from Lookup column on SharePoint List

[HXM001]

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?

[v-jianpeng-msft · Accepted solution]

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:

Solved: Pull data from Sharepoint List LookUp column with ... - Power Platform Community (microsoft....

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.

[lbendlin]

let's assume yes. Then what?  Concatenate, explode to new rows?