topic Re: Office 365 Sharepoint Connector - List Lookup-Fields in Connectivity & Data Prep

Office 365 Sharepoint Connector - List Lookup-Fields

Fri, 02 Apr 2021 07:50:41 GMT

Hi together,

I have a issue with the Office 365 Sharepoint Connector. I would like to load a SP-List, but most of the Lookup-Listfields can not be loaded (they are also not in the Data Preview, but filled). The permissions for all SP-Lists are correct. Has anybody a idea or solution?

Thank you.

Re: Office 365 Sharepoint Connector - List Lookup-Fields

Darren_Ball — Mon, 13 Feb 2017 10:11:54 GMT

Hi,

I'm not sure i understand your question fully, but with the Qlik Office 365 Sharepoint Connector, it's possible to see your lists and extract values from those lists.

Can you explain to me what you're doing at the moment?

Re: Office 365 Sharepoint Connector - List Lookup-Fields

Flxvio043 — Tue, 30 May 2023 10:17:24 GMT

Hi @Darren_Ball ,

I know this is a really old Ticket but I have the Same problem. I try to load via the Sharepoint Connector Data from my SharePoint to the QlikSense. Unfortunately Lookup fields from the Sharepoint do not Show. As Example in my SharePoint I have the Field Country SubRegion and Cluster which are Lookup fields from a other table and I'm not able to load them to my Qlik. Is there any Option available now?

Re: Office 365 Sharepoint Connector - List Lookup-Fields

Roza — Tue, 30 May 2023 11:04:34 GMT

hi @Flxvio043 ,

could you kindly clarify what product do you use and what table you check? it also could be that Sharepoint returns the ID, but not the "name" value that you see on your Sharepoint page

regards,

Roza

Re: Office 365 Sharepoint Connector - List Lookup-Fields

Flxvio043 — Tue, 30 May 2023 12:29:06 GMT

Hi @Roza ,

Thanks for your anwer.

I use QlikSense Enterprise and connecting my Data with QlikSense Web connector. I hope this is what you meant, as I'm not a Qlik expert 🙂

Exactly I only get unfortunately the ID but this is not really helpful to use. Do you know a option to get the name value out of it?

kind regards,

Flavio