PowerQuery transformation for Sharepoint List multiple People field

[Flip89]

Dear all,

It is quite simple. I would like to extract data from sharepoint list "multiple selection people" field. I extracted data into "Title" and "Email" fields and got an error. Not sure how to get from here to simple string representation of array of titles/emails with specified delimiter.

Thanks in advance,

Filip

[v-easonf-msft]

Hi， @Flip89 

It's a known issue when using SharePoint multi-select lookup fields in Power BI .

https://ideas.powerbi.com/ideas/idea/?ideaid=d1ecac5a-a018-4865-a581-9e48953c12ca 

It is suggested to open a support ticket to get dedicated support . 

https://powerbi.microsoft.com/en-us/support/ 

Best Regards,
Community Support Team _ Eason