Qlik Community

Qlik Connectors Discussions

Discussion Board for collaboration regarding Qlik Connectors.

New Contributor II

Sharepoint 365 connector not finding lookup table data


I am having a problem when trying to extract lookup data from SharePoint 365.

The main table we are extracting includes a list of products in one cell called a multivalue field I think its called. These values are pulled from a lookup table but when I use the SharePoint 365 connector it only gives me one value. I would expect the connector to give me the multiple values in order to connect to the lookup table in Qlikview but only having one value means its missing most of the data.

When I do the simple export to excel it gives me all of the values but separated with the # and a number like #1. This is what I was hoping to get through the connector.

Any help would be great,



1 Reply

Re: Sharepoint 365 connector not finding lookup table data


Thanks for bringing this to our attention.

It looks like it's just pulling the first value from the cell.

I'll chat with the team about this to see if we can recreate and see what's going on.