topic Connecting to Sharepoint List in Connectivity & Data Prep

Connecting to Sharepoint List

annumff — Thu, 26 Oct 2023 16:02:48 GMT

I am connecting to a list on Sharepoint 365 to bring it into Qliksense.

The "Person or Group" column type from Sharepoint is coming into Qliksense as numbers. Not sure what the numbers mean - Is there any way to pull the column as a string?

Any help is appreciated. Thank you!

Re: Connecting to Sharepoint List

williejacobs — Tue, 07 Nov 2023 06:30:24 GMT

Hi @annumff

Sounds like it could be a user id.

Maybe have a look in the catalog folder, hopefully there is a corresponding key with the username.

Re: Connecting to Sharepoint List

toblakai — Wed, 08 May 2024 19:10:44 GMT

I used this video: https://www.youtube.com/watch?v=qxEoKwuKNm4 and a mapping to break up the data from a person column and link up with names/emails/etc..

If multiple users are in a single field, you'll need to clean things up.