Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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.