Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
annumff
Contributor II
Contributor II

Connecting to Sharepoint List

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!  

Labels (2)
2 Replies
williejacobs
Creator
Creator

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.

 

toblakai
Contributor
Contributor

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.